2.2.4.24.35 Table

Article
10/13/2020

A range represented in tabular format. This element contains information about the following range:

If the NamedRange attribute on the parent Worksheet element (section 2.2.4.24.16) is false, the range represented is the range in the VisibleSheetRangeRequest parameter (section 2.2.4.25) sent by the protocol client.

If the NamedRange attribute on the parent Worksheet element is true, the range represented is the intersection of the range in the VisibleSheetRangeRequest parameter and the range defined on the named object.

 <s:complexType name="Table">
   <s:sequence>
     <s:element name="Column" type="ColumnAxisItem" minOccurs="0" maxOccurs="16384"  />
     <s:element name="Row" type="RowAxisItem" minOccurs="0" maxOccurs="1048576" />
   </s:sequence>
   <s:attribute name="LastNonEmptyRow" type="excelRowNumber1Based" use="required" />
   <s:attribute name="LastNonEmptyColumn" type="excelColNumber1Based" use="required" />
   <s:attribute name="CurrentFirstRow" type="excelRowNumber1Based" use="optional" />
   <s:attribute name="FirstVisibleRow" use="required">
     <s:simpleType>
       <s:union memberTypes="excelRowNumber1Based">
         <s:simpleType>
           <s:restriction base="s:int">
             <s:enumeration value="-1" />
             <s:enumeration value="0" />
           </s:restriction>
         </s:simpleType>
       </s:union>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="LastVisibleRow" use="optional">
     <s:simpleType>
       <s:union memberTypes="excelRowNumber1Based">
         <s:simpleType>
           <s:restriction base="s:int">
             <s:enumeration value="0" />
           </s:restriction>
         </s:simpleType>
       </s:union>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="CurrentFirstColumn" type="excelColNumber1Based" use="optional" />
   <s:attribute name="FirstVisibleColumn" use="required">
     <s:simpleType>
       <s:union memberTypes="excelColNumber1Based">
         <s:simpleType>
           <s:restriction base="s:int">
             <s:enumeration value="-1" />
             <s:enumeration value="0" />
           </s:restriction>
         </s:simpleType>
       </s:union>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="LastVisibleColumn" use="optional">
     <s:simpleType>
       <s:union memberTypes="excelColNumber1Based">
         <s:simpleType>
           <s:restriction base="s:int">
             <s:enumeration value="0" />
           </s:restriction>
         </s:simpleType>
       </s:union>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="DefaultRowHeight" default="12.75" use="optional">
     <s:simpleType>
       <s:union>
         <s:simpleType>
           <s:restriction base="rowHeight"/>
         </s:simpleType>
         <s:simpleType>
           <s:restriction base="s:double">
             <s:enumeration value="0" />
           </s:restriction>
         </s:simpleType>
       </s:union>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="DefaultColumnWidth" default="48" use="optional">
     <s:simpleType>
       <s:union>
         <s:simpleType>
           <s:restriction base="columnWidth"/>
         </s:simpleType>
         <s:simpleType>
           <s:restriction base="s:double">
             <s:enumeration value="0" />
           </s:restriction>
         </s:simpleType>
       </s:union>
     </s:simpleType>
   </s:attribute> 
   <s:attribute name="DefaultIndentWidth" type="columnWidth" default="9" use="optional" />
   <s:attribute name="SelectionTop" default="0" use="optional" >
     <s:simpleType>
       <s:restriction base="s:int">
         <s:minInclusive value="0" />
         <s:maxInclusive value="1048576" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="SelectionLeft" default="0" use="optional" >
     <s:simpleType>
       <s:restriction base="s:int">
         <s:minInclusive value="0" />
         <s:maxInclusive value="16384" />
       </s:restriction>
     </s:simpleType>
   </s:attribute>
   <s:attribute name="summaryRight" type="s:boolean" default="true" />
   <s:attribute name="summaryBelow" type="s:boolean" default="true" />
   <s:attribute name="outlineLevelCol" type="excelOutlineLevels" use="optional" />
   <s:attribute name="outlineLevelRow" type="excelOutlineLevels" use="optional" />
 </s:complexType>

Column: This element represents one or more columns in the range represented by the Table element. There MUST be one element for every column (2) or collection of contiguous columns that have identical hidden status, outline level and width. The entries for this element MUST be ordered according to the column (2) indices.

Row: This element represents one or more rows in the range represented by the Table element. There MUST be one element for every row (2) or collection of contiguous hidden rows. The entries for this element MUST be ordered according to the row (2) indices.

LastNonEmptyRow: The value of this attribute is the minimum of the following values:

The last visible row (2) in the worksheet or the named object, or 1 if there are no visible rows in the worksheet or the named object.
The greater of the following two values:
- The last row in the worksheet or the named object containing a worksheet cell that has data or formatting.
- The last row (2) in the range in the VisibleSheetRangeRequest parameter sent by the protocol client.

LastNonEmptyColumn: The value of this attribute is the minimum of the following values:

The last visible column (2) in the worksheet or the named object, or 1 if there are no visible columns in the worksheet or the named object.
The greater of the following two values:
- The last column (2) in the worksheet or the named object containing a worksheet cell that has data or formatting.
- The last column (2) in the range in the VisibleSheetRangeRequest parameter sent by the protocol client.

CurrentFirstRow: If all the rows in the worksheet are hidden, this attribute MUST be omitted. If the NamedRange attribute in the parent Worksheet element is false, this attribute represents the index of the first row (2) in the range in the VisibleSheetRangeRequest parameter sent by the protocol client. If the NamedRange attribute in the parent Worksheet element is true, this attribute represents the index of the first row (2) in the intersection of the range in the VisibleSheetRangeRequest parameter sent by the protocol client and the range defined on the named object. If the aforementioned ranges are disjoint, the value of this attribute MUST be 1.

