第二把下载的两个.gz包解压,如我把它们解压到F:DOWNLOAD下。
在win7下打开cmd,在命令行输入F:,切换到F盘,再cd DOWNLOAD\xlrd-0.7.7,
最后 setup.py install.装完了。xlwt同理。
应用
(1)xlrd
import xlrd
filename = 'E:\lianxi\protein.xls'
data = xlrd.open-workbook(filename)
sheetname = data.sheet_names()
sheet = data.sheet_by_index(0)
rows = sheet.nrows
cols = sheet.ncols
for row in range(rows):
value = sheet.row_values(row)
print value
(2)xlwt
import xlwt
filename = xlwt.Workbook ()
sheet = filename.add_sheet('name')
sheet.write(0,0,'hao123')
filename.save('test.xls')
注意:在向表单写数据的时候如果是中文很可能会抛出如下异常:
UnicodeDecodeError: 'ascii' codec can't decode byte 0xe5 in position 0
这是编码问题,需要想编码如sheet.write(0,0,'你好')改为sheet.write(0,0,'你好'.decode('UTF-8'))这里的UTF-8是指“你好”的本身编码这里只是解码(decode)一下,如果你想转换别的编码如gbk,改为'你好'.decode('utf8').encode('gbk')这样就OK了