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-tp27657150p27691437.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]
