How to add manual increment in Write Celll

[a501ee789b18770c39989a6d5 (SimSon Joseph)]

Hi Friends,

I need your help on the manual increment in the write cell activity. I tried but it didn’t worked. Can you help on this request please.

I want to write data from my last row. So auto increment is not useful for this request. So that i need a manual increment.

[Yankit_Singh_R (Yankit Singh)]

Hi, You can achieve this using

1. Read the cell to get the data into the data table.
2. Assign the data table count+1 into a variable.
3. Inside the write cell activity use the cell index as “A”+lastrow
4. Increase the lastrow=lastrow+1 if you are in the loop.

[a501ee789b18770c39989a6d5 (SimSon Joseph)]

Thanks for your quick response to @Yankit_Singh_R ,

But I tired that options already but got below error. I believe that from the 3rd step only i got below error.

[ashokkarale]

@a501ee789b18770c39989a6d5

You should be entering full path at where to write like

excel.Sheet("sheetname").Cell("A"+lastrow.ToString)

Thanks,
Ashok

[muktadir]

Hi,

Please try the following

this will enter the data after the last row of the data table.

[a501ee789b18770c39989a6d5 (SimSon Joseph)]

Thanks to @ashokkarale

It is really helpful. Issue is resolved now.

[a501ee789b18770c39989a6d5 (SimSon Joseph)]

Thanks to @muktadir

Issue is resolved. Thanks for your help once again. It is really helpful.