从Python创建Excel XML文件 [英] Create Excel XML files from Python
本文介绍了从Python创建Excel XML文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要从Python创建Excel XML文件.
I need to create Excel XML files from Python.
Excel XML格式非常简单.我看了一个从Excel 2003保存的示例XML文件,它非常简单.
The Excel XML format is fairly simple. I looked at a a sample xml file saved from Excel 2003 and it is fairly simple.
我正在寻找一个Pythonic的现成的库来创建这样的xml文件,而不是重新创建一个.
I'm looking for a a Pythonic, ready made library to create such xml files instead of reinventing one.
我可以如下使用的东西:
Something that I can use as below:
book = Expy.Workbook()
s1 = book.add_sheet()
s1[0, 2] = "A3"
s1[0, 0] = 12
s1[0, 9] = Expy.Formula("=Sum(A1:A3)")
book.write("excelfile.xml")
有人知道吗?
xlwt似乎已经过时,仅支持python 2.x,并且似乎只写xls文件,而不是xml.
xlwt seems outdated, supporting python 2.x only, and seems to write xls files, not xml.
推荐答案
给予 pythonOffice 尝试
这篇关于从Python创建Excel XML文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文