Hi
I have A project ,
this project is to Convert all excel file .xlsx file into .csv
all .xlsx file is placed in the folder.
and i want the result which is .csv also placed to the other folder.
rename file name extension i think it is a bad Idea
Use Directory.GetFiles command to retrieve all files and iterate through loop with For each acitivity. Use read range activity to read excel file and output to dt1. Next step would be to create csv file with dt1 and save it on your desired path.
hi @VirajN,
Yes that’s my point but i have many excel file to convert.
i want all of my excel file in my folder to convert and the result is placed into another folder.
First variable Files will be of String Array.
You can simply tell me the variable name and i’ll get back to you. I can’t upload any workflows due to security purpose.