How to Convert an Excel Sheet to XML format

Question

_{Friday, September 16, 2005 7:34 AM}

Dear Friends,

I have to Export the Excel Sheet into XML format.

But In the Excel Sheet I saw Data->XML-> Exports....But Exports menu is always Disable to me.

Really I dont know How to Create Well formed Excel Sheet to Export an XML file.

AnyOne can please help me or otherwise tell me How to Create a Excel Sheet with Fields..
like...

I doesn't use Excel ever before.

Thanks in Advance.

Vasanth.

All replies (2)

_{Friday, September 16, 2005 7:53 PM ✅Answered | 1 vote}

The Data > XML > Export command is not available unless you have first mapped your data as XML in the worksheet. Microsoft Office Excel 2003 cannot export the data as XML until you tell Excel what schema that the exported data should adhere to. The schema can be specified using an XML schema file (.xsd), or Excel can attempt to infer an XML schema from an XML data file (.xml). For details on how to do this, see the "Create an XML map" and "Map XML elements" sections in the Excel 2003 Help topic "Add, map, and unmap XML elements."

While you could click File > Save As and specify "XML Spreadsheet (.xml)" in the "Save as type" list, the saved workbook will adhere to the standard Excel XML Spreadsheet Schema format, which could be a bit complex for you to work with, especially extracting the raw data and/or applying transforms to the data. Note that if you try to specify "XML Data (.xml)" in the "Save as type" list, you will receive the error "cannot save XML data because the workbook does not contain any XML mappings" because an XML map is not yet applied.

Regards,
Paul Cornell
Documentation Manager
Microsoft Developer Division User Education

This posting is provided "AS IS" with no warranties, and confers no rights.

_{Tuesday, September 20, 2005 7:40 AM}

Thanks for your quick reply.

Vasanth