如何用POI获取Excel单元格颜色？Java应用遇空值问题求助

Hey there! I’ve run into similar compatibility quirks between WPS-generated Excel files and Apache POI before, so let’s break down why you’re getting null for cell colors and how to fix it.

The Core Mix-Up: Foreground vs. Background Fill Colors #

First off, the method you’re using—getFillBackgroundColorColor()—isn’t targeting the color you actually set in WPS. Here’s the critical distinction:

• Fill Background Color: This refers to the color behind any fill pattern (like stripes or dots) applied to a cell. Unless you explicitly added a pattern, this value is almost always empty.
• Fill Foreground Color: This is the solid fill color you see as the cell’s background when you use WPS’s color picker.

The quick fix? Swap your method call to getFillForegroundColorColor().

Updated Code to Retrieve Cell Fill Color #

Here’s a revised snippet that handles both direct RGB colors and themed colors (which WPS frequently uses for cell styling):

XSSFCell cell = row.getCell(j);
if (cell == null) {
    // Handle empty cells if needed
    return;
}

XSSFCellStyle cellStyle = cell.getCellStyle();
XSSFColor fillColor = cellStyle.getFillForegroundColorColor();

if (fillColor != null) {
    if (fillColor.isThemed()) {
        // Convert WPS theme color to RGB (common scenario)
        XSSFWorkbook workbook = cell.getSheet().getWorkbook();
        ThemeColor themeColor = fillColor.getThemeColor();
        double tint = fillColor.getTint();
        
        // Get final RGB value with tint applied
        Color rgb = workbook.getTheme().getThemeColor(themeColor).getRGBWithTint(tint);
        System.out.printf("Cell fill color (RGB): %d, %d, %d%n", 
            rgb.getRed(), rgb.getGreen(), rgb.getBlue());
    } else if (fillColor.isIndexed()) {
        // Handle legacy indexed color palettes
        System.out.println("Indexed color code: " + fillColor.getIndex());
    } else {
        // Direct RGB color value
        byte[] rgbBytes = fillColor.getRGB();
        System.out.printf("Cell fill color (RGB): %d, %d, %d%n", 
            rgbBytes[0] & 0xFF, rgbBytes[1] & 0xFF, rgbBytes[2] & 0xFF);
    }
} else {
    System.out.println("No solid fill color set for this cell");
}

Extra Troubleshooting Tips #

1. Update Apache POI: Older versions have spotty support for WPS’s file formatting. Make sure you’re using the latest stable release (e.g., 5.2.5 or newer).
2. Validate WPS Save Format: Ensure WPS is saving the file as a standard .xlsx (not a proprietary WPS-only format). Use "Save As > Excel Workbook (*.xlsx)" to avoid compatibility issues.
3. Check Style Inheritance: If the cell’s color is inherited from a row or column style (not set directly on the cell), you may need to retrieve the row/column’s style instead.

内容的提问来源于stack exchange，提问作者Venkat Raj