Exporting to an XML File
To save to an XML file
To save a portion of the sheet to an XML file
Overview
You can export a sheet or a range of data from a sheet to an XML file. The exported XML file provides the data as a set of tagged XML elements, which conforms to XML 1.0 guidelines. Data and property settings are translated into XML as explained in XML File Export Reference.
The exported XML file uses elements you specify for the root node and collection of the valid XML file. The export uses the column headers in the sheet as the child elements within each collection element. If the sheet does not contain text in the column headers, the child element tags in the XML file default to <A>, <B>, <C>, and so forth. The export ignores any row headers.
Only the cells that contain data in the specified sheet are exported to the XML file.
By default, XML files created using the fpSpread control or the Spread Designer have the extension .XML. However, you can use any extension.
Tip: Because you cannot import the XML file you save back into the Spread control, you might want to save your sheet as a Spread (.SS8) file in addition to exporting it to XML. If you want to make future modifications, you can open the Spread (.SS8) file and then resave it to XML. |
Notes: |