poi改变excel背景色

package temp;

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.HSSFColor;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

public class Temp1
{
    public Temp1()
    {
        init();
    }

    private void init()
    {
        HSSFWorkbook book = new HSSFWorkbook();
        HSSFSheet sheet = book.createSheet("111");
        HSSFRow row = sheet.createRow(0);
        HSSFCell cell = row.createCell(0);
        HSSFCellStyle style = book.createCellStyle();
        style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
        cell.setCellStyle(style);
        cell.setCellValue("111111111111");

        try
        {
            String s = "abc.xls";
            File file = new File(s);
            file.createNewFile();
            FileOutputStream out = new FileOutputStream(s);
            book.write(out);
            out.close();
        } catch (FileNotFoundException e)
        {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        } catch (IOException e)
        {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }

    }

    public static void main(String[] args)
    {
        new Temp1();

    }
}

 关键的代码是：

        style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        style.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);

 

很奇怪，插入的是foreground，而不是background。

评论

1 楼 pengyan5945 2012-09-28  

你插入的是前景色啊！