How to add diiferent sheet data and store it in the cell

[anjani_priya]

there are 10 sheets.In each sheet, the same column data should be sum and should store in the cell.Likewise for 10 sheets, the data should stored vertically in 10 cells how to do that?

[Shiva_Nikhil]

@anjani_priya

use get worksheets

use for each for the sheet inside

use read range activity

after that
use assign activity

dt1.AsEnumerable.Sum(Function(x) CInt(x("ColumnName").ToString))

use write cell activity to write in the particular cell

for increment the cell create output for for each activity and pass that in the writecell activity