Write Cell activity in StudioX: Auto Increment Row not working in Excel file

Hi Automation Experts,

I am using the ‘Write Cell’ action nested inside a top ‘For Each Excel Row. It should store formula (number of days between current date and some other date) used in the first row, the ‘Auto Increment row’ is turned on.

Now, the issue is that first two row shows the correct number of days, but the consecutive rows also displays the same number of days.

Formula used: =Today()-G2

What could be the root cause?

Thank you in advance!

Screen shots below.


Excel sheet

read excel and use for each row,
take one assign
row.tem(“target column”)="pass formula as per increment "

Hi

Sorry, not able to understand. I am not able to find read excel activity. Do you mean read cell value/formula? Can you explain a bit elaborately? Sorry for the trouble.

Thank you in advance!

Hi @Karunamurthy ,

Could you try using the Fill Range Activity instead?

Kind Regards,
Ashwin A.K

Hi,

Thank you! “Fill range Activity” is working :slightly_smiling_face:

Thank you, again!

1 Like

Glad I could help!

I’d appreciate it if you marked the answer as Solution so that others facing similar queries may benefit from it, and also so as to close this thread.

Have a nice day!

Kind Regards,
Ashwin A.K

Hi,

Sure, marked the answer as solution.

Thank you!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.