File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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