最近同事要做大批量同樣格式的excel處理，想用python來嘗試處理，但是簡單的打開檔案讀取就報錯。無語啊。
請求大家幫忙啊。
程式很簡單就是網上的教學模板：
import xlwings as xw
app=xw.App(visible=True,add_book=False)
wb=app.books.open(r'F:\test.xlsx')
# wb就是新建的作業簿(workbook)，下面則對wb的sheet1的A1單元格賦值
wb.sheets['sheet1'].range('A1').value='https://bbs.csdn.net/topics/苦短'
wb.save()
wb.close()
app.quit()
F:\test.xlsx檔案以及建好，用excel可以正常打開。
測驗運行報錯：
Traceback (most recent call last):
File "D:\python\lib\site-packages\xlwings\_xlwindows.py", line 447, in __call__
return Book(xl=self.xl(name_or_index))
File "D:\python\lib\site-packages\xlwings\_xlwindows.py", line 155, in __call__
v = self._inner(*args, **kwargs)
File "D:\python\lib\site-packages\win32com\client\dynamic.py", line 197, in __call__
return self._get_good_object_(self._oleobj_.Invoke(*allArgs),self._olerepr_.defaultDispatchName,None)
pywintypes.com_error: (-2147352567, '發生意外。', (0, None, None, None, 0, -2147352565), None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:\python\lib\site-packages\xlwings\main.py", line 2974, in open
impl = self.impl(name)
File "D:\python\lib\site-packages\xlwings\_xlwindows.py", line 449, in __call__
raise KeyError(name_or_index)
KeyError: 'test.xlsx'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "F:\open_excel.py", line 3, in <module>
wb=app.books.open(r'F:\test.xlsx')
File "D:\python\lib\site-packages\xlwings\main.py", line 2980, in open
impl = self.impl.open(fullname, update_links, read_only, format, password, write_res_password,
File "D:\python\lib\site-packages\xlwings\_xlwindows.py", line 465, in open
return Book(xl=self.xl.Open(fullname, update_links, read_only, format, password, write_res_password,
File "D:\python\lib\site-packages\xlwings\_xlwindows.py", line 66, in __call__
v = self.__method(*args, **kwargs)
File "<COMObject <unknown>>", line 5, in Open
pywintypes.com_error: (-2147417851, '服務器出現意外情況。', None, None)
[Finished in 23.7s]
完全不知道什么原因，還要花23.7s，而且已經確認F:\test.xlsx沒有打開，沒有被占用。
但是錯誤原因完全看不明白。
uj5u.com熱心網友回復：
用 openpyxl模塊試試uj5u.com熱心網友回復：
頂一下，別沉了，沒人知道怎么解決么，還是想試試用xlwings。轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/13275.html
上一篇：過濾
下一篇：頭像