Spread 8.0 Documentation
SSExportRangeToXML Function
Support Options
DLL Reference > DLL Functions > SSExportRangeToXML Function

Glossary Item Box

SSExportRangeToXML Function


See Also    ActiveX

Applies To

fpSpread control

Description

Exports the specified range of cells in a sheet to an XML file.

Syntax

C

BOOL SSExportRangeToXML(HWND hWnd, SS_COORD lCol, SS_COORD lRow, SS_COORD lCol2, SS_COORD lRow2, LPCTSTR lpszFileName, LPCTSTR pszRoot, LPCTSTR pszCollection, long lFlags, LPCTSTR lpszLogFile);

C++

BOOL TSpread::ExportRangeToXML(SS_COORD lCol, SS_COORD lRow, SS_COORD lCol2, SS_COORD lRow2, LPCTSTR lpszFileName, LPCTSTR pszRoot, LPCTSTR pszCollection, long lFlags, LPCTSTR lpszLogFile);

Parameters

The following parameters are available:

Parameter Description
lCol Column number of first column in range to save
lRow Row number of first row in range to save
lCol2 Column number of last column in range to save
lRow2 Row number of last column in range to save
lpszFileName Path and file name of XML file to create
pszRoot Root element to use in the XML file
Do not use spaces in this string.
pszCollection Collection element to use in the XML file
Do not use spaces in this string.
lFlags Whether to export formatted or unformatted data
Use one of the following values:
Constant Description
SS_EXPORTXML_FORMATTED To export data as formatted data
SS_EXPORTXML_UNFORMATTED To export data as unformatted data
lpszLogFile Path and file name of log file to create
If you do not provide a file name, the export will not create a log file. If you do not want to create a log file, set this parameter to NULL.

Remarks

This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.

Call this function to export a range of cells from a sheet to an XML file. The export creates an XML file that provides the sheet data as a set of tagged XML elements. The XML file created conforms to XML 1.0 guidelines.

Use the Root and Collection parameters to specify the root node necessary for a valid XML file. The export uses the column headers in the sheet as the child elements within each collection element. If you provide custom text for the column headers, do not use spaces in the text; XML tags cannot contain spaces. 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.

Use the lCol, lRow, lCol2, and lRow2 parameters to specify which cells to export. For example, you can use the SSN_BLOCKSELECTED message to determine which range of cells the user has selected, and then pass those parameters to the SSExportRangeToXML function to export the selected range.

Use the lFlags parameter to specify whether formatted or unformatted data is saved to the XML file. For more information about formatted and unformatted data, see Formatted and Unformatted Data.

If you want to export an entire sheet, call the SSExportToXML function instead.

By default, XML files created using the fpSpread control or the Spread Designer have the extension .XML. However, you can use any extension.

Tip: You might want to save your sheet as a Spread (.SS8) file in addition to saving it as XML so that you can open the Spread (.SS8) file for future modifications.

The following table summarizes the formats to which you can save data:

To Save To . . . Use Function
Binary file (proprietary format) SSSaveToFile
Tab-delimited file SSSaveTabFile or SSSaveTabFileU
Delimited file (offers user-defined delimiters) SSExportToTextFile or SSExportRangeToTextFile
or SSExportToTextFileU or SSExportRangeToTextFileU
Excel-formatted file SSExportExcelBook or SSExportToExcel
HTML file SSExportToHTML or SSExportRangeToHTML
XML file SSExportToXML or SSExportRangeToXML
XML buffer SSExportToXMLBuffer or SSExportRangeToXMLBuffer
An array SSGetArray

For instructions and more information about exporting XML files, see Exporting to an XML File and XML File Export (online PDF manual). XML File Export lists and describes the method in which Spread property settings are interpreted in the XML file created.

Return Type

True if the function completes successfully; False otherwise.

See Also

Exporting to an XML File
XML File Export (online PDF manual)

SSExportRangeToXMLBuffer, SSExportToXML, SSExportToXMLBuffer, SSSetSheet functions

ActiveX Correspondence

ExportRangeToXML method

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