PPT: Read and Write Specific Details in PPT

Help Activities
, ,
1

PPT: Read and Write Specific Details in PPT

I have a PowerPoint presentation and need to read it to retain only specific values based on a ‘YES’ or ‘NO’ variable (From another Excel sheet.)

Requitements : If Contain 1 has ‘Yes,’ then keep Header 1 and Contain 1, and delete the rest. Similarly, if Contain 3 has a ‘Yes’ value, then keep Header 3 and Contain 3. If Contain 5 has a ‘Yes’ value, then keep Header 4 and Contain 5. All other items should be deleted from the PPT. The Contain value could be ‘Yes’ or ‘No’; depending on that, keep only specific Contain and Header, and delete the rest.

Sample file :
PPT :
Header 1

• Contain 1

• Contain 2
Header 2
Header 3

• Contain 3

• Contain 4
Header 4

• Contain 5

• Contain 6

• Contain 7

• Contain 8

• Contain 9

• Contain 10

• Contain 11

•Contain 12

Here i have attched PPT

New Microsoft PowerPoint Presentation.zip (36.6 KB)

How can I do that?"

Thanks
Andy

2

Hi @Andy5

You can consider below approach:

  1. use read pdf text or read pdf with ocr activity to read pdf and save in an output variable

  2. use regex to check if contain 1 has yes, then remove rest of the data. Here in have multiple if else to check various conditions per your requirement

  3. use append text activity in word application scope to write the resulting data from step 2

  4. use export to pdf activity which will give you final pdf.

Hope this helps.