Resize the image in Power point using Python

Question

I am copying a Excel chart and pasting it into a PowerPoint slide.
After pasting the chart I want resize the chart which is pasted in image format.
Kindly help

import win32com.client 

# Grab the Active Instance of Excel.
ExcelApp = win32com.client.Dispatch("Excel.Application")
ExcelApp.Visible = True

# Grab the workbook with the charts.
xlWorkbook = ExcelApp.Workbooks.Open(r'C:\Users\ana\Python\Chart\NDC_wan_Oct24.xlsx')

# Create a new instance of PowerPoint and make sure it's visible.
PPTApp = win32com.client.gencache.EnsureDispatch("PowerPoint.Application")
PPTApp.Visible = True

# Add a presentation to the PowerPoint Application, returns a Presentation Object.
PPTPresentation = PPTApp.Presentations.Add()

# Loop through each Worksheet.
for xlWorksheet in xlWorkbook.Worksheets:

    # Grab the ChartObjects Collection for each sheet.
    xlCharts = xlWorksheet.ChartObjects()

    # Loop through each Chart in the ChartObjects Collection.
    for index, xlChart in enumerate(xlCharts):
        # Each chart needs to be on it's own slide, so at this point create a new slide.
        PPTSlide = PPTPresentation.Slides.Add(Index=index + 1, Layout=12)  # 12 is a blank layout
        
        # Display something to the user.
        print('Exporting Chart {} from Worksheet {}'.format(xlChart.Name, xlWorksheet.Name))

        # Copy the chart.
        xlChart.Copy()

        # Paste the Object to the Slide
        PPTSlide.Shapes.PasteSpecial(DataType=1)

    # Save the presentation.
PPTPresentation.SaveAs(r"C:\Users\ana\Python\Chart\output")

I tried the commands below but these didn't work.

PPTSlide.Shapes(1).width = 20
PPTSlide.Shapes.items(1).width = 20
PPTSlide.Shapes.width = 20

moken · Accepted Answer · 2024-10-22 23:25:31Z

1

The following should allow you to manipulate the chart image that is pasted into PP;
Note the additional import for Win32 constants

import win32com.client 
from win32com.client import constants

# Grab the Active Instance of Excel.
ExcelApp = win32com.client.Dispatch("Excel.Application")
ExcelApp.Visible = True

# Grab the workbook with the charts.
xlWorkbook = ExcelApp.Workbooks.Open(r'C:\Users\ana\Chart\Test_Oct24.xlsx')

# Create a new instance of PowerPoint and make sure it's visible.
PPTApp = win32com.client.gencache.EnsureDispatch("PowerPoint.Application")
PPTApp.Visible = True

# Add a presentation to the PowerPoint Application, returns a Presentation Object.
PPTPresentation = PPTApp.Presentations.Add()

# Loop through each Worksheet.
for xlWorksheet in xlWorkbook.Worksheets:

    # Grab the ChartObjects Collection for each sheet.
    xlCharts = xlWorksheet.ChartObjects()

    # Loop through each Chart in the ChartObjects Collection.
    for index, xlChart in enumerate(xlCharts):
        # Each chart needs to be on it's own slide, so at this point create a new slide.
        PPTSlide = PPTPresentation.Slides.Add(Index=index + 1, Layout=12)  # 12 is a blank layout
        
        # Display something to the user.
        print('Exporting Chart {} from Worksheet {}'.format(xlChart.Name, xlWorksheet.Name))

        # Copy the chart.
        xlChart.Copy()

        # Paste the Object to the Slide
        # PPTSlide.Shapes.PasteSpecial(DataType=1)

        ### Paste chart and resize either as a scaled from original or specific values
        img = PPTSlide.Shapes.PasteSpecial(constants.ppPasteShape)
        ### Scaled, e.g. make image 1.5 times the original
        # img.ScaleWidth(1.5, 0)
        # img.ScaleHeight(1.5, 0)
        ### Set Specific Size
        img.Width = 150
        img.Height = 150
        ### Also set position of the image in the slide
        img.Left = 100
        img.Top = 100

    # Save the presentation.
PPTPresentation.SaveAs(r"C:\Users\ana\Chart\output")

Image example

edited Oct 22, 2024 at 23:25

answered Oct 15, 2024 at 3:05

moken

6,92112 gold badges30 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Ana Varathan Over a year ago

Thanks for your kind support. its working good.

Ana Varathan Over a year ago

image is not changing from square shape to rectangle. Eg:img.width = 300 and img.Height = 100 not updating.

moken Over a year ago

@Ana Varathan The comment is a bit vague. You're saying not changing from square shape to rectangle and not updating. The code as shown will change the size of the image in PP. Are you stating that the code makes no change to the size of the image at all? btw the attribute is Width with an upper case 'W', but I' assume that's a typo in the comments.

moken Over a year ago

@Ana Varathan I have added an example image to the answer showing two PP slides of the same chart pasted from Excel. The Chart in Excel is roughly square with size 15 x 15. The image on the left is the chart with no resizing and remains a square and size 15 x 15, The image on the right has sizing applied per your comment, img.Width = 300 and img.Height = 100. As you can see its size has changed and the image is now roughtly rectangle.

Ana Varathan Over a year ago

put multiple image in same slide and try.

Collectives™ on Stack Overflow

Resize the image in Power point using Python

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related