How to read the excel column


#1

I had tried multiple solutions its not working , my excel sheet two rows and two columns has read the by row1 and column1 .

please suggest .

: foreach (Row in dtOutput.Rows)// For each row
{
foreach(Col in dtOutput.Columns)// For each column of a row
{
If( Row(col) = “Emp_Name”)
{
// activity
}
}
}


#2

Hi @jkkarthik,

Have you already tried the Excel activities like Read Range?

There are a lot of examples here in the Forum. If you still need help, please let me know.