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

Glossary Item Box

ExportExcelBookEx Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Exports the workbook to the specified Excel-formatted file.

Syntax

C++

BOOL CSpreadSheet::ExportExcelBookEx(LPCTSTR FileName, LPCTSTR LogFileName,SHORT Flags);

Visual Basic

fpSpread.ExportExcelBookEx(ByVal FileName As String, ByVal LogFileName As String, Flags AsExcelSaveFlagConstants ) As Boolean

Parameters

The following parameters are available:

Parameter Description
FileName Path and file name of Excel-formatted file to create
LogFileName 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 "".
Flags Setting to control whether formulas are exported

Constant Value Description
SS_EXCELSAVEFLAGNONE 0 No flags are set
SS_EXCELSAVEFLAG_NOFORMULAS 1 No formulas are saved

Remarks

Use this method to export the contents of the Spread control to an Excel-formatted file, which does not contain formulas.

When you export, you can choose to have Spread create a log file that details how certain data and cell characteristics are handled during the export. To have Spread create an export log file, specify the path and file name in the LogFileName parameter. If you do not specify a path, Spread will place the log file in the current drive and directory. Use the Flags parameter to specify whether to include formulas. Avoid using characters in the sheet name that Excel considers invalid such as ? / \ * [ ].

By default, Excel-formatted files created using Spread or the Spread Designer have the extension .XLS. However, you may use any extension.

Return Type

True if successful; otherwise, False.

See Also

Exporting to an Excel-Formatted File
Excel-Formatted File Import/Export (online PDF manual)

ExportToExcel, GetExcelSheetList, ImportExcelBook, ImportExcelSheet, IsExcelFile methods

DLL Correspondence

SSExportExcelBookEx function

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