python将xml写入excel,从Python创建Excel XML文件

I need to create Excel XML files from Python.

The Excel XML format is fairly simple. I looked at a a sample xml file saved from Excel 2003 and it is fairly simple.

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")

Anybody know of something like that?

xlwt seems outdated, supporting python 2.x only, and seems to write xls files, not xml.

解决方案