Description |
---|
Excerpt |
---|
ExcelWriter has three style types: CellStyle, GlobalStyle, and NamedStyle. |
Signature | C# | C# | |
---|---|---|---|
Wiki Markup | |||
{description}
{excerpt}ExcelWriter has three style types: [CellStyle|CellStyle], [GlobalStyle|GlobalStyle], and [NamedStyle|NamedStyle].{excerpt}
{signature:C#}
public class Style
| |||
Signature | |||
{signature}{signature:vb.net | vb.net | }
Public Class Style
| |
Remarks | |||
All three types derive from the Style class, and GlobalStyle , use {signature} {remarks} All three types derive from the [Style|Style] class, and {{NamedStyle}} derives from {{GlobalStyle}}. You cannot create a CellStyle, only manipulate existing ones as part of the objects they apply to. To create a {{GlobalStyle}}, use [Workbook.CreateStyle()|Workbook.CreateStyle()]. To create a {{NamedStyle}}, use [Workbook.CreateNamedStyle()|Workbook.CreateNamedStyle(String)]. To get a {{NamedStyle}} from an existing document, use [Workbook.GetNamedStyle(). | |||
Example | |||
Code Block | | csharp | csharp |
title | C# | ||
Code Block | vbnet | vbnet | title |
Properties |
---|
...
Name
...
Description
...
...
{code} {example} {properties} ||Name||Description|| |[BackgroundColor|Style.BackgroundColor]|{excerpt-include:Style.BackgroundColor |
...
|nopanel=true}| |[Border|Style.Border]|{excerpt-include |
...
:Style.Border |
...
|nopanel=true}| |[CellLocked|Style.CellLocked]|{excerpt-include |
...
:Style.CellLocked |
...
|nopanel=true}| |[Font|Style.Font]|{excerpt-include |
...
:Style.Font |
...
|nopanel=true}| |[ForegroundColor|Style.ForegroundColor]|{excerpt-include |
...
:Style.ForegroundColor |
...
|nopanel=true}| |[HideFormulas|Style.HideFormulas]|{excerpt-include |
...
:Style.HideFormulas |
...
|nopanel=true}| |[HorizontalAlignment|Style.HorizontalAlignment]|{excerpt-include |
...
:Style.HorizontalAlignment |
...
|nopanel=true}| |[IndentLevel|Style.IndentLevel]|{excerpt-include |
...
:Style.IndentLevel |
...
|nopanel=true}| |[JustifyDistributed|Style.JustifyDistributed]|{excerpt-include |
...
:Style.JustifyDistributed |
...
|nopanel=true}| |[NumberFormat|Style.NumberFormat]|{excerpt-include |
...
:Style.NumberFormat |
...
|nopanel=true}| |[Orientation|Style.Orientation]|{excerpt-include |
...
:Style.Orientation |
...
|nopanel=true}| |[Pattern|Style.Pattern]|{excerpt-include |
...
:Style.Pattern |
...
|nopanel=true}| |[ShrinkToFit|Style.ShrinkToFit]|{excerpt-include |
...
:Style.ShrinkToFit |
...
|nopanel=true}| |[TextDirection|Style.TextDirection]|{excerpt-include |
...
:Style.TextDirection |
...
|nopanel=true}| |[VerticalAlignment|Style.VerticalAlignment]|{excerpt-include |
...
:Style.VerticalAlignment |
...
|nopanel=true}| |[WrapText|Style.WrapText]|{excerpt-include |
...
:Style.WrapText |
...
Classes |
---|
...
Name
...
Description
...
...
...
...
...
...
|nopanel=true}|
{classes}
||Name||Description||
|[ColumnInsertBehavior|Style.ColumnInsertBehavior]|{excerpt-include:Style.ColumnInsertBehavior|nopanel=true}|
|[HAlign|Style.HAlign]|{excerpt-include:Style.HAlign|nopanel=true}|
|[RowInsertBehavior|Style.RowInsertBehavior]|{excerpt-include:Style.RowInsertBehavior|nopanel=true}|
|[TextDir|Style.TextDir]|{excerpt-include:Style.TextDir|nopanel=true}|
|[VAlign|Style.VAlign]|{excerpt-include:Style.VAlign|nopanel=true}| |