所以，我嘗試使用 openpyxl 用這一行打開一個 excel 文件wb_bs = openpyxl.load_workbook(filename=filepath)并得到這個錯誤：C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\styles\stylesheet.py:214: UserWarning: Workbook contains no default style, apply openpyxl's default warn("Workbook contains no default style, apply openpyxl's default")Traceback (most recent call last): wb_bs = openpyxl.load_workbook(filename=url_nova, data_only=True) File "C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\reader\excel.py", line 315, in load_workbook reader.read() File "C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\reader\excel.py", line 280, in read self.read_worksheets() File "C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\reader\excel.py", line 228, in read_worksheets ws_parser.bind_all() File "C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\worksheet\_reader.py", line 434, in bind_all self.bind_cells() File "C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\worksheet\_reader.py", line 337, in bind_cells for idx, row in self.parser.parse(): File "C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\worksheet\_reader.py", line 149, in parse obj = prop[1].from_tree(element) File "C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\descriptors\serialisable.py", line 87, in from_tree obj = desc.expected_type.from_tree(el) File "C:\Users\T-Gamer\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\descriptors\serialisable.py", line 103, in from_tree return cls(**attrib)事情是：如果我創建 .xlsx 文件，它將打開如果我從這個特定來源（我需要的來源）下載文件并嘗試立即打開它，則會生成錯誤。如果我在打開并保存 .xlsx 文件（無更改）后運行代碼，它就會起作用。我想這與Excel版本沖突有關，但我已經嘗試了所有方法，但似乎沒有任何效果。openpyxl==3.0.5 python==3.8.5
Openpyxl 無法讀取 xlsx 文件，但如果我保存該文件，它會打開
慕田峪7331174
2023-09-19 17:31:28
