Gets an array of sheet names from the specified Excel file from a 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 Storage 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 stream.
| C# | Copy Code |
|---|
string f;
f = "D:\\formula1.xls";
System.IO.FileStream s = new System.IO.FileStream(f, System.IO.FileMode.Open, System.IO.FileAccess.Read);
string[] sheetNames = null;
sheetNames = FarPoint.Web.Spread.FpSpread.GetExcelSheetNames(s);
int i;
for (i = 0; i <= sheetNames.Length - 1; i++)
{
ListBox1.Items.Add(sheetNames[i]);
}
|
| Visual Basic | Copy Code |
|---|
Dim f As String
f = "D:\formula1.xls"
Dim s As New System.IO.FileStream(f, System.IO.FileMode.Open, System.IO.FileAccess.Read)
Dim sheetNames As String()
sheetNames = FpSpread1.GetExcelSheetNames(s)
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
