ssml:queryTable

Query Table

Element information

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

Schema document: sml-queryTable.xsd

Type: ssml:CT_QueryTable

Properties: Global, Qualified

Content

Sequence [1..1]
1. ssml:queryTableRefresh [0..1] QueryTable Refresh Information
2. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
name	[1..1]	ssml:ST_Xstring	QueryTable Name
headers	[0..1]	xsd:boolean	First Row Column Titles	Default value is "true".
rowNumbers	[0..1]	xsd:boolean	Row Numbers	Default value is "false".
disableRefresh	[0..1]	xsd:boolean	Disable Refresh	Default value is "false".
backgroundRefresh	[0..1]	xsd:boolean	Background Refresh	Default value is "true".
firstBackgroundRefresh	[0..1]	xsd:boolean	First Background Refresh	Default value is "false".
refreshOnLoad	[0..1]	xsd:boolean	Refresh On Load	Default value is "false".
growShrinkType	[0..1]	ssml:ST_GrowShrinkType	Grow Shrink Type	Default value is "insertDelete".
fillFormulas	[0..1]	xsd:boolean	Fill Adjacent Formulas	Default value is "false".
removeDataOnSave	[0..1]	xsd:boolean	Remove Data On Save	Default value is "false".
disableEdit	[0..1]	xsd:boolean	Disable Edit	Default value is "false".
preserveFormatting	[0..1]	xsd:boolean	Preserve Formatting On Refresh	Default value is "true".
adjustColumnWidth	[0..1]	xsd:boolean	Adjust Column Width On Refresh	Default value is "true".
intermediate	[0..1]	xsd:boolean	Intermediate	Default value is "false".
connectionId	[1..1]	xsd:unsignedInt	Connection ID
autoFormatId	[0..1]	xsd:unsignedInt	Auto Format Id	from group ssml:AG_AutoFormat
applyNumberFormats	[0..1]	xsd:boolean	Apply Number Formats	from group ssml:AG_AutoFormat
applyBorderFormats	[0..1]	xsd:boolean	Apply Border Formats	from group ssml:AG_AutoFormat
applyFontFormats	[0..1]	xsd:boolean	Apply Font Formats	from group ssml:AG_AutoFormat
applyPatternFormats	[0..1]	xsd:boolean	Apply Pattern Formats	from group ssml:AG_AutoFormat
applyAlignmentFormats	[0..1]	xsd:boolean	Apply Alignment Formats	from group ssml:AG_AutoFormat
applyWidthHeightFormats	[0..1]	xsd:boolean	Apply Width / Height Formats	from group ssml:AG_AutoFormat

Sample instance

<ssml:queryTable name="string" connectionId="1">
   <ssml:queryTableRefresh>
      <ssml:queryTableFields>
         <ssml:queryTableField id="1" name="string">...
         </ssml:queryTableField>
      </ssml:queryTableFields>
      <ssml:queryTableDeletedFields>
         <ssml:deletedField name="string"/>
      </ssml:queryTableDeletedFields>
      <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:queryTableRefresh>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:queryTable>