Hi friend,


To set the background color of excel using POI:

<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"%>
<%@ page import="org.apache.poi.hssf.util.HSSFColor"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%

try{
HSSFWorkbook hwb = new HSSFWorkbook();
HSSFSheet sheet = hwb.createSheet("new sheet");
HSSFCellStyle style = hwb.createCellStyle();
for(int j=0;j<10;j++)
{
HSSFRow row = sheet.createRow((short) +j);
HSSFCell cell=null;
for(int i=0;i<256;i++)
{
cell = row.createCell((short) +i);
cell.setCellStyle(style);
}
}

style.setFillBackgroundColor(HSSFColor.AQUA.index);
style.setFillPattern(HSSFCellStyle.BIG_SPOTS);
style.setFillForegroundColor(HSSFColor.AQUA.index);
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

FileOutputStream fileOut = new FileOutputStream("C:\\excel\\fillsColor.xls");
hwb.write(fileOut);
fileOut.close();
out.println("Your excel file has been generated");
}
catch (Exception ex){

}
%>

For read more in details to visit....

http://www.roseindia.net/jsp/poi/index.shtml

Thanks