how to handle the issue while reading the records

[mhk15 (mehak)]

how to resolve the error occuring while reading the records from excel file. Sharing the image of error and excel sheet…please suggest me how to handle this?Reports.xlsx (2.4 MB)

[Palaniyappan (Forum Leader)]

hope this would help you

How to solve error: "Read range : Not a legal OleAut date." in excel?

I was having the same issue and it was due to for some weird reason the “read range” activity couldn’t actually get the cell or it would get it in the wrong format instead of just the value of the cell. What worked for me is putting the read range activity in a “Excel Application Scope” which effectively quickly opens excels, does what ever is in it’s scope and closes excel. After implementing that it was able to pick up on the values in excel. Another option would be to try and print the valu…

Not a legal OleAut date

hello all, [Screenshot%20(14)] what is this error?and how to solve it??

Cheers @mhk15

[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

[Dave (David Wiebelhaus)]

Be careful with this solution. If you are supposed to get dates then you will now get number values instead. So you might want to get the date August 22, 2019 but instead you will get the number 43699

[mukeshkala]

Agreed

[mhk15 (mehak)]

Still not able to read this sheet after chainging th format… Could please share the xaml for this?