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: [email protected] > For additional commands, e-mail: [email protected] > > > -- 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: [email protected] For additional commands, e-mail: [email protected]
