Re: Fwd: Re: another problem with getLastCellForRow()

["Andrew C. Oliver" <ac...@apache.org>]

1. Use the iterator methods.  
2. Sort the rows (the order isn't gauranteed) with a SortedList (see 
Java collections) of your choice
3. Output blanks if rows are skipped.

Not the most efficient thing in the whole wide world, but it will work. 
  Personally, I'd use the eventusermodel and instead collect them that way.

I keep trying to tell people this in nice ways......  I do want to be 
clear though:

Please do not send me mail directly.  Its not only inconvienent for me 
(as I prefer direct communication be reserved for clients), but its 
insulting
to the rest of the POI developers whom contribute.  I'm also FAR less 
likely to answer basic questions than are other users.

-Andy

Nishant Rao wrote:

> Hey Andrew,
>
> Sorry to bother you directly but I was wondering if you could provide 
> any further ideas/comments on this issue (below). I have already 
> posted this to the mailing list but due the holidays, it might have 
> fallen off the radar hence my mail to you alone (any further questions 
> shall come thru the mailing list :-)...
>
> ...thanks again for all your help !
>
> -nishant
>
>> From: "Nishant Rao" <kn...@hotmail.com>
>> Reply-To: "POI Users List" <po...@jakarta.apache.org>
>> To: poi-user@jakarta.apache.org
>> Subject: Re: another problem with getLastCellForRow()
>> Date: Fri, 29 Nov 2002 02:47:34 +0000
>>
>> well I care about that particular row's properties (as oppossed to 
>> defined properties) since we are trying to convert that row into say 
>> csv. Now if the row in excel only had one entry (and somehow end of 
>> line was indicated which I guess is the unknown here) then the 
>> corresponding csv should also have only one entry rather than five 
>> entries with only one having a value and the rest blank.
>>
>> I know this can get confusing since you dont know if that cell 
>> shouldnt be defined Vs it being left blank. Thats why I wanted to 
>> know if there was anyway for the person creating the excel file to 
>> indicate this preference.
>>
>> But another thing that comes to mind is that say of 5 rows, the third 
>> was left completely blank, then when trying to retrieve that row POI 
>> throws an exception as it was unable to access the row. But if your 
>> belief is to have bounds just set in the form of a matrix (ie. max 
>> row and max column) and the row index is within bounds, then it 
>> should treat it just like a row with blank cells right ?
>>
>> any thoughts ??
>>
>> thanks and a happy thanksgiving to everyone ! :-)
>>
>>
>>
>> _________________________________________________________________
>> MSN 8 with e-mail virus protection service: 2 months FREE* 
>> http://join.msn.com/?page=features/virus
>>
>>
>> -- 
>> To unsubscribe, e-mail:   
>> <ma...@jakarta.apache.org>
>> For additional commands, e-mail: 
>> <ma...@jakarta.apache.org>
>
>
>
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
> http://join.msn.com/?page=features/virus
>
>