Export XML data

 Note   XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

There are two ways to export XML data from an Excel worksheet.

  • The recommended method of getting XML data out of your worksheet is to use the Export command on the XML submenu of the Data menu.
  • For backwards compatibility with previous XML functionality, you can still use the Save As command on the File menu.

Export XML data in mapped cells to an XML data file

  1. On the Data menu, point to XML, and then click Export.
  2. If the Export XML dialog box appears, click the XML map that you want to use, and then click OK.

The Export XML dialog box appears only if an XML list is not selected and the workbook contains more than one XML map.

  1. In the File name box, type a name for the XML data file.
  2. Click Export.

Save XML data in mapped cells to an XML data file

  1. On the File menu, click Save.

This step ensures that any changes made to your workbook won't be lost when saving as an XML data file.

  1. On the File menu, click Save As.
  2. In the File name box, type a name for the XML data file.
  3. In the Save as type list, click XML Data, and then click Save.
  4. Click Continue when you receive an alert stating that saving the file as XML data may result in the loss of features.
  5. If the Export XML dialog box appears, click the XML map that you want to use, and then click OK.

The Export XML dialog box appears only if an XML list is not selected and the workbook contains more than one XML map.

 Note   You may have headings or labels in your worksheet different from the the XML element names in the XML map. However, the XML element names are always used when you export or save XML data from the worksheet.

 
 
Applies to:
Excel 2003