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 FormattingRange = mySheet.get_Range("A1", "A10");

 FormattingRange.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 column from the Columns collection
 Column column = mySheet.Cells.Columns[0];

 // Assigning the Style object to the Style property of the column
 column.ApplyStyle(style, styleFlag);

 myWorkbook.Save(fileName);

Download

• GitHub