<borders> (Borders)

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

example:
<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>

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>