Save or export XML data

Microsoft Office Excel 2003

previous page next page

Show All Show All

Save or 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 several methods that you can use to save or export the contents of your worksheet to an XML data file. Choose the appropriate method.

ShowSave the contents of a mapped range to an XML data file.

  1. On the File menu, click Save.

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

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

    The Export XML dialog box appears only if you have added more than one XML map to your workbook.

Note  The active workbook is now the XML data file. If you want to continue working in the original workbook, then you should close the XML data file and reopen the original workbook.

ShowExport the contents of a mapped range to an XML data file.

  1. On the List toolbar, click Exportbutton image.
  2. If the Export XML dialog box appears, then click the XML map that you want to use and then click OK.

    The Export XML dialog box appears only if you have added more than one XML map to your workbook.

  3. In the File name box, type a name for the XML data file.
  4. Click Export.

ShowSave the contents of the workbook in the XML Spreadsheet file format.

  1. On the File menu, click Save As.
  2. In the File name box, type a name for the file.
  3. In the Save as type list, click XML Spreadsheet.
  4. Click Save.
previous page start next page