All Forums  Origin Forum for Programming  Forum for Python  how to udate OLE object in powerpoit

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by nk.S[/i] [br]Origin Ver. and Service Release (Select Help-->About Origin): origin 2023 Operating System: window10 hi!! please, i need your help!!~~ I'm trying to automate updating ole objects inserted in powerpoint using python. To roughly explain the process, 1. Open the origin OLE object (1 graph, 1 worksheet, name unknown) inserted into PowerPoint using a win32 module 2. insert the data preprocessed in Python into the worksheet of the ole object. 3. I don't want to change the current graph settings (no rescale), update only the changed data to the graph, save it, and close it. code is as below, but it's not working, is there a good solution? --Omit previous code # Object name in ppt shape.name = test # Object execution ole_object = shape.name.OLEFormat.DoVerb() # Find the worksheet for the executed object sheet = op.find_sheet() # Activate worksheet sheet.activate() # insert data sheet.from_df(data) # ole_object.Save() op.utils.exit() # presentation save and quit presentation.save() presentation.close() sng [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.