Set style for entire column

Aspose.Cells Product Family
,
1

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

2

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.

3

@jeljeljel,
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.