Clear Objects in an Excel File with Power Automate

(0) Share

Report

Posted on by KenJapan

Hi All,

Could anyone lecture me on how to clear objects(image) in an excel file with flow?

I looked for a way to run the excel script which ended up no success.

Any advise will be so much appreciated.

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

PhilipTreacy 120 on at

Like (0)

Report
Hi @KenJapan

Write a macro in the Excel file and then call it from PA.

This macro will delete all images from all worksheets - here's an example excel file with the macro in it.

Sub Delete_All_Images_In_Workbook() For Each ws In ActiveWorkbook.Worksheets For Each img In ws.Pictures img.Delete Next img Next ws End Sub

Regards

Phil

Was this reply helpful? Yes No
KenJapan 98 on at

Like (0)

Report

Thanks for the tip, but I couldn't find 'launch excel' or 'run macro' connector in the flow....

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@KenJapan - The above solution is provided for Power Automate Desktop not Power Automate Cloud, so you will not find those activities in Power Automate Cloud.

Was this reply helpful? Yes No
KenJapan 98 on at

Like (0)

Report

Understood. Any idea for the PA cloud??

Was this reply helpful? Yes No
Verified answer

PhilipTreacy 120 on at

Like (0)

Report
Hi @KenJapan

To do the same thing 'in the cloud' you can use this Office Script in your Excel file. In Excel Online, go to the Automate tab -> New Script and paste this in. Give the script a name and save it.

function main(workbook: ExcelScript.Workbook) { let sheets = workbook.getWorksheets(); for (let sheet of sheets) { sheet.getShapes().forEach((shape, index) => { if (shape.getType() === ExcelScript.ShapeType.image) { shape.delete(); } }); } }

Here's my example flow. I called the script Delete_All_Images

I've tested this code and it works.

regards

Phil

Was this reply helpful? Yes No
KenJapan 98 on at

Like (1)

Report

It worked! Thank you sooo much!
Love the community😀

Was this reply helpful? Yes No
SvenVerheyden 2 on at

Like (0)

Report

Hi,

I was searching for a way to remove objects from excel files.
Found this discussion and tried but it does not work.
Maybe it's because of a different object...
My objects see picture

Maybe anyone can help me out

Thanks a lot.

Capture.JPG

Was this reply helpful? Yes No