Spread for ASP.NET 9.0 Product Documentation
GetExcelSheetNames(Stream) Method
Example 


Stream that contains an Excel Compound Storage file
Gets an array of sheet names from the specified Excel file from a stream.
Syntax
'Declaration
 
Public Overloads Shared Function GetExcelSheetNames( _
   ByVal stream As Stream _
) As String()
'Usage
 
Dim stream As Stream
Dim value() As String
 
value = FpSpread.GetExcelSheetNames(stream)
public static string[] GetExcelSheetNames( 
   Stream 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.
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]);
}
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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FpSpread Class
FpSpread Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.