3.1.4.24.4.1 CellDataFormat

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

Specifies a list of enumeration values where the retrieved cell values need to be number formatted. If the value Compound is used, the formatted element MUST also use both the values Formatted and Unformatted. If the value Compound is not used, the formatted element MUST use either the value Formatted or Unformatted.

 <xs:simpleType name="CellDataFormat">
   <xs:list>
     <xs:simpleType>
       <xs:restriction base="xs:string">
         <xs:enumeration value="Formatted"/>
         <xs:enumeration value="Unformatted"/>
         <xs:enumeration value="Compound"/>
       </xs:restriction>
     </xs:simpleType>
   </xs:list>
 </xs:simpleType>

The following table specifies the allowable values for CellDataFormat:

Value

Meaning

Formatted

Specifies that the retrieved cell values MUST be number formatted.

Unformatted

Specifies that the retrieved cell values MUST NOT be number formatted.

Compound

Specifies that the retrieved cell values MUST be of type CellCompoundValue as specified in section 2.2.4.16.