def Orderbackup(self): ex = ExcelTool() path = 'D://code/Orders.xls' sheet_name = 'Orders' value_title = [["Start time","start region","Used","Price","End time","End eegion"]] ex.WriteExcle(path,sheet_name,value_title) ex.WriteExcAp(path,self.D_backup)
def openXlsx(self): if xlsxtool.checkExtName(self.sourcefile, '.xlsx') or xlsxtool.checkExtName(self.sourcefile, ".xls"): self.xbook = ExcelTool(self.sourcefile) if not self.xbook.getWorkbookEx(): print( "打开文件失败" ) return
def __initXlsx(self): self.xbook = ExcelTool(self.infile) while not self.xbook.getWorkbook(forcedClose = True): xlsxtool.exportMenu(EXPORT_INFO_RTEXCEL, OCallback = self.resetXlsx)
def getWorkbook(): dirs, filename = os.path.split(self.dstfile) if not os.path.isdir(dirs): os.makedirs(dirs) return ExcelTool(self.dstfile)
def update_vfix (conf): if not os.path.exists(conf['vfixmpx']): print ("*APPLYING FIX") t = ExcelTool (conf['vindexconf'], conf['lvlupmpx'], '..') t.apply_fix (conf['vfixmpx'])
def getData(self): ex = ExcelTool() self.D = ex.readExcToInt(self.path) return self.D
def __initXlsx(self): self.xbook = ExcelTool(self.infile) self.xbook.getWorkbook()