How to set colour font boldness and add grandtotal value in last row

Help Automation Ops
,
1

How to set colour ,font, boldness and add grand total value in last row of particular column by using modern activities.

2

Hi @anjani_priya

Please use the below activity and it works!!

image
image1063×566 20.3 KB

Regards

3

I have to do that for only last row without declaring the index,dynamically.

4

Hi @anjani_priya ,

You can use"Find First/Last Data Row" activity to get last row index , as below

image
image833×718 33.2 KB

Hope it helps you!!

Regards,
Vinit Mhatre

5

Capture35
Capture351265×230 6.11 KB

I have tried with the above code but its capturing 78th index row but not 80th

6

Hi @anjani_priya ,

If it is fixed, like every time last row comes after blank row, in this example you are getting 78th as final row, then you can add 2 into it to make 80

image
image948×262 14.2 KB

Regards,
Vinit Mhatre

7

thankyou and I have to add value as grand total at the last row in the first column by using modern activities

8

Hi @anjani_priya

You can use the invoke code acticity and it works!!

ApplyColor.txt (989 Bytes)
Main.xaml (18.9 KB)

Regards

9

Hi @anjani_priya ,

If you want to write into a particular cell then you can do as below,

image

Regards,
Vinit Mhatre

10

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