Suma de celdas en excel

[yedukondaluaregala]

@mively

1. Use read range activity, (dtInput) add header should be check
   if already you having this data table no need to read it again

2. take one assign activity to calculate the sum
   in To section: Create one integer variable intSumVar
   In Value : dtInput.AsEnumerable().Where(Function(x) Not String.IsNullOrWhiteSpace(x(“yourColumnName”).ToString)).Sum(Function(y) CInt(y(“yourColumnName”).ToString))

3. then use write cell workbook activity, in value pass intSumVar.Tostring and in range section pass “G”+(dtInput.Rowcount()+2).Tostring

Make a note these opeations will work when excel is closed if you already performing excel activities you can similar activies insdie of excel application scope.

If you found solution please mark my post as solution.

Thanks,
Happy Automation!!