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!
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!
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
Yes i cannot open as it is restricted in my pc. Is there any screen shot available to see?