How to give cell value dynamically in write cell activity

Help Studio
, ,
1

hi ,

How to write the cell Index dynamically while writing it back to Excel ?

image

2

@monishanair2010

When you say cell index you mean to use any integer variable to do count and give that?

If so

Excel.Sheet("M9").Cell("C" + integervar.ToString)

Cheers

3

Hi @Anil_G

I am giving a condition and filtering a row , and write back to the same specific cell , would counter works ?

image

4

Are you using For Each Excel Row? If so, you don’t have to count the rows. That’s what CurrentRow is for. You’d just use Assign instead of Write Cell.

5

hi @postwick - yes I am using for each excel row , Agreed, but I need to make the value negative in another column based on the condition specific to a column, for that I thought I need to write back so used write cell?

but how assign works for updating a cell ?

6

@monishanair2010

You can use

CurrentRow(columnvalue or name).Value = value you want to update

Cheers

7

Hi @monishanair2010,

To find the cell index you can use vlookup activity by passing the any value in that row. there you can get cell index like A20, here extract the number like 20 and in your write cell activity pass the column value let say C+extracted index(20)

8

If your Excel file has headers, you can just use Assign CurrentRow(“otherfieldname”) = “new value”