ActiveX
To save to an XML file
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
-
Use the ExportToXML method, and set the parameters as follows:
-
Set the FileName parameter to a valid path and file name.
If you do not specify an extension, Spread will add .XML.
- Set the Root parameter to specify the root element to use in the XML data.
- Set the Collection parameter to specify the collection element to use in the XML data.
- Set the Flags parameter to specify whether to save formatted or unformatted data.
-
Set the LogFile parameter to the path and file name of the log file you want the control to create.
If you do not want to generate a log file, set the LogFile parameter to "".
-
Set the FileName parameter to a valid path and file name.