how to handle the issue while reading the records

[mukeshkala]

Same Issue :

Error Reading excel file

The issue here is that the excel file itself needs to be changed. You can handle it within UiPath with a try-catch, but what do you do when you catch the error? The only fix is to have the team creating the excel file to fix it. They are passing a broken file so it is on that team to fix it. If you know 100% of the time they will be passing a file with this exact same error (saved in excel as date, but should be text or number instead) then you can handle that by opening the file and changing t…

I was able to Read the file After I clear the Formats in excel…

In Bot :

• You can open the File
• Send Hotkeys to clear Formats
• Read and Proceed

–
Mukesh