How to do Increment value in excel

[kuih_sedap]

i need to update data daily in same excel file, instead of set to “A1”,“A2”…how to do increment to next cell,pls

[lakshman (Ganta lakshman)]

@kuih_sedap

Create one counter variable of type Integer and keep it in loop to increment one by one.

In Write Cell activity, specify range as “A”+counter.Tostring

[kuih_sedap]

can i use the counter variable without loop operation?

[kuih_sedap]

[lakshman (Ganta lakshman)]

@kuih_sedap

Here you need to do perform set of activities repeatedly right. So you need to use loop operation only.

[samir (Samir Mohite)]

Hi @kuih_sedap,

@kuih_sedap

can i use the counter variable without loop operation?

If this process will run daily and to do so you can first, read range and store data in DT (datatable var)
And then by using
rows (int32) = DT.Rows.Count —> you’ll get count of row in sheet
And while write cell activity you can pass
—> “A”+(rows+1).ToString as range.

[kuih_sedap]

how to use that rows (int32) = DT.Rows.Count?

[kuih_sedap]

it just replacing in same cell,not increment please

[kuih_sedap]

[samir (Samir Mohite)]

@kuih_sedap,

@kuih_sedap

it just replacing in same cell,not increment please

If there’s header then you have to increment it by 2
“A”+(rows+2).ToString

[kuih_sedap]

THANK YOU SO MUCH