How to do Increment value in excel

Help
1

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

1 Like
2

@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

3

can i use the counter variable without loop operation?

5

Screenshot (1)
Screenshot (1)1366×768 80.4 KB

8

@kuih_sedap

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

9

Hi @kuih_sedap,

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. :slight_smile:

1 Like
10

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

11

it just replacing in same cell,not increment please

14

Screenshot (3)
Screenshot (3)1366×768 81.9 KB

15

@kuih_sedap,

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

3 Likes
16

THANK YOU SO MUCH

17

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