ExcelService.GetSheetNames Method

SharePoint 2010

Gets a list of all of the sheet names present in a workbook.

Namespace:  Microsoft.Office.Excel.Server.WebServices
Assembly:  Microsoft.Office.Excel.Server.WebServices (in Microsoft.Office.Excel.Server.WebServices.dll)

public SheetInfo[] GetSheetNames(
	string sessionId,
	out Status[] status


Type: System.String

The Excel Web Services session ID.

Type: []

Alert information.

Return Value

Type: []
The SheetInfo information about a sheet in a workbook..

The method also returns the type of sheet (worksheets and chartsheets) and the visibility of the sheet (visible, hidden, and very hidden). For more information, see SheetType and SheetVisibility.

This method works with view only, read and edit permissions. If the user has view only permissions, only visible and published sheets are returned.