How to change cell color with NPOI

How to change cell color with NPOI

You can change the cell color in an Excel file using NPOI by setting the CellStyle property of the cell and then setting its FillForegroundColor property to the desired color index.

Here's an example:

using NPOI.HSSF.Util; using NPOI.SS.UserModel; public void SetCellColor(ISheet sheet, int rowIndex, int columnIndex, short colorIndex) { var row = sheet.GetRow(rowIndex); var cell = row.GetCell(columnIndex); var cellStyle = sheet.Workbook.CreateCellStyle(); cellStyle.FillForegroundColor = colorIndex; cellStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = cellStyle; }

In this example, we're defining a method called SetCellColor that takes an ISheet object representing the worksheet, the row index, the column index, and the color index. We're getting the row and cell objects using the GetRow and GetCell methods of the ISheet object, respectively.

We're then creating a new CellStyle object using the CreateCellStyle method of the Workbook property of the ISheet object. We're setting its FillForegroundColor property to the specified color index and its FillPattern property to FillPattern.SolidForeground to indicate that we want a solid fill pattern.

Finally, we're setting the CellStyle property of the cell object to the new CellStyle object we created, which will change the cell color in the Excel file.

Note that the colorIndex parameter should be a short value representing the index of the color in the Excel palette. You can use the HSSFColor class provided by NPOI to get predefined color indexes, or you can define your own custom colors using the HSSFColor class.

Examples

  1. "NPOI change cell background color"

    • Code:
      var cellStyle = workbook.CreateCellStyle(); cellStyle.FillForegroundColor = HSSFColor.Yellow.Index; cellStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = cellStyle;
    • Description: Creates a new cell style and sets the background color of the cell to yellow.

  2. "NPOI set cell color based on value"

    • Code:
      if (cell.NumericCellValue > 0) { var positiveStyle = workbook.CreateCellStyle(); positiveStyle.FillForegroundColor = HSSFColor.Green.Index; positiveStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = positiveStyle; }
    • Description: Changes the cell color based on a condition (e.g., if the numeric value is positive, set the background color to green).

  3. "NPOI change font color in Excel cell"

    • Code:
      var font = workbook.CreateFont(); font.Color = HSSFColor.Red.Index; var cellStyle = workbook.CreateCellStyle(); cellStyle.SetFont(font); cell.CellStyle = cellStyle;
    • Description: Changes the font color of the cell text to red.

  4. "NPOI set cell color in XLSX format"

    • Code:
      var cellStyle = workbook.CreateCellStyle(); cellStyle.FillForegroundColor = IndexedColors.Orange.Index; cellStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = cellStyle;
    • Description: Sets the background color of a cell in the XLSX format to orange.

  5. "NPOI change cell color dynamically"

    • Code:
      var dynamicColor = GetDynamicColor(); // implement a method to get a dynamic color var cellStyle = workbook.CreateCellStyle(); cellStyle.FillForegroundColor = dynamicColor.Index; cellStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = cellStyle;
    • Description: Changes the cell color dynamically based on a method (e.g., GetDynamicColor()).

  6. "NPOI set background color for multiple cells"

    • Code:
      var range = sheet.GetRow(0).GetCell(0, MissingCellPolicy.CREATE_NULL_AS_BLANK) .CellRangeAddress(0, 10, 0, 5); // Change the range accordingly var cellStyle = workbook.CreateCellStyle(); cellStyle.FillForegroundColor = IndexedColors.Yellow.Index; cellStyle.FillPattern = FillPattern.SolidForeground; sheet.SetCellStyle(cellStyle);
    • Description: Sets the background color for a range of cells in a row (adjust the range accordingly).

  7. "NPOI change cell color based on condition"

    • Code:
      if (cell.StringCellValue == "High") { var highPriorityStyle = workbook.CreateCellStyle(); highPriorityStyle.FillForegroundColor = IndexedColors.Red.Index; highPriorityStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = highPriorityStyle; }
    • Description: Changes the cell color based on a specific condition (e.g., if the cell value is "High," set the background color to red).

  8. "NPOI set cell color and font style"

    • Code:
      var cellStyle = workbook.CreateCellStyle(); var font = workbook.CreateFont(); font.Color = HSSFColor.Blue.Index; font.Boldweight = (short)FontBoldWeight.Bold; cellStyle.SetFont(font); cellStyle.FillForegroundColor = HSSFColor.Yellow.Index; cellStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = cellStyle;
    • Description: Sets both the cell background color and font style (bold, blue color).

  9. "NPOI set cell color in specific row and column"

    • Code:
      var rowIndex = 2; // specify the row index var colIndex = 3; // specify the column index var cell = sheet.GetRow(rowIndex).GetCell(colIndex, MissingCellPolicy.CREATE_NULL_AS_BLANK); var cellStyle = workbook.CreateCellStyle(); cellStyle.FillForegroundColor = IndexedColors.Green.Index; cellStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = cellStyle;
    • Description: Sets the background color of a specific cell in a specified row and column.

  10. "NPOI change cell color in Excel based on hex code"

    • Code:
      var hexColor = "#FF5733"; // specify the hex color code var rgbColor = new XSSFColor(System.Drawing.ColorTranslator.FromHtml(hexColor)); var cellStyle = workbook.CreateCellStyle(); cellStyle.FillForegroundColor = rgbColor.Indexed; cellStyle.FillPattern = FillPattern.SolidForeground; cell.CellStyle = cellStyle;
    • Description: Sets the cell color based on a specified hex color code.

More Tags

hammer.js apache-fop sidebar oracleapplications tree-traversal android-holo-everywhere asp.net-core bitbucket-server class-design bash

More C# Questions

More Fitness Calculators

More Date and Time Calculators

More Math Calculators

More Pregnancy Calculators