Hi, I figured this out. if the record is an instance of MissingCellDummyRecord, then i had to handle this explicitly.
Thank you. khan379 wrote: > > Hi, > Can somebody please help me to resolve this issue. this bug has been for > long time in our implementation. > > > khan379 wrote: >> >> 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-tp27657150p27695186.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]
