大量数据写入excel报错

Traceback (most recent call last):

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\runpy.py", line 193, in _run_module_as_main

   "__main__", mod_spec)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\runpy.py", line 85, in _run_code

   exec(code, run_globals)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\xbot_interpreter.py", line 122, in <module>

   main()

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\xbot_interpreter.py", line 53, in main

   args = params.inputs()

 File "C:\Users\admin\AppData\Local\ShadowBot\users\643649617021165570\apps\10f6e09e-7a52-4e33-82aa-d5e942c6a2d4\xbot_robot\module6.py", line 110, in main

   ex();

 File "C:\Users\admin\AppData\Local\ShadowBot\users\643649617021165570\apps\10f6e09e-7a52-4e33-82aa-d5e942c6a2d4\xbot_robot\module6.py", line 98, in ex

   all_data.to_excel(writer, sheet_name='渠道回款',index=False)

 File "C:\Users\admin\AppData\Local\ShadowBot\users\643649617021165570\apps\10f6e09e-7a52-4e33-82aa-d5e942c6a2d4\venv\lib\site-packages\pandas\io\excel\_base.py", line 1020, in __exit__

   self.close()

 File "C:\Users\admin\AppData\Local\ShadowBot\users\643649617021165570\apps\10f6e09e-7a52-4e33-82aa-d5e942c6a2d4\venv\lib\site-packages\pandas\io\excel\_base.py", line 1024, in close

   content = self.save()

 File "C:\Users\admin\AppData\Local\ShadowBot\users\643649617021165570\apps\10f6e09e-7a52-4e33-82aa-d5e942c6a2d4\venv\lib\site-packages\pandas\io\excel\_openpyxl.py", line 80, in save

   self.book.save(self.handles.handle)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\workbook\workbook.py", line 408, in save

   save_workbook(self, filename)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\writer\excel.py", line 293, in save_workbook

   writer.save()

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\writer\excel.py", line 275, in save

   self.write_data()

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\writer\excel.py", line 75, in write_data

   self._write_worksheets()

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\writer\excel.py", line 215, in _write_worksheets

   self.write_worksheet(ws)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\writer\excel.py", line 200, in write_worksheet

   writer.write()

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\worksheet\_writer.py", line 356, in write

   self.write_rows()

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\worksheet\_writer.py", line 124, in write_rows

   self.write_row(xf, row, row_idx)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\worksheet\_writer.py", line 147, in write_row

   write_cell(xf, self.ws, cell, cell.has_style)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\cell\_writer.py", line 58, in etree_write_cell

   inline_string = SubElement(el, 'is')

MemoryError

Error in atexit._run_exitfuncs:

Traceback (most recent call last):

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.19.22\python\lib\site-packages\openpyxl\worksheet\_writer.py", line 32, in _openpyxl_shutdown

   os.remove(path)

PermissionError: [WinError 32] 另一个程序正在使用此文件，进程无法访问。: 'C:\\Users\\admin\\AppData\\Local\\Temp\\openpyxl.gwmmji2_'

其实数量感觉不是很多一万多条，但是写入就会报错这个，如果数量少就不会