目录
本文将以最快最直观的方式让您学会xlwt。(未完工,等闲的时候完成)
xlwt基础操作
步骤 | 语句 | 参数解释 |
---|---|---|
设置编码 | workbook = xlwt.Workbook(encoding = ‘utf-8’) | |
创建sheet | worksheet = workbook.add_sheet(‘My Worksheet’) | |
写入excell | worksheet.write(1,0, label = ‘this is test’) | 行, 列, 内容 |
添加连接 | worksheet.write(0, 0, xlwt.Formula(‘HYPERLINK(“http://www.google.com”;“Google”)’)) | 行, 列, 内容 |
合并单元格并写入 | worksheet.write_merge(1, 2, 0, 3, ‘Second Merge’) | 开始行,结束行, 开始列, 结束列, 内容 |
保存 | workbook.save(‘Excel_test.xls’) |
如下所示为最快写入并保存一个名字为Excel_test.xls的例子:
import xlwt
workbook = xlwt.Workbook(encoding = 'utf-8')
worksheet = workbook.add_sheet('My Worksheet')
worksheet.write(1,0, label = 'this is test')
workbook.save('Excel_test.xls')