Share via

2.2.4.62 RestRangeValuesRequest

  • Article

Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/

When passed as the request parameter of the ProcessRestRequest input (section 3.1.4.56.2.1), indicates retrieving the sheet (2) cell values of a range.

 <xs:complexType name="RestRangeValuesRequest" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:complexContent mixed="false">
     <xs:extension base="tns:RestRequest">
       <xs:sequence>
         <xs:element minOccurs="0" maxOccurs="1" name="Name" type="xs:string"/>
         <xs:element minOccurs="1" maxOccurs="1" name="NamedObjectType" nillable="true" type="tns:NamedObjectType"/>
       </xs:sequence>
     </xs:extension>
   </xs:complexContent>
 </xs:complexType>

Name: MUST be specified. If NamedObjectType is specified, then this field is interpreted as the name of a published item.  Otherwise, this field MUST follow the RangeReference (section 2.2.5.25) specification, with the following exceptions:

  • The protocol server MUST support the R1C1 notation.

  • If the value is longer than 287 characters, then the protocol server MUST return an ExcelServerMessage as specified in section 2.2.4.24, with the value of the Id element of the ExcelServerMessage set to EcsInvalidNamedObject.

NamedObjectType: If specified, this field indicates the type of named object represented by Name.