Python 用win32读取excel文件的奇葩报错

来源：互联网发布：淘宝店刷排名靠前编辑：程序博客网时间：2024/06/05 06:04

from datetime import datetimeimport urllibimport win32com.client as win32import sysimport codecsimport reimport sqlite3import osimport timeimport shutilimport xlrdimport typesimport pickleimport MySQLdbimport time  import thread  # import adodb  #encoding=utf-8#encoding=utf8excel = win32.gencache.EnsureDispatch('Excel.Application')wb = excel.Workbooks.Open(r'E:\EclipseWorkSpace\PyTest\src\portdict.XLSX')ws = wb.Worksheets("Sheet2")rowcount = ws.UsedRange.Rows.Countprint rowcountportstart = []portend = []print ws.Cells(3,1).Value,ws.Cells(3,2).Valuefor i in range(0,rowcount-1):    p = ws.Cells(i,1).Value    q = ws.Cells(i,2).Value    print "this is :",i,p, q    wb.Save()wb.Close()

运行结果如下：

2791
0ORT SAID% PORT SAID,EG

Traceback (most recent call last):
File "E:\EclipseWorkSpace\PyTest\src\One.py", line 46, in <module>
p = ws.Cells(i,1).Value
File "C:\Python26\lib\site-packages\win32com\gen_py\00020813-0000-0000-C000-000000000046x0x1x7\Range.py", line 686, in __call__
, ColumnIndex)
File "C:\Python26\lib\site-packages\win32com\client\__init__.py", line 456, in _ApplyTypes_
self._oleobj_.InvokeTypes(dispid, 0, wFlags, retType, argTypes, *args),
com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, None, None, None, 0, -2146827284), None)

如果你搜 com_error: (-2147352567 这个问题，我想你肯定能搜到很多正确的回答，但是我的这个问题实在狗血，我不得不说，浪费了我一下午的光阴，最后只是因为在for i in range(0,rowcount-1): 这一句里， 不能从0开始，应该从1开始  。对，就是这么简单的问题，我真想拿块豆腐撞死啊

0 0