OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 6

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version 7

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Csharp
1
1
//Create a global style
GlobalStyle style = wb.CreateStyle();

//Set a cell's style to the new global style
ws.Cells[0,0].Style = style;

//Set an area's style to the new global style
ws.CreateArea(1,1,5,5).SetStyle(style);

//Set a range's style to the new global style
ws.CreateRange("D5:E6").SetStyle(style);
Vbnet
1
1
11

'Create

a

global

style


Dim

style

As

GlobalStyle

=

wb.CreateStyle()

Vbnet

'Set a cell's style to the new global style
ws.Cells(0, 0).Style = style

'Set an area's style to the new global style
ws.CreateArea(1, 1, 5, 5).SetStyle(style)

'Set a range's style to the new global style
ws.CreateRange("D5:E6").SetStyle(style)

Alternatively, if you want to apply a single style to all the cells in a column, you can get the ColumnProperties object for that column and call its SetStyle method:

Csharp
2
2

//Get the properties for the column you want to alter

...


ColumnProperties properties = ws.GetColumnProperties(0);

...



//Apply a style to that column

...


properties.ApplyStyle(style);
Vbnet
2
2

'Get the properties for the column you want to alter
Dim properties As ColumnProperties = ws.GetColumnProperties(0)

'Apply a style to that column
properties.ApplyStyle(style)

Using one of these two techniques to apply styles will use less memory than creating a new style for each cell or modifying the Cell.Style property directly.