ovejur的专栏

from PyQt5 import QtSqlfrom PyQt5.QtSql import QSqlQueryclass SwDataBase(): def __init__(self): print("数据库初始化") self.database = QtSql.QSqlDatabase.addDatabase('QSQLITE') self.database.setDatabaseName('sunward-deaps.db') .

打开文件选择框并判断是某种文件，并对编码异常进行处理 def chooseFile(self, pressed): fname = QFileDialog.getOpenFileName(self, '请选择原数据txt文件', '/') print(fname[0]) if len(fname[0]) != 0: # 如果有获取到地址，开始解析 if fname[0].find('.txt') < 0: # 确认

from openpyxl import Workbookwb = Workbook()ws = wb.active# 需要合并的左上方和右下方单元格坐标ws.merge_cells(range_string='A1:B3')ws.merge_cells(start_row=5, start_column=4, end_row=8, end_column=8)# 单元格取消合并使用unmerge_cellsws.unmerge_cells(range_string='A1:B3').