IsExcelFile Method
Applies To
fpSpread control
Description
Returns whether the specified file is an Excel-formatted file in BIFF8 format.
Syntax
short CSpreadSheet::IsExcelFile(LPCTSTR FileName);
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