Visual Basic (Declaration) | |
---|---|
Public Overloads Shared Function GetExcelSheetNames( _ ByVal fileName As String _ ) As String() |
Visual Basic (Usage) | Copy Code |
---|---|
Dim fileName As String Dim value() As String value = FpSpread.GetExcelSheetNames(fileName) |
Parameters
- fileName
- Path and name of file
Return Value
String array containing the names of the sheets in the Excel-compatible fileException | 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) |
This example gets an array of sheet names from the specified Excel file.
C# | Copy Code |
---|---|
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()); |
Visual Basic | Copy Code |
---|---|
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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8