FirstVisibleRow: If all the rows in the worksheet are hidden, this attribute MUST be -1. If the NamedRange attribute in the parent Worksheet element is false, this attribute represents the index of the first visible row (2) in the worksheet. If the NamedRange attribute in the parent Worksheet element is true this attribute is the index of the first visible row (2) in the range defined on the named object. If the range in the VisibleSheetRangeRequest parameter sent by the protocol client and the range defined on the named object are disjoint, the value of this attribute MUST be 0.

LastVisibleRow: If all the rows in the worksheet are hidden, this attribute MUST be omitted. If the NamedRange attribute in the parent Worksheet element is false, this attribute represents the index of the last visible row (2) in the worksheet. If the NamedRange attribute in the parent Worksheet element is true, this attribute represents the index of the last visible row (2) in the range defined on the named object. If the range in the VisibleSheetRangeRequest parameter sent by the protocol client and the range defined on the named object are disjoint, the value of this attribute MUST be 0.

CurrentFirstColumn: If all the columns in the worksheet are hidden, this attribute MUST be omitted. If the NamedRange attribute in the parent Worksheet element is false, this attribute represents the index of the first column (2) in the range in the VisibleSheetRangeRequest parameter sent by the protocol client. If the NamedRange attribute in the parent Worksheet element is true, this attribute represents the index of the first column (2) in the intersection of the range in the VisibleSheetRangeRequest parameter sent by the protocol client and the range defined on the named object. If the aforementioned ranges are disjoint, the value of this attribute MUST be 1.

FirstVisibleColumn: If all the columns in the worksheet are hidden, this attribute MUST be -1. If the NamedRange attribute in the parent Worksheet element is false, this attribute represents the index of the first visible column (2) in the worksheet. If the NamedRange attribute in the parent Worksheet element is true, this attribute represents the index of the first visible column (2) in the range defined on the named object. If the range in the VisibleSheetRangeRequest parameter sent by the protocol client and the range defined on the named object are disjoint, the value of this attribute MUST be 0.

LastVisibleColumn: If all the columns in the worksheet are hidden, this attribute MUST be omitted. If the NamedRange attribute in the parent Worksheet element is false, this attribute represents the index of the last visible column (2) in the worksheet. If the NamedRange attribute in the parent Worksheet element is true, this attribute represents the index of the last visible column (2) in the range defined on the named object. If the range in the VisibleSheetRangeRequest parameter sent by the protocol client and the range defined on the named object are disjoint, the value of this attribute MUST be 0.

DefaultRowHeight: The default height of a row (2) in points.

DefaultColumnWidth: The default width of a column (2) in points.

DefaultIndentWidth: The default vertical indent or horizontal indent used for rendering cell contents for worksheet cells with vertical text or horizontal text respectively, in points.

SelectionTop: The index of the row (2) which has the active cell. This attribute MUST have a value other than 0 if all the following conditions are true:

The NamedRange attribute in Worksheet is false.
The worksheet has an active cell.
There are one or more visible rows in the worksheet.
There are one or more visible columns in the worksheet.
The row (2) index of the active cell is greater than or equal to the value of the FirstVisibleRow attribute.
The row (2) index of the active cell is less than or equal to the value of the LastVisibleRow attribute.
The column (2) index of the active cell is greater than or equal to the value of the FirstVisibleColumn attribute.
The column (2) index of the active cell is less than or equal to the value of the LastVisibleColumn attribute.

It MUST be omitted or have a value of 0 otherwise.

SelectionLeft: The index of the column (2) which has the active cell. This attribute MUST have a value other than 0 if all the following conditions are true:

The NamedRange attribute in Worksheet is false.
The worksheet has an active cell.
There are one or more visible rows in the worksheet.
There are one or more visible columns in the worksheet.
The row (2) index of the active cell is greater than or equal to the value of the FirstVisibleRow attribute.
The row (2) index of the active cell is less than or equal to the value of the LastVisibleRow attribute.
The column (2) index of the active cell is greater than or equal to the value of the FirstVisibleColumn attribute.
The column (2) index of the active cell is less than or equal to the value of the LastVisibleColumn attribute.

It MUST be omitted or have a value of 0 otherwise.

SummaryRight: Specifies whether the summary of a set of grouped columns is displayed to the right of the grouped data. When this attribute is set to true, it denotes that the summary of a set of grouped columns is displayed to the right of grouped data. This attribute MUST be present and set to false if outlines are visible on the worksheet and the summary of grouped columns in the worksheet is displayed to the left of the grouped columns.

SummaryBelow: Specifies whether the summary of a set of grouped rows is displayed below the grouped data. When this attribute is set to true, it denotes that the summary of a set of grouped rows is displayed below the grouped data. This attribute MUST be present and set to false if outlines are visible on the worksheet and the summary of grouped rows in the worksheet is displayed above the grouped rows.

outlineLevelCol: The maximum number of outline levels of outlining in a set of grouped columns within the range represented by the Table element. This attribute MUST be present if outlines are visible on the worksheet and there are one or more grouped columns in the range represented by the Table element (section 2.2.4.24.35).

outlineLevelRow: The maximum number of outline levels of outlining in a set of grouped rows within the range represented by the Table element. This attribute MUST be present if outlines are visible on the worksheet and there are one or more grouped rows in the range represented by the Table element.

2.2.4.24.35 Table

Additional resources