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

Glossary Item Box

IsExcelFile Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Returns whether the specified file is an Excel-formatted file in BIFF8 format.

Syntax

C++

short CSpreadSheet::IsExcelFile(LPCTSTR FileName);

Visual Basic

fpSpread.IsExcelFile(ByVal FileName As String) As Integer

Parameters

The following parameter is available:

Parameter Description
FileName Path and file name of the file for which you want to return the information

Remarks

Spread can import Excel-formatted files if they are in BIFF8 format. BIFF8 format is the format used for files saved from Excel 97, Excel 2000, and Excel 2002. Call this method to determine whether the file you want to import into Spread is an Excel-formatted, BIFF8 file.

For instructions and more information about importing Excel-formatted files, see Loading an Excel-Formatted File and Excel-Formatted File Import/Export (online PDF manual). Excel-Formatted File Import/Export includes a list and description of the log message numbers.

Return Type

Value indicating file type as follows:

Value File Information
0 The file is not an Excel file in BIFF8 format, and Spread cannot open the file.
1 The file is an Excel file in BIFF8 format.
2 The file is locked or the type cannot be determined, and Spread cannot open the file.
Examples of when this value might be returned are when the file is open in Excel or if the file is in use by another application.

See Also

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

ExportToExcel, GetExcelSheetList, ImportExcelSheet methods

DLL Correspondence

SSIsExcelFile function

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