CODEWITHSUNDEEP
xmlxsdxlsx
Kammy
Kammy

Reputation: 431

how to save xlsx (office 2007) file as XML file format

I am trying to save office 2007 xlsx file to xml file format so that i can read it programmatically.

While saving xlsx file as xml it gives error "Cannot save XML data bcoz workbook doesnt content XML mapping."

I have found that I need to add XML mapping first and then It is possible. On Office 2007 site they have mentioned that first import xsd file for XML mapping and then it can be saved as XML file format.

So Please anyone tell me how to create xsd file from xlsx file.

Also tell me what could be done to save file as xml file other than this approach.

Note: I could not use any external tool to convert xlsx to xml because User have to create file xml file using "save as".

I was using Convert xls of softinterface which convert xlsx file to xml office 2007 format. But this software is can work on windows only. My server is Linux.

Upvotes: 4

Views: 22586

Answers (1)

Codo
Codo

Reputation: 78815

The easiest way is probably to instruct your users to save it in the "XML Spreadsheet 2003" format. That XML format is easy to understand and straightforward for further processing.

With that format, you don't need not XML mapping, no schema file etc.

Upvotes: 6

Related Questions