安装
pip install xlsxwriter
注意:xlsxwriter只支持生成.xlsx文件,不支持读取。
使用
In [1]: import xlsxwriter
In [2]: workbook = xlsxwriter.Workbook('d:\\test.xlsx')
In [3]: worksheet = workbook.add_worksheet()
In [4]: worksheet.write('A1','aaa')
Out[4]: 0
In [5]: worksheet.write_url('A2',url='https://baidu.com',string='baidu')
Out[5]: 0
In [6]: worksheet.write_string('A3','bbb')
Out[6]: 0
In [7]: workbook.close()
执行完上面的命令后,就会在D盘根目录下生成一个test.xlsx文件
超长链接问题
xlsxwriter使用writer_url写入链接时也有255个字符长度限制
可以自己修改下Python36\Lib\site-packages\xlsxwriter\worksheet.py文件,把write_url函数里面校验url长度的地方注释掉,例如:
# Excel limits the escaped URL and location/anchor to 255 characters.
# tmp_url_str = url_str or ''
# if len(url) > 255 or len(tmp_url_str) > 255:
# warn("Ignoring URL '%s' with link or location/anchor > 255 "
# "characters since it exceeds Excel's limit for URLS" %
# force_unicode(url))
# return -3
下次再使用writer_url写入超长链接就不会报错了,写入后也是可以正常工作的。