I’m trying to use read range within excel application scope. My UiPath version is 2020.4.3 community license and I have Excel 365. However, when I tried to run the sequence in debug mode, I keep getting the assertion failed message (attached) and if I click abort, it will say my excel is not install (but I do have excel installed), any ideas how to solve this? Note, if I use UiPath version 2019.4.4 with excel 365, I can use the read range in excel application scope without any error.
Sorry, this might be an obvious answer, but I assume the workflow will look like attached? However, what would you input for query in the find file activity and workbook in the read range since we can’t directly choose the file anymore?
Btw, if I have the use excel application scope, is there a way to fix the error?
Sorry, I’m not familiar with the read range activity under microsoft 365, do you know if i only use read range without excel application scope, what should I input under the workbook? like a filepath or just the filename string? Cause it says use find file and folder activity to retrieve the driveitem