def unmerge(self): filename = self.file_path.text() sheetname = self.sheet_name_box.currentText() if ExistUtil.check_exists(filename, sheetname): excel_loader = ExcelLoader(filename, sheetname) workbook, worksheet = excel_loader.load_excel() logging.info("读取{}成功!".format(filename)) self.show_text("读取{}成功!".format(filename)) unmerge_tool = UnmergeTool(workbook, worksheet) new_workbook, new_worksheet = unmerge_tool.excute() new_workbook.save( filename.split('/')[-1].replace( ".xlsx", "_" + sheetname + "_unmerged.xlsx")) logging.info("解除合并单元格成功!") self.show_text("解除合并单元格成功!") self.show_text("--------------------") self.success_window.show()
def pinyin(self): filename = self.file_path.text() sheetname = self.sheet_name_box.currentText() if ExistUtil.check_exists(filename, sheetname): excel_loader = ExcelLoader(filename, sheetname) workbook, worksheet = excel_loader.load_excel() logging.info("读取{}成功!".format(filename)) self.show_text("读取{}成功!".format(filename)) transformTool3 = TransformTool3(workbook, worksheet) new_workbook = transformTool3.excute() new_workbook.save( filename.split('/')[-1].replace( ".xlsx", "_" + sheetname + "(表头转拼音).xlsx")) logging.info("表头转拼音成功!") self.show_text("表头转拼音成功!") self.show_text("--------------------") self.success_window.show()
def on_OKButton_clicked(self): filename = self.father_window.widget.file_path.text() sheetname = self.father_window.widget.sheet_name_box.currentText() if ExistUtil.check_exists(filename, sheetname): excel_loader = ExcelLoader(filename, sheetname) workbook, _ = excel_loader.load_excel() logging.info("读取{}成功!".format(filename)) self.father_window.widget.show_text("读取{}成功!".format(filename)) letter = self.ui.StripChText.text() new_workbook = StripUtil.strip(workbook, letter) new_workbook.save( filename.split('/')[-1].replace( ".xlsx", "_" + sheetname + "_stripped.xlsx")) logging.info("去除{}成功!".format(letter)) self.father_window.widget.show_text("去除{}成功!".format(letter)) self.father_window.widget.show_text("--------------------") self.success_window.show() self.close()
def on_OKButton_clicked(self): filename = self.father_window.widget.file_path.text() sheetname = self.father_window.widget.sheet_name_box.currentText() if ExistUtil.check_exists(filename, sheetname): excel_loader = ExcelLoader(filename, sheetname) workbook, worksheet = excel_loader.load_excel() logging.info("读取{}成功!".format(filename)) self.father_window.widget.show_text("读取{}成功!".format(filename)) DesensitizeUtil.desensitive(worksheet, self.ui.columnEdit.text(), self.ui.choiceBox.currentText()) logging.info("数据脱敏成功!") self.father_window.widget.show_text("数据脱敏成功") filename_desensitize = filename.split('/')[-1].replace( ".xlsx", "_" + sheetname + "(数据脱敏).xlsx") workbook.save(filename_desensitize) logging.info("保存成功") self.father_window.widget.show_text( "写入文件{}\n".format(filename_desensitize)) self.success_window.show() self.close()
def on_okButton_clicked(self): filename = self.father_window.widget.file_path.text() sheetname = self.father_window.widget.sheet_name_box.currentText() if ExistUtil.check_exists(filename, sheetname): excel_loader = ExcelLoader(filename, sheetname) workbook, worksheet = excel_loader.load_excel() logging.info("读取{}成功!".format(filename)) self.father_window.widget.show_text("读取{}成功!".format(filename)) begin_row = int(self.ui.rowBegin.text()) end_row = int(self.ui.rowEnd.text()) transformTool2 = TransformTool2(workbook, worksheet, begin_row, end_row) new_workbook = transformTool2.excute() new_workbook.save( filename.split('/')[-1].replace( ".xlsx", "_" + sheetname + "(只合并上表头).xlsx")) logging.info("转换上表头成功!") self.father_window.widget.show_text("转换上表头成功!") self.father_window.widget.show_text("--------------------") self.success_window.show() self.close()
def on_okButton_clicked(self): filename = self.father_window.widget.file_path.text() sheetname = self.father_window.widget.sheet_name_box.currentText() if ExistUtil.check_exists(filename, sheetname): excel_loader = ExcelLoader(filename, sheetname) workbook, worksheet = excel_loader.load_excel() logging.info("读取{}成功!".format(filename)) self.father_window.widget.show_text("读取{}成功!".format(filename)) data_row_begin = int(self.ui.dataRowBegin.text()) data_row_end = int(self.ui.dataRowEnd.text()) data_col_begin = str_to_int(self.ui.dataColBegin.text()) data_col_end = str_to_int(self.ui.dataColEnd.text()) transformTool1 = TransformTool1(workbook, worksheet, data_row_begin, data_row_end, data_col_begin, data_col_end) new_workbook = transformTool1.excete() new_workbook.save( filename.split('/')[-1].replace(".xlsx", "_" + sheetname + "(转置).xlsx")) logging.info("转置成功!") self.father_window.widget.show_text("转置成功!") self.father_window.widget.show_text("--------------------") self.success_window.show() self.close()
def excete(self) -> Workbook: unmerge_tool = UnmergeTool(self.workbook, self.worksheet) workbook, worksheet = unmerge_tool.excute() new_workbook = self.read_and_write(worksheet) return new_workbook if __name__ == "__main__": logging.basicConfig( level=logging.INFO, format='%(asctime)s - %(name)s - %(levelname)s - %(message)s') filename = input('请输入excel文件名.后缀名: \n') sheetname = input("请输入{}需要转换的工作表名称:\n".format(filename)) print("输入数据集的行列范围") data_row_begin = int(input('数据集起始行号:\n')) data_row_end = int(input('数据集结束行号:\n')) data_col_begin = str_to_int(input('数据集起始列号(英文字母或数字):\n')) data_col_end = str_to_int(input('数据集结束列号(英文字母或数字):\n')) if ExistUtil.check_exists(filename, sheetname): excel_loader = ExcelLoader(filename, sheetname) workbook, worksheet = excel_loader.load_excel() transformTool1 = TransformTool1(workbook, worksheet, data_row_begin, data_row_end, data_col_begin, data_col_end) new_workbook = transformTool1.excete() new_workbook.save( filename.replace(".xlsx", "_" + sheetname + "转换1.xlsx")) logging.info("转换成功!")