Hi, We are working on a project which generates Financial reports and write the values to a Excel sheet which will be emailed to the Customer. requirement is to store the value in the cell in the format of $345,109,456.00 The value gets stored correctly when I open up the excel sheet. But theproblem is, it has a error message next to it saying "The Number in this cell is formatted as text or preceeded by apostrophe". The error goes away If I edit the cell and selects the option of Convert to number I tried creating the cell type as HSSFCell.CELL_TYPE_STRING and HSSFCell.CELL_TYPE_NUMERIC and still I have the above issue. Please can someone tell me how to get around this. Please find the attached excel sheet generated through the java code
I am using poi-3.5-FINAL-20090928.jar,poi-contrib-3.5-FINAL-20090928.jar,poi-ooxml-3.5-FINAL-20090928.jar,poi-scratchpad-3.5-FINAL-20090928.jar. Thanks and Regards Siva
Book.xls
Description: MS-Excel spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
