borders (Borders)

This element contains borders formatting information, specifying all border definitions for all cells in the workbook.

[Example: In this example the first border definition specifies that there are no borders, the second definition specifies that a there is a thin bottom border and medium right border, and the third definition specifies that there is a double top border.

<borders count="3">
<border>
<left/>
<right/>
<top/>
<bottom/>
<diagonal/>
</border>

<border>
<left/>
<right style="medium">
<color indexed="64"/>
</right>

<top/>

<bottom style="thin">
<color indexed="64"/>
</bottom>
<diagonal/>
</border>

<border>
<left/>
<right/>
<top style="double">
<color auto="1"/>
</top>

<bottom/>
<diagonal/>
</border>
</borders>

end example]

Parent Elements

styleSheet (§3.8.39)

 

Child Elements	Subclause
border (Border)	§3.8.4

 

Attributes	Description
count (Border Count)	Count of border elements.   The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Borders">

   <sequence>

   <element name="border" type="CT_Border" minOccurs="0" maxOccurs="unbounded"/>

   </sequence>

   <attribute name="count" type="xsd:unsignedInt" use="optional"/>

</complexType>