Excel Task

Hi @ All

In excel i have a few columns are there
I need to read a three columns in that sheet
How ??

Hi @varunk,

Use Excel Application Scope activity and in do activity add read range activity to read the data from Sheet with range of columns.

@varunk
First read the excel sheet and store it in a datatable dt
then use dt.AsEnumerable.DefaultView.ToTable(False,“Column1 Name”,“Column 2 Name”,“Column 3 Name”)

If you want distinct values make it as true

then use write range to print.

Regards,
Mahesh

2 Likes