Link Search Menu Expand Document

SSpread.ExportRangeToXML Method

Explanation Export a specific range of cells to an XML file.

A cell range specification has been added to the functionality of the ExportToXML method.
Call format ExportRangeToXML(col, row, col2, row2, Writer, root, collection, flags)
Return value None
Arguments col Start column number of cell range to export
row Start row number of cell range to export
col2 Last column number of cell range to export
row2 Last row number of cell range to export
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 ExportRangeToXML method
Example of use
    var fs = new FileSystem();
    var f = fs.SaveDialog("Save", "XML File(*.xml)=*.xml", "xml", "");
    ExportRangeToXML(1, 1, 10, 10, f, "root", "collection", $ExportToXMLFormattedData);
    f.Close();
    
Related item ExportToXML method