...
Description |
---|
Excerpt |
---|
ExcelWriter creates three style types: GlobalStyle, NamedStyle, and CellStyle. All three style types derive from the Style class, and |
Signature | ||||
---|---|---|---|---|
| ||||
public sealed class NamedStyle : GlobalStyle
{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public NotInheritable Class NamedStyle
Inherits GlobalStyle
{signature}
{remarks}A style can be +set+ or +applied+ to cells, rows, columns, ranges, and areas. When a style is +set+ , it is cloned and the object to which the style is assigned acquires all of that style's properties, including font proprties and number formatting. When a style is +applied+ , only the differences between the new style and existing style properties \(assigned through the ExcelWriter API or in Microsoft Excel\) will take effect. For example, if the cell has a background color and the new style applied does not contain a background color, the cell's color will not be affected. However, if the new style includes a background color, it will replace the existing background color of the cell.
The [ExcelApplication|ExcelApplication] object contains a collection of {{NamedStyle}} s, which \- unlike {{GlobalStyle}} s are accessible after the workbook is saved. This allows you to dynamically create a template, save it to disk, re\-open it to populate it with data, and then apply your newly\-created style. This collection of {{NamedStyle}} s includes Excel's built\-in styles \(such as the NORMAL style\) and any user\-defined styles in a workbook opened with the ExcelApplication object.
To create a {{NamedStyle}}, call [Workbook.CreateNamedStyle|Workbook.CreateNamedStyle(String)].
To return a {{NamedStyle}}, call [Workbook.GetNamedStyle|Workbook.GetNamedStyle(String)].
{remarks}
{example}{code:csharp|title=C#} |
Remarks |
---|
A style can be set or applied to cells, rows, columns, ranges, and areas. When a style is set , it is cloned and the object to which the style is assigned acquires all of that style's properties, including font proprties and number formatting. When a style is applied , only the differences between the new style and existing style properties (assigned through the ExcelWriter API or in Microsoft Excel) will take effect. For example, if the cell has a background color and the new style applied does not contain a background color, the cell's color will not be affected. However, if the new style includes a background color, it will replace the existing background color of the cell. The ExcelApplication object contains a collection of To create a To return a |
Example | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Properties |
---|
Name | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
|