Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overloads Function IsExcelFile( _ ByVal fileName As String, _ ByRef workbookType As ExcelWorkbookType _ ) As Boolean | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As FpSpread Dim fileName As String Dim workbookType As ExcelWorkbookType Dim value As Boolean value = instance.IsExcelFile(fileName, workbookType) | |
| C# | |
|---|---|
public bool IsExcelFile( string fileName, ref ExcelWorkbookType workbookType ) | |
Parameters
- fileName
- Path and name of file
- workbookType
- returns the type of Excel workbook
Exceptions
| Exception | Description |
|---|---|
| System.IO.FileNotFoundException | Specified file is not found |
| System.ArgumentNullException | No file name is specified (or specified file name is null) |
| System.ArgumentException | No file name is specified (or specified file name is empty) |
Example
This example opens the excel file if it is determined to be one.
| C# | Copy Code |
|---|---|
string s = "c:\\test.xls"; bool b = fpSpread1.IsExcelFile(s, FarPoint.Excel.ExcelWorkbookType.BIFF); if (b) { fpSpread1.OpenExcel(s); } | |
| Visual Basic | Copy Code |
|---|---|
Dim s As String = "c:\test.xls" Dim b As Boolean = FpSpread1.IsExcelFile(s, FarPoint.Excel.ExcelWorkbookType.BIFF) If b Then FpSpread1.OpenExcel(s) End If | |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2