varunk
(Varun Kumar)
March 6, 2018, 8:57am
1
Hi @ All
I have one pie chart in excel sheet,I need to take that pie chart into powerpoint.
how can we automate this one
balupad14
(Balamurugan)
August 22, 2020, 7:46am
2
Hi @varunk ,
Here is the link to copy the excel chart to power point.
Regards
Balamurugan.S
Hello Varun,
In this video, I have multiple use cases of UiPath working with POWERPOINT via VB.NET :
1:10 Install NuGet Package for automation
4:00 Use-Case 1 Add a new slide and add a picture
8:20 Add Chart
10:35 Add a text with shadow
12:30 Perform a slideshow
15:00 Delete slide and Export to PDF
17:30 Working with comments (Add, Read, Delete)
19:50 Create a complex PowerPoint from 0
Code:
'VB.NET code that call POWER POINT
'ADD SLIDE WITH TEXT AND PICTURE
Dim oApp As Microsoft.Office.Interop.PowerPoint.Application
Dim oPres As Microsoft.Office.Interop.PowerPoint.Presentation = Nothing
Dim oSlide As Microsoft.Office.Interop.PowerPoint.Slide = Nothing
'Start Powerpoint and make its window visible but minimized.
oApp = New Microsoft.Office.Interop.PowerPoint.Application()
oApp.Visible = Microsoft.Office.Core.MsoTriState.msoTrue
oPres = oApp.Presentations.Open("C:\R\power.pptx",,,)
oApp.WindowState = Microsoft.Office.Interop.PowerPoint.PpWindowState.ppWindowMaximized
'Add Slide with text
oSlide = oPres.Slides.Add(1, Microsoft.Office.Interop.PowerPoint.PpSlideLayout.ppLayoutTitle)
With oSlide.Shapes.Item(1).TextFrame.TextRange
.Text = "My Sample Presentation"
.Font.Name = "Comic Sans MS"
.Font.Size = 48
This file has been truncated. show original
Thanks,
Cristian Negulescu