I'm new to this, and I'm setting up a new job that when this file "Template_Revert.xlsx" is saved or changed I'm running a task of Excel Get Cell to copy a selected range of cells, and I want to create a new CSV file with that data. So, my flow was going to be using a file trigger on this excel file, then do a Excel Get File, then Create File, since the file i need is in CSV, I probably need to do another convert or something afterwards. However, I wasn't able to get that far.

Here's the trigger I've setup for the Template_Revert.xlsx file:


I'm not sure if my trigger will work or not, if i want the tasks to happen when the file is saved, or on exit or something. Here's the Excel - Get Cell that I've created, which you can see that I was able to point to the file, and select the specific sheet, and I'm trying to grab cells A1 - P2, but I used P10 in case if I do need to grab more data in the future, those cells are blanks anyways.


This is actually about as far as I got to, because when I test this job, I had errors. I thought maybe because there's no action to complete anything after I got the data, so I continued my setup and created a Excel - Create task, which I used the variable of the Excel - Get Cell from the last task, because I'm putting the result from that onto the new file that I need. Here's my setup for that:


The picture demonstrated an error that's shown when I'm using Output (stderr) which i have no idea if it's the right one, but the other ones are either blank, or the Result says Failed. The errors made me think that it's somehow not able to properly connect to the file, because it looks like a path issue, but I was able to pick that file without a problem, and I was able to get the list of sheets from that Get button when I was setting up the Get Cell task. I don't know what's the issue, please help!

*UPDATE* I've tried to skip the Get Cell and use the Convert directly, since it seems like you can pick a sheet and choose cell range then save it to another file. This is what I got, looks like a path issue again.

Is that path accessible by the service/user Visual Cron is running under? Is Z a mapped drive and if so is it mapped on the server?

Yes, the path is a mapped drive, I have some other tasks that are all working fine while involving files and directories in the Z drive.

Do not use a mapped drive but UNC path instead. Make sure that you can access it from the VisualCron server as you are using a remote browser which is not the same as accessing it from that server.

---