第基于PyQt5制作Excel文件數據去重小工具form.addRow(self.file_paths,self.file_paths_btn)

form.addRow(self.colums_label,self.colums_text)

self.work=DataWork(self)

self.work.trigger.connect(self.update_log)

self.work.finished.connect(self.finished)

vbox=QVBoxLayout()

self.start_btn=QPushButton()

self.start_btn.setText('開始執行')

self.start_btn.clicked.connect(self.start_btn_click)

vbox.addLayout(form)

vbox.addWidget(self.start_btn)

hbox=QHBoxLayout()

hbox.addWidget(self.brower)

hbox.addLayout(vbox)

self.setLayout(hbox)

deffile_paths_btn_click(self):

paths=QFileDialog.getOpenFileNames(self,'選擇文件',os.getcwd(),'ExcelFiles(*.xlsx)')

files=paths[0]

path_strs=''

forfileinfiles:

path_strs=path_strs+file+';'

self.file_paths.setText(path_strs)

ifself.file_paths.text().strip()!='':

self.update_log('已經完成批文件路徑加載！')

else:

self.update_log('沒有選擇任何文件！')

defsave_dir_btn_click(self):

directory=QFileDialog.getExistingDirectory(self,'選擇文件夾',os.getcwd())

self.save_dir.setText(directory)

defupdate_log(self,text):

cursor=self.brower.textCursor()

cursor.movePosition(QTextCursor.End)

self.brower.append(text)

self.brower.setTextCursor(cursor)

self.brower.ensureCursorVisible()

defstart_btn_click(self):

self.start_btn.setEnabled(False)

self.work.start()

deffinished(self,finished):

iffinishedisTrue:

self.start_btn.setEnabled(True)

創建子線程，處理業務邏輯（清理Excel重復文件）

classDataWork(QThread):

trigger=pyqtSignal(str)

finished=pyqtSignal(bool)

def__init__(self,parent=None):

super(DataWork,self).__init__(parent)

self.parent=parent

self.working=True

def__del__(self):

self.working=False

self.wait()

defrun(self):

self.trigger.emit('啟動批量處理子線程...')

file_paths=self.parent.file_paths.text().strip()

colums_text=self.parent.colums_text.text().strip()

colums=[]

if','incolums_text:

colums=colums_text.split(',')

else:

colums.append(colums_text)

self.trigger.emit('獲取配置項完成！')

forfileinfile_paths.split(';'):

iffile.strip()!='':

web_sheet=pxl.load_workbook(file)

sheets=web_sheet.sheetnames

print(file)

new_file=file.split('.')[0]+'_已去重.'+file.split('.')[1]

print(new_file)

writer=pd.ExcelWriter(new_file)

forsheetinsheets:

sheet_name=sheet.title()

print(sheet_name)

self.trigger.emit('準備處理工作表名稱：'+str(sheet.title()))

data_frame=pd.read_excel(file,sheet_name=sheet_name)

print(data_frame)

repe=data_frame.duplicated(subset=colums)

repe=repe[repe]

print(data_frame.iloc[repe.index])

res=data_frame.drop_duplicates(subset=colums)

print(res)

self.trigger.emit(str(sheet.title())+'：已清除')

res.to_excel(writer,sheet_name,index=False)

writer.save()

else:

self.trigger.emit('當前文件路徑為空，繼續...')

self.trigger.emit('數據處理完成...')

self.finished.emit(True)

使用主函數啟動整個應用

if__name__=='__main__':

app=QApplication(sys.argv)

w=CandyWindow.createWindow(EDataDel(),theme='blueGreen',