Finding a faulty record in Excel sheet


#1

Hi Folks,

Quick question which was asked in one of the interview, consider you are working in automating the excel and there are 5 records where your Robot need to read and write it in another excel. Consider that the third records is corrupted or not able to read by robot, in this situation how Robot will process or it will throw any exception?


#2

Hi ,

There won’t be any chance of corrupting data based on records in the Excel, He tried to twist in the interview.

In real time this scenario won’t be possible. Because in 5 records one wont be corrupted. if you still believe we can find the corrupted data, please provide me more details.

You can always use “System.Exception” exception which most of the scenario’s can be helpful.

Let me know if you require any further info.