Fetch the data from different spreadsheet of excel

Help Activities
,
1

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

2

HI @guptasweb

Can you share sample input and output ?

Regards
Sudharsan

3

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.

4

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

5

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

6

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

7

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

8

use the read range activity like
image