Hello,
I have a pretty simple process that extracts a data table, and I want it to each day at noon append it to an Excel file in my OneDrive. When I run the file in debug in Studio it works just fine. When I test the unattended robot in Orchestrator, it says that the process was a success, but when I check the file, it wasn’t updated. Any ideas why this is? It is all being run on the same machine.
I did remote debugging and it is extracting the data table just fine, the unattended robot is just completely skipping the append range workbook step…
I see this as the solution:
The orchestrator can only read range from files inside the package. Hence under whole project folder,excel path is “sample.xlsx”
(Just for recorrection on this, orchestrator can also read range from absolute address like below “C:\sample.xlsx” if this file is available.)
And can only write range to Adsolute Address like “C:\sample.xlsx”
BUT
How do I move the output file into the package? Where is the package?
Then package is downloaded to a different location when running from orcheatrator
If you want to write to a file in one drive then use absolute path and not relative path
Generally package is downloaded to C:\users\username\.nuget folder
So if you want the file to be used and over written use absolute path then the file would be over written else the file in package if present will be over written
Hope this helps
Cheers