You can try this :
HSSFDataFormat dataFormat = wbook.createDataFormat();
shot indexFormat = dataFormat.getFormat("$#,##0.00");
HSSFCellStyle style = wbook.createCellStyle();
style.setDataFormat(indexFormat);
cell.setCellValue(s);
cell.setCellStyle(style);
2009/7/28 dhiruster <[email protected]>:
>
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
