Get the Counts of the data row and for(COUNT COLUMN) FULLY Filled by the value "0"

Help Studio
,
1

INPUT FILE

image
image425×619 6.12 KB

need a output like this

image
image387×652 14.3 KB

2

@krishnapriya_Anu

Please use write cell with cell as C2" and value as "0"

Then use auto fill range activity which will fill the data till end of data

Or else read the data into datatable using read range …then use assign with
dt.Columns("Count").Expression = "'0'"

Then use write range and write the data back to excel

Cheers