2.2.5.4 SheetName

  • Article

Namespace: http://schemas.microsoft.com/office/excel/server/webservices

A string that is used by the protocol server to find a sheet (1) in a workbook in some of the operations specified in this protocol.

It has the following specification:

  • MUST NOT be longer than 31 characters.

  • If empty, the protocol server MUST use the first sheet (1) in the workbook unless specified otherwise in the operation.

  • If no sheet (1) in the workbook matches the requested SheetName simple type, the protocol server MUST return a SOAP fault response, which SHOULD contain the InvalidSheetName subcode but MAY contain any other subcode.

If the user does not have the Open Item permission for the workbook used by the session (2) , when SheetName is used by the GetCell, GetCellA1, GetRange, or GetRangeA1 operations, the server MUST return a SOAP fault response, which MUST contain the SpecifiedItemNotFound subcode, if the matching sheet (1) is not a visible sheet (1).

This simple type is defined as follows.

 <xs:simpleType name="SheetName" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:restriction base="xs:string"/>
 </xs:simpleType>