When I would like to read an excel file which just downloaded using bot (within same rpa file), it shows “Archive file cannot be size 0.”
To check the problem with the excel file, I open the excel file, I found out that I have to click on the button shown below in order to edit.
After i clicked on the button and save the file, I run the activity to read range, it works now.
Any ways that I can fix the problem? To let the bot to deal with the protected view issue? Where I can directly download the excel file, then read and export data out.