Page History

{description}
{excerpt}ExcelWriter creates three style types: [GlobalStyle|GlobalStyle], [NamedStyle|NamedStyle], and [CellStyle|CellStyle]. All three style types derive from the [Style|Style] class, and {{NamedStyle}} derives from {{GlobalStyle}}.{excerpt}
{signature:C#}
 public class GlobalStyle : Style

{signature}{signature:vb.net

}
Public Class GlobalStyle
		Inherits Style

{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 properties 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.

To +set+ a style, use the {{Style}} property. To +apply+ a style, call {{ApplyStyle}}. Both are accessible through the following objects: [Cell|Cell], [Area|Area], [Range|Range], [RowProperties|RowProperties], and [ColumnProperties|ColumnProperties].

{remarks}
{example}{code:csharp|title=C#}

          Style styleMoneyFormat = wb.CreateStyle();
          styleMoneyFormat.NumberFormat = "$#,##0";
          Style styleTitle = wb.CreateStyle();
          styleTitle.Font.Size = 14;
          styleTitle.Font.Color = wb.Palette.GetClosestColor(100, 100, 255);
        

{code}
{code:vbnet|title=vb.net

}

          Dim styleMoneyFormat As Style = wb.CreateStyle()
          styleMoneyFormat.NumberFormat = "$#,##0"
          Dim styleTitle As Style = wb.CreateStyle()
          styleTitle.Font.Size = 14
          styleTitle.Font.Color = wb.Palette.GetClosestColor(100, 100, 255)
        {code}

{example}