ExportToHTMLEx Method
Applies To
fpSpread control
Description
Exports the sheet to an HTML file using the style settings from a CSS file.
Syntax
BOOL CSpreadSheet::ExportToHTMLEx(LPCTSTR FileName, BOOL AppendFlag, LPCTSTR LogFile, LPCTSTR TitleStr,LPCTSTR CSSFile, LPCTSTR TableClass, LPCTSTR TRClass,LPCTSTR TDClass,LPCTSTR THClass);
fpSpread.ExportToHTMLEx(ByVal FileName As String, ByVal AppendFlag As Boolean, ByVal LogFile As String, ByVal TitleStr As String, ByVal CSSFile As String, ByVal TableClass As String,ByVal TRClass As String, ByVal TDClass As String,ByVal THClass 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.) |
TitleStr | Title of the HTML page |
CSSFile | File that contains cascading style sheet settings |
TableClass | Class name of the table |
TRClass | Class name of the tr item in the css file |
TDClass | Class name of the td item in the css file |
THClass | Class name of the th item in the css file |
Remarks
Use this method to export 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 can use the style settings from a CSS file to format the HTML page. CSS files are used to change the appearance of a web page. TableClass, TRClass, TDClass, and THClass are used to specify the class name of the css style for that particular item.
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 ExportRangeToHTMLEx 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 ExportRangeToHTMLor ExportToHTMLEx |
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
SSExportToHTMLEx function