ssml:table

Table

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-table.xsd

Type: ssml:CT_Table

Properties: Global, Qualified

Content

Sequence [1..1]
1. ssml:autoFilter [0..1] Table AutoFilter
2. ssml:sortState [0..1] Sort State
3. ssml:tableColumns [1..1] Table Columns
4. ssml:tableStyleInfo [0..1] Table Style
5. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
id	[1..1]	xsd:unsignedInt	Table Id
name	[0..1]	ssml:ST_Xstring	Name
displayName	[1..1]	ssml:ST_Xstring	Table Name
comment	[0..1]	ssml:ST_Xstring	Table Comment
ref	[1..1]	ssml:ST_Ref	Reference
tableType	[0..1]	ssml:ST_TableType	Table Type	Default value is "worksheet".
headerRowCount	[0..1]	xsd:unsignedInt	Header Row Count	Default value is "1".
insertRow	[0..1]	xsd:boolean	Insert Row Showing	Default value is "false".
insertRowShift	[0..1]	xsd:boolean	Insert Row Shift	Default value is "false".
totalsRowCount	[0..1]	xsd:unsignedInt	Totals Row Count	Default value is "0".
totalsRowShown	[0..1]	xsd:boolean	Totals Row Shown	Default value is "true".
published	[0..1]	xsd:boolean	Published	Default value is "false".
headerRowDxfId	[0..1]	ssml:ST_DxfId	Header Row Format Id
dataDxfId	[0..1]	ssml:ST_DxfId	Data Area Format Id
totalsRowDxfId	[0..1]	ssml:ST_DxfId	Totals Row Format Id
headerRowBorderDxfId	[0..1]	ssml:ST_DxfId	Header Row Border Format Id
tableBorderDxfId	[0..1]	ssml:ST_DxfId	Table Border Format Id
totalsRowBorderDxfId	[0..1]	ssml:ST_DxfId	Totals Row Border Format Id
headerRowCellStyle	[0..1]	ssml:ST_Xstring	Header Row Style
dataCellStyle	[0..1]	ssml:ST_Xstring	Data Style Name
totalsRowCellStyle	[0..1]	ssml:ST_Xstring	Totals Row Style
connectionId	[0..1]	xsd:unsignedInt	Connection ID

Sample instance

<ssml:table id="1" name="string" displayName="string" ref="string" connectionId="1">
   <ssml:autoFilter>
      <ssml:filterColumn colId="1">
         <ssml:filters>...
         </ssml:filters>
      </ssml:filterColumn>
      <ssml:sortState ref="string">
         <ssml:sortCondition ref="string" iconSet="3Arrows"/>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:sortState>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:autoFilter>
   <ssml:sortState ref="string">
      <ssml:sortCondition ref="string" iconSet="3Arrows"/>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:sortState>
   <ssml:tableColumns>
      <ssml:tableColumn id="1" uniqueName="string" name="string">
         <ssml:calculatedColumnFormula>string</ssml:calculatedColumnFormula>
         <ssml:totalsRowFormula>string</ssml:totalsRowFormula>
         <ssml:xmlColumnPr mapId="1" xpath="string" xmlDataType="string">...
         </ssml:xmlColumnPr>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:tableColumn>
   </ssml:tableColumns>
   <ssml:tableStyleInfo/>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:table>