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.

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.