用的Python2.7 下载了xlrd、和xlwt
# -*- coding: utf8 -*-
import xlrd
from xlrd import open_workbook
book = xlrd.open_workbook("E:\Python\DA\R&WT\1.xls")
print "The number of worksheets is", book.nsheets
print "Worksheet name(s):", book.sheet_names()
这是程序
然后就报错了
C:\Python27\python.exe E:/Python/DA/R&WT/RET.py
Traceback (most recent call last):
File "E:/Python/DA/R&WT/RET.py", line 5, in <module>
book = xlrd.open_workbook("E:\Python\DA\R&WT\1.xls")
File "C:\Python27\lib\site-packages\xlrd\__init__.py", line 395, in open_workbook
with open(filename, "rb") as f:
IOError: [Errno 22] invalid mode ('rb') or filename: 'E:\\Python\\DA\\R&WT\x01.xls'
请问各位大神该怎么解决这个问题?
# -*- coding: utf8 -*-
import xlrd
from xlrd import open_workbook
book = xlrd.open_workbook("E:\Python\DA\R&WT\1.xls")
print "The number of worksheets is", book.nsheets
print "Worksheet name(s):", book.sheet_names()
这是程序
然后就报错了
C:\Python27\python.exe E:/Python/DA/R&WT/RET.py
Traceback (most recent call last):
File "E:/Python/DA/R&WT/RET.py", line 5, in <module>
book = xlrd.open_workbook("E:\Python\DA\R&WT\1.xls")
File "C:\Python27\lib\site-packages\xlrd\__init__.py", line 395, in open_workbook
with open(filename, "rb") as f:
IOError: [Errno 22] invalid mode ('rb') or filename: 'E:\\Python\\DA\\R&WT\x01.xls'
请问各位大神该怎么解决这个问题?