RE: Retrieving numeric value using apache poi

I believe 0.27994 is how excel stores the value 27.99%. It looks correct to me, so if you want the value to read 27.99 just multiply it by 100 to get the percentage 27.99. -Levi -Original Message- From: becomp_2002 [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 23, 2007

RE: There has got to be a way

That would be of GREAT use. BTW: what do you think the ETA is for that? -Original Message- From: Nick Burch [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 6:05 AM To: POI Users List Subject: Re: There has got to be a way On Tue, 1 May 2007, Levi Strope wrote: All I need

RE: There has got to be a way

something as simple as tabbing to the cell may be sufficient to change a blank to a zero-length value. You may have already taken this into consideration, but thought I'd mention it as a first check. - David From: Levi Strope [mailto:[EMAIL PROTECTED] Sent: Tuesday

There has got to be a way

Please look at the attached excel spreadsheet. I would really appreciate some input. All I need to do is read in a row of data, just like the spreadsheet that is attached, and parse the information reliably. There are many blank cells here, but I need to account for them. My business

RE: how to find style in existing workbook for cell position with no cell

I believe it can be mapped to a BlankRecord because the cell itself still contains cell formatting. -Original Message- From: Haggerty, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 10:28 AM To: poi-user@jakarta.apache.org Subject: how to find style in existing workbook

Is there a way to listen for cells with no formating?

I need a way to listen for cells with no formatting and no values. Is there a way to do this? - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi

RE: Is there a way to listen for cells with no formating?

Is ther a hex value for cells with nothing? From: Levi Strope Sent: Friday, April 20, 2007 10:00 AM To: POI Users List Subject: Is there a way to listen for cells with no formating? I need a way to listen for cells with no formatting and no values

RE: Is there a way to listen for cells with no formating?

Does anyone have an example of how to use UnknownRecord() ? From: Levi Strope Sent: Friday, April 20, 2007 12:36 PM To: Levi Strope; POI Users List Subject: RE: Is there a way to listen for cells with no formating? Is ther a hex value for cells with nothing

problem with HSSF eventusermodel

I'm trying to read in an XLS and output the contents of each row exactly as they are read in by the file. I have to do this with the evenusermodel because of memory limitations, however it is proving to be very difficult. In short, my problem is I need to keep track of how many columns there

RE: problem with HSSF eventusermodel

it all in memory) in a guaranteed sort... or keep it in memory in a map/list structure of some sort. Which gets you back into the memory problem. XLS format BLOWS! -Andy Levi Strope wrote: I'm trying to read in an XLS and output the contents of each row exactly as they are read in by the file

RE: What is the correct method to read a large excel file line by line?

I just want to clarify, as my boss is asking me to look into it further. Per the documentation is says that using the HSSF eventusermodel is much more efficient in terms of memory. Does this mean that I can read in an excel document without loading the entire document into memory first? Reading

What is the correct method to read a large excel file line by line?

Using HSSF, what is the correct method to read large excel files line by line? In my real world situation the excel file will be very large, over 100 megs. I need to be able to read the file line by line so that the large file size does not cause memory issues. I have tried to use a

using HSSFRow.getLastCellNum()

Hello, In my code I'm using HSSFRow.getLastCellNum(), part of org.apache.poi.HSSF.usermodel to fetch the last cell number contained within the row I am currently on. I do this so I can iterate through each cell value and output it's contents. The description for this method is as follows:

Outputting CSV files

Can HSSF read in an XLS file and output a CSV? - 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/

Still having problems building POI

I'm sorry to keep pinging the list with something as rudimentary as this - but I am having a very hard time getting this to build. I am following the instructions on the how to build page, but I still get build errors. Can someone please take a look at the ANT build dialogue below and give me

RE: Re[2]: problems with POI build

. No intervention in Ant's config is required. Regards, Yegor LS Has anyone tested this with a newer version of ANT other than 1.5.3? LS LS From: Levi Strope [mailto:[EMAIL PROTECTED] LS Sent: Tuesday, March 20, 2007 11:07 AM LS To: poi-user@jakarta.apache.org LS

problems with POI build

I'm using ANT 1.7 and there is no optional.jars - has anyone worked through this before? Additionally - I did include all required .JARS per the 'How to Build' instructions - but I get an error telling me org.apache.xalan does not exist. It doesn't exist but I did include it in %ANT_HOME%/lib