Example #1
0
 def __init__(self,filepath):
     parseSpreadsheet.__init__(self, filepath)
     self.__filepath=filepath
     self.__xlApp, self.__xlWb = self.__openExcelDispatch(self.__filepath)
     __sheets = self.__xlWb.Sheets
     self.sheetnames = []
     for i in xrange(0,__sheets.count):
         if __sheets[i].Name[0] == 'Q':
             self.sheetnames.append(__sheets[i].Name)
Example #2
0
 def __init__(self,filepath):
     parseSpreadsheet.__init__(self, filepath)
     self.__filepath=filepath
     self.sheetnames = [u'Q1 GeneralData', 
           u'Q2 EnergyConsumption', 
           u'Q3_ Processes', 
           u'Q3A', 
           u'Q4H_HeatGeneration', 
           u'Q4C_ColdGeneration', 
           u'Q5_Distribution', 
           u'Q6_HeatRecovery', 
           u'Q7_ Renewables', 
           u'Q8 Buildings', 
           u'Q9 Economics']
     
     self.xmlString = self.readOOContent(self.__filepath)
 def __init__(self,filepath,mysql_username,mysql_password):
     parseSpreadsheet.__init__(self, filepath)
     self.__filepath=filepath
     self.__username = mysql_username
     self.__password = mysql_password