def onExportAll(self,event): """ """ if not self._checkInputValid(): return workbook = ConfigParser.OpenExcel(self.mConfigPath.text()) for sheet in workbook.sheets(): s = ConfigParser.ExcelSheetParser(sheet,self.mExportPath.text()) s.Export() QMessageBox.information(self,"提示","导出完成")
def onExportSelect(self,event): """ """ if not self._checkInputValid(): return #找到需要导出的表 export_sheet = [] for i in range(self.mExcelTablesList.count()): cb = self.mExcelTablesList.itemWidget(self.mExcelTablesList.item(i)) if cb.isChecked(): export_sheet.append(cb.text()) #执行导出 workbook = ConfigParser.OpenExcel(self.mConfigPath.text()) for sheet in workbook.sheets(): if sheet.name in export_sheet: s = ConfigParser.ExcelSheetParser(sheet,self.mExportPath.text()) s.Export() QMessageBox.information(self,"提示","导出完成")
def onSelectConfigPath(self,event): """ """ fname = QFileDialog.getOpenFileName(self,"选择Excel",".","Excel(*.xlsx);;Excel(*.xls);;All(*.*)") if not fname or fname[0] == '': #沒有选择文件 return excel_file = fname[0] if not excel_file.endswith(".xls") and not excel_file.endswith("xlsx"): QMessageBox.critical(self,"出错提示","请选择Excel配置表") return if not os.path.exists(excel_file): QMessageBox.critical(self,"出错提示","配置表不存在!") return self.mConfigPath.setText(excel_file) #清除旧的数据 self.mExcelTablesList.clear() workbook = ConfigParser.OpenExcel(self.mConfigPath.text()) for sheetName in workbook.sheet_names(): item = QListWidgetItem() cb = QCheckBox(sheetName) self.mExcelTablesList.addItem(item) self.mExcelTablesList.setItemWidget(item,cb)