QueryTable XML

<queryTable xmlns="…" name="www.msn" preserveFormatting="0"
  connectionId="1"
  autoFormatId="16" applyNumberFormats="0" applyBorderFormats="0" 
  applyFontFormats="1" applyPatternFormats="1" applyAlignmentFormats="0" 
  applyWidthHeightFormats="0"/>

In the context of <queryTable>:

• @name is the name of the QueryTable.

• @preserveFormatting indicates whether to retain user-applied formatting after refresh or re-apply source data formatting.

• @connectionId is the workbook connection's @id.

• @autoFormatId identifies (by implied index) the auto-format applied to the QueryTable.

All remaining attributes beginning with @apply… indicate whether to apply this particular aspect of the auto-format definition.