Global Data Science Forum

 View Only
  • 1.  automate powerpoint files

    Posted Wed July 27, 2022 02:11 PM
    Hello team, 

    I appreciate your support with a question,
    Do you have any recommendations or tools to automate the following process?

    Stept 1: Download excel files with rawdata
    Step 2: In the excel files information must be extracted, they are fields defined in a table and some simple mathematical operations, such as averages and sums
    Step 3: In a powerpoint template, insert the information selected in step 2, it is only copy and paste the value

    The idea of automating is because there are several files to generate
    Thank you for your advice and comments.

    Emmanuel Gonzalez Sanchez

  • 2.  RE: automate powerpoint files

    Posted Fri July 29, 2022 09:33 AM
    Using Python openpyxl module we can conveniently extract the Excel expressions and resultant data from Excel worksheets. 
    We can also manipulate the contents of the worksheets.

    PG Bhat