Gets an array of sheet names from the specified Excel stream.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Shared Function GetExcelSheetNames( _
ByVal stream As Stream _
) As String() |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim stream As Stream
Dim value() As String
value = FpSpread.GetExcelSheetNames(stream) |
Parameters
- stream
- Stream that contains an Excel Compound Document File
Return Value
String array containing the names of the sheets in the Excel-compatible stream
Exceptions
Example
This example returns the second sheet name in the excel file.
| C# | Copy Code |
|---|
string f;
f = "D:\\formula1.xls";
System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite);
string[] xls = fpSpread1.GetExcelSheetNames(s);
MessageBox.Show(xls[1].ToString());
|
| Visual Basic | Copy Code |
|---|
Dim f As String
f = "D:\alm.xls"
Dim s As New System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite)
Dim xls As String() = FpSpread1.GetExcelSheetNames(s)
MessageBox.Show(xls(1).ToString()) |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
