Spread ASP.NET 6.0 Product Documentation
GetExcelSheetNames(String,String) Method
See Also  Example Send Feedback
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.