Gets an array of sheet names from the specified Excel-compatible file.
'Declaration
Public Overloads Shared Function GetExcelSheetNames( _
ByVal As String _
) As String()
'Usage
Dim fileName As String
Dim value() As String
value = FpSpread.GetExcelSheetNames(fileName)
public static string[] GetExcelSheetNames(
string
)
Parameters
- fileName
- Path and name of file
Return Value
String array containing the names of the sheets in the Excel-compatible file
This example gets an array of sheet names from the specified Excel file.
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
String[] sheetNames = FarPoint.Win.Spread.FpSpread.GetExcelSheetNames("..\\..\\bin\\Book1.xls");
listBox1.Items.Add(sheetNames[0].ToString());
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
Dim sheetNames As [String]() = fpSpread1.GetExcelSheetNames("..\bin\Book1.xls")
ListBox1.Items.Add(sheetNames(0).ToString())
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10