Excel to XML conversion in Excel 2003

[Hao Liang]

Does Excel 2003 have the ability to convert Excel
spreadsheet into XML with custom DDT? I know that Excel
2003 can convert Excel data into XML, but I do not know if
I can import my own DDT into Excel. thanks

 

[Stephen Bullen]

Hi Hao,

Does Excel 2003 have the ability to convert Excel
spreadsheet into XML with custom DDT? I know that Excel
2003 can convert Excel data into XML, but I do not know if
I can import my own DDT into Excel. thanks

Yes. You can attach a custom XML schema to a workbook and map each
element in the schema to a separate cell or list in the workbook. Once
you've done that, you can export the data as XML using that mapping,
resulting in an XML file that matches your custom schema.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk