[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

FarPoint.Win.Spread.FpSpread.GetExcelSheetNames

GetExcelSheetNames Method

GetExcelSheetNames(Stream)

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

Declaration
public static string[] GetExcelSheetNames(Stream stream)
Public Shared Function GetExcelSheetNames(stream As Stream) As String()
Parameters
Type Name Description
Stream stream

Stream that contains an Excel Compound Document File
Returns
Type Description
string[]

An array of sheet names.
Exceptions
Type Condition
ArgumentNullException

No stream specified or specified stream is null
ArgumentException

No stream specified or specified stream is empty

GetExcelSheetNames(Stream, string)

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

Declaration
public static string[] GetExcelSheetNames(Stream stream, string password)
Public Shared Function GetExcelSheetNames(stream As Stream, password As String) As String()
Parameters
Type Name Description
Stream stream

Stream that contains an Excel Compound Document File
string password

File password
Returns
Type Description
string[]

An array of sheet names.
Exceptions
Type Condition
ArgumentNullException

No stream specified or specified stream is null
ArgumentException

No stream specified or specified stream is empty

GetExcelSheetNames(string)

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

Declaration
public static string[] GetExcelSheetNames(string fileName)
Public Shared Function GetExcelSheetNames(fileName As String) As String()
Parameters
Type Name Description
string fileName

Path and name of file
Returns
Type Description
string[]

n array of sheet names.
Exceptions
Type Condition
FileNotFoundException

Specified file is not found
ArgumentNullException

No file name is specified (or specified file name is null)
ArgumentException

No file name is specified (or specified file name is empty)

GetExcelSheetNames(string, string)

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

Declaration
public static string[] GetExcelSheetNames(string fileName, string password)
Public Shared Function GetExcelSheetNames(fileName As String, password As String) As String()
Parameters
Type Name Description
string fileName

Path and name of file
string password

Password of file
Returns
Type Description
string[]

An array of sheet names.
Exceptions
Type Condition
FileNotFoundException

Specified file is not found
ArgumentNullException

No file name is specified (or specified file name is null)
ArgumentException

No file name is specified (or specified file name is empty)