wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes facing diffculty to highlight background color of an excel cell which is not reflected in file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "facing diffculty to highlight background color of an excel cell which is not reflected in file " Watch "facing diffculty to highlight background color of an excel cell which is not reflected in file " New topic
Author

facing diffculty to highlight background color of an excel cell which is not reflected in file

anish reddy
Ranch Hand

Joined: Apr 19, 2008
Posts: 74
iam unable to fill background color for an excel cell

HSSFWorkbook hwb = new HSSFWorkbook();
HSSFSheet sheet = hwb.createSheet("new sheet");
HSSFCellStyle style = hwb.createCellStyle();


HSSFRow row = sheet.createRow((short) 0);

HSSFCell cell = row.createCell((short) 0);
cell.setCellValue(1);

style.setFillBackgroundColor(HSSFColor.RED.index);
style.setFillPattern(HSSFCellStyle.BIG_SPOTS);


cell.setCellStyle(style);


FileOutputStream fileOut = new FileOutputStream("C:\\fillsColor.xls");
hwb.write(fileOut);
fileOut.close();

here is my code please can any one give inputs which correctly reflects background color for a cell of an excel or code do it
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: facing diffculty to highlight background color of an excel cell which is not reflected in file