从Python创建Excel XML文件 [英] Create Excel XML files from Python

查看：173 发布时间：2020/11/1 1:36:50 python xml excel

本文介绍了从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.