Spread for ASP.NET 7.0 Product Documentation
GetExcelSheetNames(String,String) Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class > GetExcelSheetNames Method : GetExcelSheetNames(String,String) Method


fileName
Path and filename of Excel file
password
The password

Glossary Item Box

Gets an array of sheet names from the specified Excel file.

Syntax

Visual Basic (Declaration) 
Public Overloads Shared Function GetExcelSheetNames( _
   ByVal fileName As String, _
   ByVal password As String _
) As String()
Visual Basic (Usage)Copy Code
Dim fileName As String
Dim password As String
Dim value() As String
 
value = FpSpread.GetExcelSheetNames(fileName, password)
C# 
public static string[] GetExcelSheetNames( 
   string fileName,
   string password
)

Parameters

fileName
Path and filename of Excel file
password
The password

Example

This example uses the GetExcelSheetNames method.
C#Copy Code
string[] sheetNames = null;
sheetNames = FarPoint.Web.Spread.FpSpread.GetExcelSheetNames("D:\\ALM.xls", "test");
int i;
for (i = 0; i <= sheetNames.Length - 1; i++)
{
    ListBox1.Items.Add(sheetNames[i]);
}
Visual BasicCopy Code
Dim sheetNames As String() = Nothing
sheetNames = FpSpread1.GetExcelSheetNames("D:\ALM.xls", "test")
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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.