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

'宣言
Public Class TableStyleInfo _
    Inherits OpenXmlLeafElement
'使用
Dim instance As TableStyleInfo
public class TableStyleInfo : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 初版]

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. 上記の引用はマイクロソフト (またはその代理) によって英語から日本語に翻訳されたものであり、ISO はこうした翻訳に対する責任を一切負いません。

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