问题遇到的现象和发生背景
只要保存，就会报错
问题相关代码，请勿粘贴截图
wb= openpyxl.Workbook()
ws = wb.active
x=1
for i in range(1,10+1):
for j in range (1,10+1):
cell= ws.cell(i,j)
cell.value= x
x+=1
print(ws.cell(1,2).value)
ws.merge_cells('a1:a2')
ws.unmerge_cells("a1:a2")
ws.insert_cols(0,2)
ws.insert_rows(0,3)
ws.delete_cols(0,2)
wb.save(r'd:\test2.xlsx')
wb.close()
运行结果及报错内容
C:\Users\x00414291\PycharmProjects\pythonProject1\venv\Scripts\python.exe C:/Users/x00414291/PycharmProjects/pythonProject1/main.py
2
Traceback (most recent call last):
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\utils\cell.py", line 110, in get_column_letter
return _STRING_COL_CACHE[idx]
KeyError: 0
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\x00414291\PycharmProjects\pythonProject1\main.py", line 28, in
wb.save(r'd:\test2.xlsx')
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\workbook\workbook.py", line 407, in save
save_workbook(self, filename)
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\writer\excel.py", line 293, in save_workbook
writer.save()
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\writer\excel.py", line 275, in save
self.write_data()
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\writer\excel.py", line 75, in write_data
self._write_worksheets()
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\writer\excel.py", line 215, in _write_worksheets
self.write_worksheet(ws)
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\writer\excel.py", line 200, in write_worksheet
writer.write()
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\worksheet_writer.py", line 358, in write
self.write_top()
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\worksheet_writer.py", line 100, in write_top
self.write_dimensions()
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\worksheet_writer.py", line 70, in write_dimensions
dim = SheetDimension(ref())
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\worksheet\worksheet.py", line 396, in calculate_dimension
return f"{get_column_letter(min_col)}{min_row}:{get_column_letter(max_col)}{max_row}"
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\utils\cell.py", line 112, in get_column_letter
raise ValueError("Invalid column index {0}".format(idx))
ValueError: Invalid column index 0
Error in atexit._run_exitfuncs:
Traceback (most recent call last):
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\worksheet_writer.py", line 32, in _openpyxl_shutdown
os.remove(path)
PermissionError: [WinError 32] 另一个程序正在使用此文件，进程无法访问。: 'C:\Users\X00414~1\AppData\Local\Temp\openpyxl.7mmq2qyx'
Exception ignored in: <generator object WorksheetWriter.get_stream at 0x000001DADBD50EB0>
Traceback (most recent call last):
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\openpyxl\worksheet_writer.py", line 300, in get_stream
File "C:\Users\x00414291\AppData\Local\Programs\Python\Python39\lib\contextlib.py", line 124, in exit
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\et_xmlfile\xmlfile.py", line 50, in element
File "C:\Users\x00414291\PycharmProjects\pythonProject1\venv\lib\site-packages\et_xmlfile\xmlfile.py", line 77, in _write_element
File "C:\Users\x00414291\AppData\Local\Programs\Python\Python39\lib\xml\etree\ElementTree.py", line 1109, in tostring
File "C:\Users\x00414291\AppData\Local\Programs\Python\Python39\lib\xml\etree\ElementTree.py", line 732, in write
File "C:\Users\x00414291\AppData\Local\Programs\Python\Python39\lib\contextlib.py", line 117, in enter
File "C:\Users\x00414291\AppData\Local\Programs\Python\Python39\lib\xml\etree\ElementTree.py", line 801, in _get_writer
LookupError: unknown encoding: us-ascii