Exporting data from an Excel worksheet to an XML document is similar to importing, but the steps are performed in reverse.
It is also important to remember that exporting data to an XML document is not possible without the corresponding XML schema.
So, perform the following steps:
- Open the Microsoft Excel file that also contains an XML map (see file 8-File for export.xlsx on the CD).
- Go to the Developer tab on the ribbon and in the XML group select the Export command.
- In the Export XML dialog box that appears, choose the location for the exported data and, in the File name field, enter a name for the XML file to be saved. Click the Export button.
- Make sure that the XML file you created uses UTF-8 encoding for Russian characters and that it can be viewed in a browser.
