Append line from excel

Hi ,

I have excel file with 2 columns Day and EMP, and I use append line activity to append data from excel to word .

I am using for each my issues is the first coalman “Day” without column name so how I can use the row number instead of column name ?

row(“EMP”).ToString , it is work like this but i need row number if it is possible

Thanks

@Dev2

Welcome to forums

To get row number, As you are using For Each Row activity, You can check the properties of the activity, there you find a Index, Declare a Variable for that

so each time loop runs, the index will changes, as the index starts with 0, If you want start from 1 then you can use Index+1

Hope this helps you

Thanks

@ksrinu070184

Thank you

could you please give me example

@Dev2

Check as below

Messagebox content

Hope this helps you

Thanks

1 Like

thanks @ksrinu070184

so if I do not use the for each if the first column without hearer o got same error so it is count from second column