Convert All .xlsx File Into .csv File

Help
1

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
image

Please Help me with this ,
Aupe

2
  1. Read the .xlsx files using the read range activity.
  2. Write the range in a new file using the Write CSV activity.
1 Like
3

@Aupe

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.

4

how about manipulating file path of those excel & result.

5

hi @singhonkar,
Sorry I’m just only beginner,
can i ask .xamp file for me to check & study.

thank you
-aupe

6

@Aupe

Please refer to below screenshots.

image
image882×427 15.6 KB

image
image1073×410 11.9 KB

image
image1076×395 15.1 KB

image
image1071×459 19 KB

image
image1091×413 14.5 KB

Let me know incase of any queries.

7

try this Main.xaml (6.7 KB)

8

Thank you @singhonkar

for this sample & possible solution,

9

@Aupe
Welcome. I tried this on my machine and it’s working. Do let me know incase if you’re facing issues.

10

this method is also right,
but manipulating file path is one of my big problem.

but thanks for this.

11

ill give you feedback later.

thanks

12

I have picked the excel from a folder and saved the csv in another folder. I thought this is what you were looking for.

13

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.

14

hi @singhonkar can i see variable Type .

15

@Aupe

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.

16

Filepath also a String array right ?

17

error found

image
image1366×768 140 KB

18

@Aupe

FilePath variable is of string type. This will your destination path where you want your files to be stored.

19

@Aupe
Can you please share your write csv activity screenshot.

20

@Aupe

Please do a little modification.
remove previous assign activity and add this.

image
image1051×432 15.2 KB