Spread 8.0 Documentation
Exporting to an XML File
Support Options
User's Guide > Working with the Control > Saving Data > Exporting to an XML File

Glossary Item Box

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:
  • The Spread version 7 ActiveX controls are safe for scripting. If you are using the Spread ActiveX control in a container that supports IObjectSafety such as Internet Explorer 4, the user cannot export or save files.
  • Turn off virtual mode before exporting a sheet to an XML file.

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.