2020
09-29
09-29
解决python执行较大excel文件openpyxl慢问题
我就废话不多说了,大家还是直接看代码吧!talkischeapfromopenpyxlimportWorkbookfromopenpyxl.utilsimportget_column_letterfromopenpyxlimportload_workbookimporttimewb=load_workbook("E:/a.xlsx",read_only=True)sh=wb["Sheet"]#rowItem={}#forjinrange(1,2000):#foriinrange(1,30):#rowItem[get_column_letter(i)]=i#sh.append(rowItem)#wb.save("E:/a....
继续阅读 >