We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Set style for entire column

What would the code be to set an entire column’s background color to yellow?

Now this feature is not available yet. We will add it in the future release. You can set the entire column background color at you designer file.

This feature is available now using the latest version of Aspose.Cells which has replaced Aspose.Excel. You can apply style on a row or column as depicted in the following sample code:

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Obtaining the reference of the first (default) worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];           

// Adding a new Style to the styles
Style style = workbook.CreateStyle();

// Setting the vertical alignment of the text in the "A1" cell
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;

// Setting the bottom border type of the cell to medium
style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Medium;

// 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 = worksheet.Cells.Columns[0];

// Applying the style to the column
column.ApplyStyle(style, styleFlag);

// Saving the Excel file
workbook.Save(dataDir + "book1.out.xls"); 

Here is a link to detailed document section about this feature:
Formatting Column

Trial version can be downloaded here:
Aspose.Cells for .NET (Latest Version)

A sample runnable solution is available here having hundreds of examples.