Hi @ All
In excel i have a few columns are there
I need to read a three columns in that sheet
How ??
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