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; // 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; // 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:
Trial version can be downloaded here:
Aspose.Cells for .NET (Latest Version)
A sample runnable solution is available here having hundreds of examples.