Usage of Excel.ChartObjects and Chart

Help Studio
1

Hi all,

I need to use excel.objects and chart library via vb.net in invoke code. How can i use these libraries??

Thanks.

2

Can you please walk through the below mentioned link:

VBA Code to Create & Format Charts in Excel - YouTube

1 Like
3

HI @yigit.aybey

Checkout these links

Regards
Sudharsan

1 Like
4

Hi @Sudharsan_Ka @sivaprasad.as thanks for response. These are ok but he did in macro via excel. In uipath invoke editor is very different than these syntax. It can be a tough converting to uipath vb editor. By the way, Iā€™m new in vb.net. soā€¦
My question is that, how can we download these charts as a ā€˜pngā€™ weā€™ve already created or from existing excel file ??

Thanks.

5

Have you tried with get excel chart activity?

https://docs.uipath.com/activities/docs/copy-chart-to-clipboard-x

Regards
Sudharsan

6
1 Like
7

Sadly, I canā€™t use the activities and 3rd part apps.
I have to use invoke code and itā€™s obligation :frowning:
- I need to copy or take screenshots or download the chart/s or else. Using vb.net :frowning: itā€™s hard but i have to.
I could not find any code or smt close for uipath vb editor. There are some codes or sitesā€™ve already done that(vb.net) but i could not convert to the uipath editor, unfortunetelly syntax state.
so,
How can i do that?

Thanks.

8

Regards
Sudharsan