Answered

import an image to excel by script through power automate

(0) Share

Report

Posted on by Problematic

Hi All

I am trying to use the script to get an image from the SharePoint to the excel. However I only get a bunch of characters like this after running the flow

the intended design should be like this

I can get the file content of the image by using base64 function

In the excel script, what I wrote :

Interface Answer {

chop : string;

} *(This is one of the steps to get the image file from the SharePoint list after the user input the required data to pull out)

let picture = selectedSheet.addImage(answer.chop);

picture.setTop(950);

picture.setLeft(440):

Can anyone advise why I only get a bunch of characters instead of an image. How to make the correct statement to import the image

Thanks in advance.

Categories:

General topics

All responses (5)

Answers (1)

Sort by

Yutao Huang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
This flow and script worked for me:

function main(workbook: ExcelScript.Workbook, imageBase64: string) { let picture = workbook.getWorksheet("Sheet5").addImage(imageBase64); picture.setTop(30); picture.setLeft(30); }

And the result:

Do you mind sharing a bit more of your flow?
Problematic 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot. It works.

However, I have another issue. After adding the image to the excel and send this excel worksheet out by email, how can I remove the image from the excel as this excel is served as the master template. I wrote a new script for the image deletion as follows :
This is what I wrote :
how can I define the variable as the image added from previous script would be different everytime
Verified answer

Yutao Huang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
You can give the image a name (with the setName API) after adding it to the worksheet:

function main(workbook: ExcelScript.Workbook, imageBase64: string) { let picture = workbook.getWorksheet("Sheet5").addImage(imageBase64); picture.setName("image-name"); picture.setTop(30); picture.setLeft(30); }

And later in the script to delete the image:

function main(workbook: ExcelScript.Workbook) { let picture = workbook.getWorksheet("Sheet5").getShape("image-name"); picture.delete(); }

Please note that image is a special type of shape in Excel, so you'll need to use getShape() to find it.
Problematic 19 on at

Like
a
(2)

Report
Copy link

Link copied!

HI Yutao

Appreciate your support and thanks a lot.
robert111111 4 on at

Like
a
(0)

Report
Copy link

Link copied!

not working on me.. please help.. i did everything but no use