ActiveX

To save a portion of the sheet to an XML file

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Use the ExportRangeToXML method, and set the parameters as follows:
   1. Set the Col, Row, Col2, and Row2 parameters to specify the cell, row, column, or block of cells.
      Using Column and Row Properties explains valid values for the Col, Row, Col2, and Row2 parameters.
   2. Set the FileName parameter to a valid path and file name.
      If you do not specify an extension, Spread will add .XML.
   3. Set the Root parameter to specify the root element to use in the XML data.
   4. Set the Collection parameter to specify the collection element to use in the XML data.
   5. Set the Flags parameter to specify whether to save formatted or unformatted data.
   6. 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 "".