How to use write cell excel activity dynamic in For each row(Data table)

datatable
excel
activities

#1

How to use write cell excel activity dynamic in For each row(Data table). I need to get the cell position from the data table so that I can pass it in cell range.

Please help to sort out this trouble.

Thanks.


#2

You can use IndexOf to get the row number of an item.

image

image


#3

Hi, Yes, its working fine. But the cell number from the Data table and Cell number from the excel is same?


#4

Hi, its worked fine to get the excel cell number by adding two to it.! Thanks.


#5

am getting error like invalid sheet range.what i supposed to enter in the range field to write data on the excel sheet for every data entry??


Regarding Write cell activity use
#6

HI @REKHASRPF,

image

Here you need to mention the which column Value need to write
For Ex : "A"+ind.ToString()
Refer the image


#7

Hey, thanks it works


#8

Hi, I am doing something similar. In my workflow, after the condition if there is a particular line then write true for that particular row E cell, instead of writing for that particular cell it writes for all the cells in column E. pLS help. Thank you