Fetch the data from different spreadsheet of excel

I want to extract the data from specific columns in different spreadsheet and paste it into spreadsheet,how to do it.
Thanks in advance.

HI @guptasweb

Can you share sample input and output ?


You can use read range activity to read the data from the excel and use the write range activity to write the data to other excel file.

output of il.xlsx (12.1 KB)
ILT.xlsx (3.4 MB)

but I need to extract some data not all the data of excel

there is the filter datatable activity using that after reading the whole file you can get the required data only.

I want to extract some rows i.e AH10:AS10 and AH15:AS15

use the read range activity like