Need to add csv data in excel

Help Studio
, ,
1

Hi al!!!

For each transection i got new csv file which contains single row and need to add the data as a single row in another excel as a input

you can see below

csv file

image
image694×143 3.22 KB

need to add like below for each transection

image

please kindly let me know.

thank you!!!

2

Hi @vineelag ,
I understand is you have many csv files
and all of them have only 1 row
you need add all of them to 1 file
that’s right?
you can try add data row
or write data 1 row with index,
with original data last index+1
can you share file? I will test my process with your file
regards,

3

CAN SHARE WITH ME THE XAML PLEASE FOR THIS

4

can you share your file, or wait me create sample file like your image?

5

For each CSV file just Read CSV into a datatable then use Append Range to write to Excel.

6

Hi @vineelag ,
My input
list file

image
image546×661 23.8 KB

folder CSV
have 3 files sample
image
image947×661 52.5 KB

my output
image
my file
Sequence.xaml (12.4 KB)

hope it help

7

@Nguyen_Van_Luong1 thank you but its showing like this error unable to open that sequence

image
image788×614 24.5 KB

8

@vineelag Please use Append range for each transaction after reading CSV.

1 Like
9

Forum_Common.zip (33.5 KB)
You can try with zip file?
in sequence.xmal

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.