I am trying to get a full picture to upload onto a worksheet from its url. I have created a form where there is a file upload and I would like for it to show the image rather than a url. Is there a way to do this using office scripts?
Thank you!
Asked
Active
Viewed 1,396 times
1 Answers
1
This sample shows how to add an image to a workbook from a URL: Add images to a workbook.
Essentially, you need to use fetch to get the image information, convert it to a base64-encoded string, then use Worksheet.addImage to create an Excel shape storing the image.
Since you're using a form, you could create a Power Automate flow that runs the script whenever a new response is recorded. That might be out of scope from your original question, but it's something to consider as a next step.
Alexander Jerabek
- 358
- 1
- 3
- 10
-
Do you know if this script only works with png file types or if you can use .jpg – spec Jul 12 '21 at 11:51
-
The `addImage` API works with .jpg files too. – Alexander Jerabek Jul 12 '21 at 21:17