A friendly place for programming greenhorns!
Big Moose Saloon
Search
|
Java FAQ
|
Recent Topics
Register / Login
JavaRanch
»
Java Forums
»
Products
»
Other Open Source Projects
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: 72
posted
Aug 01, 2010 09:11:21
0
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://jrebel.com/download
subject: facing diffculty to highlight background color of an excel cell which is not reflected in file
Similar Threads
Generate Excel report in java
opening the excel sheet from servlet
Set character formatting in Excel using POI
root cause of problem ,why 2003 excel cell background color is not reflecting in orginal document
How to make POI HSSF support Chinese Encoding?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter