aspose file tools*
The moose likes Other Open Source Projects and the fly likes root cause of problem ,why 2003 excel cell background color is not reflecting in orginal document Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Reply locked New topic
Author

root cause of problem ,why 2003 excel cell background color is not reflecting in orginal document

anish reddy
Ranch Hand

Joined: Apr 19, 2008
Posts: 74

posted Yesterday 8:41:21 PM
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();


i want to know the root c ause of problem why it is not reflecting
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

Please stop posting the same question; thanks!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: root cause of problem ,why 2003 excel cell background color is not reflecting in orginal document