This issue was randomly occurred with different RPA process. Sometimes after read range, the excel file will be clear as a empty sheet. Does anyone face the same issue before ?
No, its look like some where BOT is overriding or some other bot accessing this file and overriding the same.
Did you leave the “create if not found” box checked on your Use Excel File activity?
It is interesting that the excel file will be clear at first run. In second run after recreating the file, it can process normally with same excel file.
It is only possible that bot is not downloading that file…and its creating a new file…just check if you are downloading the file it is getting downloaded or not and in properties of excel scope create if not exists is checked