I am trying to Save an Excel File to a different format using UI Path.
The workflow works fine, it opens the Save As window, inputs the filename, it selects the file format in the dropdown list and then it clicks the save button. However the file format does not change.
This is the bit of the flow in question:
At the end of that bit of the workflow, it save the file with the new name, but it’s not in CSV.
My Process requires me to write datatables into a template (xlsm), save it with a different filename in order to avoid altering the template, delete some rows and make it to CSV.
The way I picked is the best from my point of view.
I know there is an alternative to read the processed excel into a datatable and then write it to CSV, however that would create extra files which I am trying to avoid.