xml file to xlsx file without using excel or vba

Question

I need to read an xml file (wihch has an excel format) an save as xlsx file without using excel or vba. Any suggestion??

Answer 1

pip3 install xml2xlsx
from xml2xlsx import xml2xlsx
xmlfile = '<sheet title="test"></sheet>'
f = open('test.xlsx', 'wb')
f.write(xml2xlsx(xmlfile))
f.close()

Answer 2

You need to be familiar with excel storage formatting then use a language that can manipulate it like C or c++