Formating PPT after Every Week

Help Studio
, ,
1

Hi,
I have an Excel Sheet that contains around 150 quotations.
Out of 150 quotations I need to update any one quote every week in a PPT.
How can we do that??
Thanks in advance!!

2

Hi @Kunal_Jain

You will require UiPath.Presentations.Activities for this. Which you can download from manage packages

Read Your Excel With Quotes By Using Read Range

image
image795×630 25.4 KB

Create these 2 variable of Int32 type One for Total Row Count Of Quotes in excel & Other for Random Row No
image
image854×211 10.8 KB

Use PowerPoint Presentation Activity With Your PP file Path & Add Text To Slide for adding the quote to that particular slide.
image
image671×632 23.7 KB

3

Hi @AJ_Ask,
Can you share the zip file of the code if possible.
Thanks in advance!!

4

Hi @Kunal_Jain Hope this Helps :slight_smile:
Also Use 1.11.2 Version of Presentations.Activities
image

PowerPoint_Automation.zip (82.1 KB)

5

Hi @AJ_Ask
How to change it for every week?
Thanks in advance!!

6

Hi @Kunal_Jain
Publish this process in orchestrator. Then setup a time trigger for running where you can select the weekly trigger. If this helped you can accept this as solution!

image
image1583×536 55.7 KB

7

Hi @AJ_Ask
I need to run this code with other process that runs daily.
So I need a condition to check which can run?
Thanks!!

8

Hi @Kunal_Jain

There are multiple ways to do this but easiest is you can set the job execution priority. In your case set it to Low so even if any other process is working this bot will go into wait till your main bot execution is complete then your PPT bot will execute.

https://docs.uipath.com/orchestrator/standalone/2023.10/user-guide/about-jobs#execution-priority

image
image797×315 13.6 KB

These are four main job priorities in UiPath Orchestrator:

  1. Low: Jobs with low priority will be executed after all normal, high, and urgent priority jobs are completed. These are typically for non-time-sensitive tasks or background processes.
  2. Normal: Jobs with normal priority are executed in the standard order they are received after any urgent priority jobs are processed. It’s the default priority setting for jobs.
  3. High: High priority jobs are given precedence over normal and low priority jobs. They are executed before normal and low priority jobs, making them suitable for time-sensitive or critical tasks.
  4. Urgent: Jobs with urgent priority are executed immediately. They take precedence over all other jobs in the queue, ensuring immediate execution. These jobs are reserved for critical tasks that require immediate attention.

If this helped you can accept this as solution! :slight_smile:

9

Thanks @AJ_Ask for the solution
It worked.

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.