Link Search Menu Expand Document

SSpread.ExportToXML Method

Explanation Export the spreadsheet to an XML file.

The column header is used as a child element within each collection element in XML. All row headers are ignored.

Use the ExportRangeToXML method to export a specific cell range.
Call format ExportToXML(Writer, root, collection, flags)
Return value None
Arguments Writer Export destination Writer Object
root Root element name used for XML file
collection Collection element name used for XML file
flags Specify whether to export formatted data
Specify the following values.
Constant Value Description
$ExportToXMLFormattedData 0 Export as formatted data
$ExportToXMLUnFormattedData 1 Export as unformatted data
Exception EXT-25 No valid Writer object specified
EXT-28 An error occurred in the ExportToXML method
Example of use
    var fs = new FileSystem();
    var f = fs.SaveDialog("Save", "XML File(*.xml)=*.xml", "xml", "");
    ExportToXML(f, "root", "collection", $ExportToXMLFormattedData);
    f.Close();
    
Related item ExportRangeToXML method