Well here is snippet of the code.
Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("Business");
DataFormat df = wb.createDataFormat();
CellStyle style =wb.createCellStyle();
style.setAlignment(CellStyle.ALIGN_RIGHT);
style.setFillForegroundColor(HSSFColor.LIGHT_BLUE.index);
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
style.setDataFormat(df.getFormat("$#,##0.00"));
// more of similar code with different formats
// create rows and cells - set cell value and cell style
// s is data in String format
cell.setCellValue(s);
cell.setCellStyle(style);
//set column width below and write the file
for (int i = 0; i < headerList.size(); i++) {
if (i == 0){
sheet.setColumnWidth(i, 256*33);
} else {
sheet.setColumnWidth(i, 256*15);
}
}
String file = "C:\\workbook.xls";
try {
FileOutputStream out = new FileOutputStream(file);
wb.write(out);
out.close();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Christophe Charles wrote:
>
> Hello Dhiruster,
>
> Can we have some piece of code ?
>
> thx
>
> 2009/7/28 dhiruster <[email protected]>:
>>
>> Hi,
>> I am new to apache poi and excel. We have a user requirement to export
>> data
>> to excel from a grid.
>>
>> I am using poi-3.5-beta6.
>>
>> I am using dataformat e.g.
>> style.setDataFormat(format.getFormat("$#,##0.00"));
>> and applying to each cell.
>> When I bring up the spreadsheet the data is still in the original format.
>> The format is only applied if I select the cell and hit enter.
>>
>> I would like to see the format already applied to all cells when I open
>> the spreadsheet. How do I go about doing that?
>>
>> Thanks in advance.
>>
>> Dhiruster
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Applying-format-tp24701685p24701685.html
>> Sent from the POI - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
--
View this message in context:
http://www.nabble.com/Applying-format-tp24701685p24703463.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
