load_workbook locks file, even after close
When I use load_workbook, it locks the file, preventing saving, deleting, or moving the file in Explorer until python is exited.
OS: Windows 10
Python 3.12.2
openpyxl==3.1.2
MRE:
import os
wb=Workbook()
wb.save('test.xlsx')
wb.close()
wb2=load_workbook('test.xlsx`)
wb2.close()
os.remove('test.xlsx')
PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'test.xlsx'