I prefer use : HSSFWorkbook workbook = new HSSFWorkbook(); 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]
