Do anyone know how to read particular value from excel and populate in email?
Yah that’s possible with two ways
One is with Get Row item activity
to be very simple use assign activity and mention like this
Where both the row index and column index starts from 0 for first row and first column
-this will give the particular cell value from a excel
The steps involved is
—use excel application scope and pass the file path as input
—use read range activity and get the output with a variable of type datatable named outdt
—now use a assign activity and mention with expression as mentioned above where the output is stored to a string variable
—this variable can be passed to email with send outlook mail activity either as body or subject or to property in it
Or if we want to get each value row by row
Then we can use for each row loop activity next to the read range activity and pass the outdt as input
—inside the loop use a assign activity and mention like this
Out_value = row(“yourcolumnname”).Tostring
Where Out_value is a string variable
—this can be used in send outlook mail activity with any property we want
Or we can use write cellactivity mentioning the cell position and sheetname as input and get the output with a string variable
Hope this would help you
There are different ways of reading a value from excel. And the activity we need to use depends on how you want to extract the data from the excel.
- If you want to read the entire excel, then you can use the Read Range activity to read the data onto a datatable. Then, you can use a For Each Row activity to loop through the data table and access the data in it.
- If you want to read only a specific cell, then you can simply use the Read Cell activity to read the content in a cell