WorkSheet Style


#1

I need to apply a style to a whole worksheet (font for example). How can I do this ?

I don’t know the row or column number before to do it.
I know it is possible with the interop Excel


#2

You can try:

for(int i = 0; i < 256; i ++)

{

Style style = cells.Columns[(byte)i].Style;

style.Font.Name = "Times New Roman";

cells.Columns[(byte)i].Style = style;

}