Unable to output the excel values

Help
, ,
1

getting same value 5 times in output message
value: EmployeeSystem.Data.DataRow

image

image
image898Ă—561 18.8 KB

1 Like
2

Hi @98d5b817dcd19244c50b

your getting that message because your printing row object

You need to use Get Row Item activity inside the for loop to get row values

3

@98d5b817dcd19244c50b,

Use row(“NameOfYourHeader”).ToString

1 Like
4

Hi
You were almost done
The variable row we have mentioned in this message box activity is of type DATAROW so if we want to get any value of a particular column from that Datarow, we need to mention the column name or column index
For example with your expression been used
“Employee”+row(“yourcolumnname”).ToString
Or
“Employee”+row(column index).ToString

Where column index starts from 0 flr first row and first column

Kindly try this and let know for any queries or clarification
Cheers @98d5b817dcd19244c50b

1 Like
5

Good job, I was too lazy to type all that lol

1 Like
6

haha… @rmunro
kindly let know for any queries or clarification @98d5b817dcd19244c50b

7

This works but im getting the row 1 as well…which is not needed.

image

1 Like
8

you were almost done

in that case
inside the loop use a IF condition like this
NOT ExcelDataTable.Rows.Index(row).Equals(0)
Inside that use this MESSAGE BOX activity
“Employee”+row(“yourcolumnname”).ToString
Or
“Employee”+row(column index).ToString

Cheers @98d5b817dcd19244c50b

9

I found own solution
Just check the add header checkbox while reading the excel.
This will acknowledge the header and ignore it while popping up excel data.