There is no 'Open File' action

Help
1

I’m trying to open a csv file but I don’t see any actions to open any type of file for that matter. Help is greatly appreciated!
Respectfully,
Ingrid

2

Hi,

You can probably use “Excel Scope”
either that or “Open Application” with Excel used and the filepath in for Argument.

Typically, you won’t want to do it like this though. I would use Read CSV or Read Text file to store the data from the CSV to a variable, so you can manipulate and update that data internally. Then using Write activities like for example Write Range inside an Excel Scope you can update the file to a .xlsx if that’s what you want. Or simply Write CSV.

Thanks.