How do i read range from 3 different excel file and paste it to another excel using studiox?

Hi there,

I would like to read range 3 different excel where i can merge them to one file with deleting empty rows using studiox.

Thanks!

@mark_rajkumar1

Welcome to the community

Read range is the activity to use to read…you can either do it in loop or one by one…then use merge datatable activity to merge the data and then use filter datatable to remove empty rows…and then use write range

or

Use read range to read the data…and then to append the data use append range activity to add the data directly at the end of first file…Before adding you can use filter datatable to clear the empty rows

Hope this helps

cheers

Hi @Anil_G can u show me with an example?

@mark_rajkumar1

Please check this…Modify as per requriement

ReadExcel.zip (50.1 KB)

cheers

Hi @Anil_G i cannot open the zip file. How do i open it?

@mark_rajkumar1

Unzip it and it has the project in it

Any issue?

Cheers

Yes i cannot open as it is restricted in my pc. Is there any screen shot available to see?

@Anil_G @Anil_G any screenshot