Condition to print output value dynamically in excel

Help Studio
, ,
1

Hello everyone, is it possible to write resultant value of a particular column in sheet
dynamically.

2

can you bit explain more

3

Hey!

Yes, we can do that

take one assign activity create one integer variable

Assign Counter = 1

Use write cell activity and mention the range like this

Range: "E2:E"+(Counter+1).ToString

Assign Counter = Counter+1

This will keep on add the data to that particular column

Regards,
NaNi

4

@poojadass.murugadass

you can use the "write Cell" Activity  for writing the specific cell.
5

@poojadass.murugadass

You can also try this →
Main.xaml (7.4 KB)

6

Thanks Thiru.

1 Like
7

Thanks. let me try.

8

I have set of values in column F, i want to add those values and write in sheet.
In future, the data in column F increases dynamically where i will update the further result.

9

you can use column index instead of column name

10

Hi Thiru,

Can you clarify me why we assign two counter and where to assign below write cell else some where.

11

Hello @poojadass.murugadass Can you mention cell value that you have to update the final sum

12

@poojadass.murugadass You can use the below expression to sum all the values of an excel column

DT1.AsEnumerable.Sum(Function(x)  CDbl(x.Item("Values")))
  • Values is the column name

Ref below workflow. Let me know if need any changes

Example.zip (10.2 KB)

13

Column F Usha

14

Thank you usha.

15

Thank you Usha for your help. Now i got it what i need.

16

@poojadass.murugadass Please close the topic by choosing appropriate post as a solution. So that it would help others looking for the similar solution

17

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