Share via

2.3.49 CT_WebExtensionBinding

  • Article

Referenced by: CT_WebExtensionBindings

An Office Web Extension binding that is a range in a worksheet associated with the Office Web Extension.

Attributes:

BindingName: Specifies the Office Web Extension defined name for the binding.

BindingVersion: Specifies the version of the binding.

BindingType: Specifies the type of binding.

IsValidRef: Specifies whether the binding refers to a valid range. If this is false, then the SheetName, FirstColumn, FirstRow, LastColumn, and LastRow fields MUST NOT be used.

SheetName: Specifies the name of the sheet that contains the binding.

FirstColumn: Specifies the first column (1) of the binding.

FirstRow: Specifies the first row of the binding.

LastColumn: Specifies the last column (1) of the binding.

LastRow: Specifies last row of the binding.

HasHeaders: Specifies whether the binding has a header row. MUST be true if it does and false otherwise.

HasTotals:  Specifies whether the binding has a totals row. MUST be true if it does and false otherwise.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

 <xs:complexType name="CT_WebExtensionBinding">
   <xs:attribute name="BindingName" type="ST_nonEmptyString" use="required"/>
   <xs:attribute name="BindingVersion" type="ST_nonNegativeInteger" use="required"/>
   <xs:attribute name="BindingType" type="ST_osfBindingType" use="required"/>
   <xs:attribute name="IsValidRef" type="xs:boolean" use="required"/>
   <xs:attribute name="SheetName" type="ST_SheetName" use="optional"/>
   <xs:attribute name="FirstColumn" type="ST_excelColNumber" use="optional"/>
   <xs:attribute name="FirstRow" type="ST_excelRowNumber" use="optional"/>
   <xs:attribute name="LastColumn" type="ST_excelColNumber" use="optional"/>
   <xs:attribute name="LastRow" type="ST_excelRowNumber" use="optional"/>
   <xs:attribute name="HasHeaders" type="xs:boolean" use="required"/>
   <xs:attribute name="HasTotals" type="xs:boolean" use="required"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).