I’m trying to export data (both tables and graphs) from an Excel to Powerpoint deck.
I’ve used Excel Application Scope → Read Range → Crtl+C Hotkeys to select and copy the tables/graph from Excel (Is this the optimal way to do this? Or is there a better way?)
Also, the bit I’m really struggling on is opening PowerPoint up to copy the data into. I have the PowerPoint that I want to paste into saved on my desktop at the moment, I’ve tried using OpenApplication and StartProcess but that required an executable file? Do I need to literally find the PowerPoint.Exe that’s installed on my C:/ drive then use the open feature from that? Or can I go directly to the path?
Additionally, will shortcut keys be the best way to paste the tables/graphs into PowerPoint?
Thank you so much for sharing this.
However i found an issue relating EDP Excel and Powerpoint modules. The excel module copies pictures as “.JPEG” file by default. However the “Insert Picture” in Powerpoint module doesn’t recognize this format. It recognizes “.JPG” format but not “.JPEG”. Am i missing something here?
I faced this a long time ago, I mention this because the way I did it was through a macro, and I think even when you try to automate with UiPath you need to look for ways to get your goal done. sometimes keeping it simple is the best way.
Some will say having a macro is having to maintain two codes.
Now it is up to you to keep learning and create your own point of view.