Excel to XML conversion in Excel 2003

  • Thread starter Thread starter Hao Liang
  • Start date Start date
H

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
 
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
Click to expand...

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
 
Back
Top