9
I have an applicaton where I am processing 5000 files to 6000 files during a loop.
In a try and catch block I am reading the excel file and processing each individual cell.
Of course all the Files are in the same format, but In some files the data in the cell in may vary it may contain data or not
when ever there is an exception while processing 100th file, the whole processing is stopped and exception is thrown,
But I dont want that scenario, instead if there is an exception at 100th file, the iteration should continue with 101th file. And in the end I should know which file is processed succesfully and which one is failed.
Exception which I am gettng are
NumberFormatException and NullPointerExceptions
How to hand that scenario?