How do i copy excel cell data and paste it into a csv file? Help!Help!

Learning Hub
,
1

Hello There,

I have a Macro enabled excel file from which i want to pick up a particular cell info paste it in an existing CSV.
FOR EXAMPLE, i want to copy the number (239468) under column B of macro enabled excel file along with the headers and paste it in csv file.
image

Which activity should i use? Kindly advise.

2

Hi @HD001

Use read csv and use for each loop

And then use write csv

Thanks
Ashwin.S

3

Thanks Ashwin, but please advise how will read CSV help ? As my original file is an excel.
Below is the my process flow

  1. Open macro enabled excel file
  2. Click refresh button (Macro)
  3. Copy column B
  4. Open CSV and paste the column

Appreciate a help!

4

Can any one please help

5

Hello @HD001,

you can use “Read Range” and “Write CSV” activities for that.
If you need to run your macro first you can use the activity run macro before Read Range.

Attached a little example. (Main.xaml (5.5 KB))

excelToCSV
excelToCSV443×563 10.2 KB

Cheers,
Lunk