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