Share via


TableStyleInfo Class

Table Style.When the object is serialized out as xml, its qualified name is x:tableStyleInfo.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Spreadsheet.TableStyleInfo

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
Public Class TableStyleInfo _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As TableStyleInfo
public class TableStyleInfo : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 1st Edition]

18.5.1.5 tableStyleInfo (Table Style)

This element describes which style is used to display this table, and specifies which portions of the table have the style applied.

Styles define a set of formatting properties that can be easily referenced by cells or other objects in the spreadsheet application. A style can be applied to a table, but tables can define specific parts of the table that should not have the style applied independently of other table parts. For instance a table can not apply the row striping of the style, and can not show the style's formatting of the last column, but will apply the column striping and the formatting to the first column.

Parent Elements

table (§18.5.1.2)

Attributes

Description

name (Style Name)

A string representing the name of the table style to use with this table.

If the style name does not correspond to the name of a table style then the spreadsheet application should use default style.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

showColumnStripes (Show Column Stripes)

A Boolean indicating whether column stripe formatting is applied. True when style column stripe formatting is applied, false otherwise.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

showFirstColumn (Show First Column)

A Boolean indicating whether the first column in the table should have the style applied. True if the first column has the style applied, false otherwise.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

showLastColumn (Show Last Column)

A Boolean indicating whether the last column in the table should have the style applied. True if the last column has the style applied, false otherwise.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

showRowStripes (Show Row Stripes)

A Boolean indicating whether row stripe formatting is applied. True when style row stripe formatting is applied, false otherwise.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_TableStyleInfo) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

TableStyleInfo Members

DocumentFormat.OpenXml.Spreadsheet Namespace