How to export data from Excel to a valid XML ?

Question

Hi

i have an excel table with some data that i would like to export in XML. This exported XML need to be valid, so after formatting it, it has to be validated against an XSD.

What's the best way to do it?

Obviously all the formatting and validation need to be done with Excel that is the only tool available.

This excel file will be used by not IT people so, the process to modify data and export it in xml need to be straightforward.

thanks Michele

Answer 1

Save your file in xml format from Excel. This is known as MS Office XML. Documentation (and schema) is available for both Office 2003 and 2007.

Answer 2

two things, write a plugin for excel, or convert the excelfile to xml and create the xsd. Edit the xml in excel and you will have the validaion in excel against that.

http://office.microsoft.com/en-us/excel/HP011429481033.aspx