Spread 8.0 Documentation
ExportToHTML Method
Support Options
ActiveX Reference > ActiveX Methods > ExportToHTML Method

Glossary Item Box

ExportToHTML Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Exports the portion of the sheet that contains data to an HTML file.

Syntax

C++

BOOL CSpreadSheet::ExportToHTML(LPCTSTR FileName, BOOL AppendFlag, LPCTSTR LogFile);

Visual Basic

fpSpread.ExportToHTML(ByVal FileName As String, ByVal AppendFlag As Boolean, ByVal LogFile As String) As Boolean

Parameters

The following parameters are available:

Parameter Description
FileName Path and file name of HTML file to create
AppendFlag Set to True to append export at the end of an existing file; set to False to overwrite an existing file or to create a new file.
LogFile (Obsolete. Any string provided for this parameter is ignored.)

Remarks

Use this method to export the portion of the sheet that contains data to an HTML file. The export creates an HTML file that provides the sheet's data as an HTML table. The tags used to create the HTML table conform to HTML 3.2 (or later) guidelines.

This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.

By default, HTML files created using Spread or the Spread Designer have the extension .HTM. However, you may use any extension.

If you would rather export a range in the sheet to an HTML table rather than exporting the entire sheet, call the ExportRangeToHTML method.

Tip: You might want to save to a Spread (.SS8) file in addition to exporting it to HTML so that you can open the Spread (.SS8) file for future modifications.

The following table summarizes the formats to which you can save data from a workbook or sheet:

To Save To . . . Use Method
Binary file (proprietary format) SaveToFile
Tab-delimited file SaveTabFile or SaveTabFileU
Delimited file (offers user-defined delimiters) ExportToTextFile or ExportRangeToTextFile
or ExportToTextFileU or ExportRangeToTextFileU
Excel-formatted file ExportExcelBook or ExportToExcel
HTML file ExportToHTML or ExportRangeToHTML
XML file ExportToXML or ExportRangeToXML
XML buffer ExportToXMLBuffer or ExportRangeToXMLBuffer
An array GetArray

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

Return Type

True if successful; otherwise, False.

See Also

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

Sheet property

ExportRangeToHTML method

DLL Correspondence

SSExportToHTML function

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