poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nishant Rao" <kn...@hotmail.com>
Subject Re: Some wierd problems with Excel2002
Date Wed, 23 Apr 2003 19:10:52 GMT
never mind...I played around with it a little further and it turns out I was 
incorrect in my observation -- basically, what I need to do is open the file 
in excel and save it. Only then am I able to successfully re-use this as a 
valid excel file -- if I try and use the file without first opening and 
saving it within excel then I get the weird behaviour of not being able to 
get all the columns within each of the rows...any ideas about that ??


>From: "Nishant Rao" <knrao@hotmail.com>
>Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
>To: poi-user@jakarta.apache.org
>Subject: Some wierd problems with Excel2002
>Date: Wed, 23 Apr 2003 19:00:54 +0000
>Hi folks,
>I have a file (format is a derivative of csv) where everything *has* to be 
>interpreted as text. So when I create an Excel file from it I write all 
>cells out as strings...
>...things seem to work great with Excel 2000 but with Excel 2002, it has 
>some extra error checking that flags a lot of the fields as possible 
>numbers. Now, while that could be turned off the weird part is that unless 
>I manually click 'convert to number' on these cells POI is not able to 
>successfully extract all the columns in the rows and hence causes my code 
>to crap out. If I do convert, everything works like a charm ???
>Again, I'm seeing this problem only with Excel 2002 -- any ideas ?
>Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org

Add photos to your messages with MSN 8. Get 2 months FREE*.  

View raw message