Can you not store the invalid row number at the time of validation?
On 7 May 2014 06:48, Renjith R <[email protected]> wrote: > Hi, > > I am trying to edit an existing excel file using SXSSF. This excel may > contain 1 Million records. I have to validate each row in excel and if the > recors is invalid, append error message in the last column. Valication > process is done first, at that time i will note down the row number which > is invalid. once aall the validation is over, i'll take a copy of the file > and write the error details at the end of each failed rows. > Since SXSSF is write only, I am getting a null value when i tried to get > the invalid row with the row number. Please suggest a better way to resolve > it. > > > -- > *RENJITH R* > 9446011990 >
