Amol Thank you so much But can you tell me how to apply this format to the value that i received from the cell
Thanks Bryan On 9/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
bryan, you will need to handle this in your application by determining the dataformat of a cell and applying it to the value retrieved. eg. in your case, you would get the dataformat using: String format = HSSFDataFormat.getBuiltinFormat(c.getCellStyle().getDataFormat()); The value of /format/ in your case would be "@" indicating a "Text" format. You will then need to *apply* this format to the value you receive from the cell (after determining the cell type etc.) However there may be more to it depending on how your excel is generated. If you have inserted value into a cell in that column after applying the "Text" format, you will notice that excel may choose to store the value as text (I think you are given an option whether you want to store it as number instead). OTOH, if you insert values cells before applying the "Text" format, you will notice that the values are stored as numbers but formatted as text. So you either need to make assumptions about how data is entered in excel or handle both cases generically and apply the text format in your java code if the cell type is NUMERIC hth, ~ amol --- Bryan Liu <[EMAIL PROTECTED]> wrote: > Hi, > > I have a big trouble about the excel cell's format. > In my project, I readed the data from the excel > file. For one column, it > supposed to be String format and I alse set the > format as text in the Excel. > But in some cells in this column, all the character > is number(like this > "51231341"). When I read them in the java code, the > poi read these data as > double, and if I transfer them in to string, it will > show as this " > 5.1231341E7". This is not the data I want. > Thought I have resolved this problem by reformat > this kind of stupid String. > By I'd like to know if I can read the data follow > the Excel's format or I > can specify the format that I want when read the > data from file. > > Dose the POI have this kind of feature. > Thanks > > -- > > Regards! > Bryan.Liu > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
-- Regards! Bryan.Liu
