Store a certain range of data from one dataTable in to another

Hi guys,

Anyone here knows a way to get the data from one dataTable to another. Lets say i need to work with A2:H12 in the second dataTable. At the moment it’s being done like this:


but i want to remake it to make the program more efficient and faster.

Kind Regards,


First use Read Range activity and specify requried range to read data from Excel and store output in dataTable. And then use Write Range activity and pass that output dataTable to here to write into another Excel file.