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("转换成功！")