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
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
can i use the counter variable without loop operation?
Here you need to do perform set of activities repeatedly right. So you need to use loop operation only.
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. 
1 Like
how to use that rows (int32) = DT.Rows.Count?
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
3 Likes
THANK YOU SO MUCH
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.