weixin_46309481的博客

原创 openpyxl处理50万行Excel数据，出现memory error问题，请教大神代码怎么修改

代码如下： import openpyxl as ops import gc wb02=ops.load_workbook(“G:/Python/Project/data.xlsx”) ws01=wb02.worksheets[0] rows_num=ws01.max_row cols_num=ws01.max_column print(rows_num,cols_num) for i in ra...