poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From khan379 <ak...@i-behavior.com>
Subject Re: xls file reading skipping record
Date Fri, 19 Feb 2010 17:41:59 GMT

Thanks for the reply Nick. i think i did not put my question right way.
i have missing cell  in my records. and if the very first cell(column A) has
no data the reader just skips to read further cells in the line.

i understand that if the whole record is blank then skipping that line makes
sense.


Nick Burch-11 wrote:
> 
> On Fri, 19 Feb 2010, khan379 wrote:
>> I am seeing an issue with the HSSF reader to read a xls file. if the
>> first
>> column of my xls file is blank then the reader is not reading the record
>> at
>> all.
> 
> That's probably because excel decided not to put a record there at all. 
> You only get blank records generally when something used to be there but 
> isn't any more, but that's entirely up to excel. Gaps with no records are 
> quite normal (and helpful for the perpective of file sizes!)
> 
>> or there is any way to take care of this.
> 
> MissingRecordAwareHSSFListener is probably what you want - it notices the 
> gaps and puts fake records in for you
> 
> Nick
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/xls-file-reading-skipping-record-tp27657150p27657738.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message