Unable to replace multiple data fromexcel to power point

Help Activities
, , ,
1

Can someone help me in building a project where I have to extract data from excel and place it in ppt

Forum Engagement Daily Reports
2

@Manav_Ghadi1

Welcome to the community

Did you try with this

You can create a tempalte and use that to replace the data from excel

Cheers

4

hey anil thanks for helping. I had tried but its not working. Can we connect?

5

@Manav_Ghadi1

Can you please tell what is not working

Cheers

6

So the replace text in presentation activity only helps in replacing one data at a time

7

@Manav_Ghadi1

yes you need to loop through the values in excel and then for each value repalce each palceholder

cheers

8

can you guide me like how to do

9

@Manav_Ghadi1

in excel have the placeholder in one column and value in another

use for each row in excel or datatable

inside that use replace text with palce holder as currentrow("Placeholdercolumn").ToString and value as currentrow("Valuecolumn").ToString

cheers

cheers

1 Like
10

Hi @Manav_Ghadi1

Steps:
Read Excel Data

Use Excel Application Scope → Read Range

Output → DataTable

Create/Open PowerPoint

Use Presentation Application Scope

Create new or use template .pptx

Add Slides

Use Add Slide activity for each row or section of data.

Insert Data into Slides

Use Add Text to Slide or Set Title/Content activity.

Loop through DataTable and insert values.

Save and Close

Use Save Presentation and close the app.

Required Packages:
UiPath.Excel.Activities

UiPath.Presentations.Activities

Happy Automating!
AJ