Apply Styles to Ranges in Workbooks

Below is the code comparison of applying style to rows and columns of workbooks:

VSTO

  Excel.Workbook myWorkbook = this.Application.Workbooks.Open(fileName);

 Excel.Worksheet mySheet = myWorkbook.ActiveSheet;

 Excel.Style style = this.Application.ActiveWorkbook.Styles.Add("NewStyle");

 style.Font.Name = "Verdana";

 style.Font.Size = 12;

 style.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);

 style.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Gray);

 style.Interior.Pattern = Excel.XlPattern.xlPatternSolid;

 Excel.Range FormatingRange = mySheet.get_Range("A1", "A10");

 FormatingRange.Style = "NewStyle";

Aspose.Cells

  Workbook myWorkbook = new Workbook(fileName);

 Worksheet mySheet = myWorkbook.Worksheets[myWorkbook.Worksheets.ActiveSheetIndex];

 Style style = myWorkbook.CreateStyle();

 style.VerticalAlignment = TextAlignmentType.Center;

 //Setting the horizontal alignment of the text in the "A1" cell

 style.HorizontalAlignment = TextAlignmentType.Center;

 //Setting the font color of the text in the "A1" cell

 style.Font.Color = Color.Green;

 //Shrinking the text to fit in the cell

 style.ShrinkToFit = true;

 //Setting the bottom border color of the cell to red

 style.Borders[BorderType.BottomBorder].Color = Color.Red;

 //Creating StyleFlag

 StyleFlag styleFlag = new StyleFlag();

 styleFlag.HorizontalAlignment = true;

 styleFlag.VerticalAlignment = true;

 styleFlag.ShrinkToFit = true;

 styleFlag.Borders = true;

 styleFlag.FontColor = true;

 //Accessing a row from the Rows collection

 Column column = mySheet.Cells.Columns[0];

 //Assigning the Style object to the Style property of the row

 column.ApplyStyle(style, styleFlag);

 myWorkbook.Save(fileName);

Download

• GitHub