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 containing an Excel Compound Document File
Return Value
String array containing the names of the sheets in the Excel-compatible streamExceptions
| Exception | Description |
|---|---|
| System.ArgumentNullException | No stream specified or specified stream is null |
| System.ArgumentException | No stream specified or specified stream is empty |
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 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