Share via

2.2.4.31 RangeValuesA1

  • Article

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

The RangeValuesA1 type is used to transfer the values of the cells specified by RangeName. 

 <xs:complexType name="RangeValuesA1">
   <xs:sequence>
     <xs:element minOccurs="0" maxOccurs="1" name="RangeName" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="SheetName" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="Values" type="tns:ArrayOfAnyType"/>
   </xs:sequence>
 </xs:complexType>

RangeName: The name of the range, as specified in section 2.2.5.18. MUST be present.

SheetName: The name of the sheet (2) where the cells are located. MUST be present. The length of the element MUST NOT be more than 31 characters.

Values: The values of the sheet (2) cells. MUST be present. Each element inside the Values element MUST be of type ArrayOfAnyType and is a row of sheet (2) cells on the protocol server. The number of rows returned MUST be equal to the number of rows requested in the rangeName element. Each element inside each of the ArrayOfAnyType type nested inside Values MUST be a single workbook sheet (2) cell. The number of elements inside each such nested ArrayOfAnyType MUST be equal to the number of columns (2) requested in the rangeName element.