GetExcelSheetNames(String) Method

Gets an array of sheet names from the specified Excel file.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shared Function GetExcelSheetNames( _
   ByVal fileName As String _
) As String()

'Usage
 
Dim fileName As String
Dim value() As String
 
value = FpSpread.GetExcelSheetNames(fileName)

public static string[] GetExcelSheetNames( 
   string fileName
)

Parameters

fileName: Path and filename of Excel file

Return Value

String array with names of the sheets in the Excel file

Example

This example gets the names of the individual spreadsheets in a workbook of the specified Excel file.

string[] sheetNames = null;
sheetNames = FarPoint.Web.Spread.FpSpread.GetExcelSheetNames("D:\\ALM.xls");
int i;
for (i = 0; i <= sheetNames.Length - 1; i++)
{
    ListBox1.Items.Add(sheetNames[i]);
}

Visual Basic

Dim sheetNames As String() = Nothing
sheetNames = FpSpread1.GetExcelSheetNames("D:\ALM.xls")
Dim i As Integer
For i = 0 To sheetNames.Length - 1
    ListBox1.Items.Add(sheetNames(i))
Next

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
Overload List