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)
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