Honestly, a great tutorial! I got stuck in one of my projects and now I have completed my project by following your tutorial. Thanks a lot for sharing your knowledge! 👍
Thanks for share this material ! First of all congratulations for the work. I've tested the script and came across the following situation: When a cell has text wrapping, the image option does not work in image generation. All text is on one line, cutting the text contained in the cell.
Thank you for a very good tutorial, Mark. I used it to create an image of a range in Excel. However, I use "wrap text" in one of the cells, but in the image, all the text is put on the same line. Do you have any idea how to get wrapped text in the image?
This is all down to how Excel renders the image. Therefore, I believe it is a bug. The best thing to do is use the Help -> Feedback feature to tell the Excel team about the problem.
@ExcelOffTheGrid thank you for quick response. I will contact Microsoft. My workaround for the current case was to put each line of text in separate cells, but that might not always be feasible.
Great Video. In my dashboard I have Carts and ranges. How can I paste that into email body using Power Automate. I tried your first method. That Only copies the test ranges not charts. Please help me in this
Charts and ranges are different objects. Which is why the Script can be used to get both. You'll need to do it twice - once for the range, and again for the Chart.
I think the only way to do it would be to create an oversized image initially. Then when it is resized it will look less blurry. I've not tried it, but I can't think of another way.
Thank you so much! This guide is incredibly helpful. Is there a way I can make the file name dynamic so instead of just “Save Image.png” it could show the date. So something like “Save Image 7-19-23.png”
We have an issue when run PA - Get image from Excel script "Line 7: Workbook getWorksheet: The argument is invalid or missing or has an incorrect format", could you please advise how to fix?. Thanks
If the excel reports are a regular occurrence, can we use one script for each new report? Are they stored as a file, or within the excel sheet? If within excel, then do you need to add it to each and every new report?
@@ExcelOffTheGrid can this be done with VBscript within PAD, or would that need to call a macro on a separate excel sheet? Currently have an excel with multiple columns and rows of images I need to extract and name. Exploring the best, easily maintainable option atm
@@ExcelOffTheGrid E5:E5 works. An extension to the question, how can I loop through several images under a column to download them to onedrive or SharePoint library? Is it possible with office scripts? I have vb script which os downloding to local, am looking for office script. There is hardly any related content out there.
@@ResponsibleXI you would need to include a list of all the images in a Table. Then use Power Automate to loop each row in the Table, run the script, then save the image. At least, that is how I would do it.
@@ExcelOffTheGrid Images in excel rows are not same as text in excel rows. The column with images within excel table returns blank when looped through excel rows. That's when I figured out your video, your script pickups the image with the namee we pass, the problem is all the cells of the image column have the same image name. So flow always pickups the 1st image despite looping through all rows.
It´s awesome, but I have a problem... Sometimes, when I test it, I send an e-mail with an old version of the chart (both HTML and png file). I tried do run this flow twice before sending an e-mail but is not enough (I tried to use delay between some steps as well). I just can´t guarantee that I'm sending the updated version of the chart image. Can someone help me?
Sounds like you need something which forces Excel to calculate. Then once the calculation is complete you can then get the image. Therefore it’s an issue to resolve before running these scripts.
@@ExcelOffTheGrid I added some steps in your script, updating the row table that I'm using to generate the chart (Actually, i'm updating the values with the same values). Do you think this can solve it?
@@ExcelOffTheGrid I've made some tests and I think know what is the problem, and it´s related to something I tried to solve already. The problem is: The chart was made in Excel desktop App, because I need an specific background image and this is not available in the browser version, and the script was made in the browser version, because it´s only available in this version. Besides that, the .xlsx file is in a Sharepoint site, so.... Long Story Short: I think the problem is the time necessary to sync the changes between ""workplaces"". That´s my guess because sometimes when I open the file with the desktop app it is not updated, but when I open in the browser version it´s ok. Well, it´s just a guess and I can´t be 100% sure about this. So my last chance is to insert longer delay times between some flow steps and hope for the best.
THANK YOU SO MUCH, you make quite a long complicated seemingly impossible task as easy as sending an email, brilliant and perfect thank you
Honestly, a great tutorial! I got stuck in one of my projects and now I have completed my project by following your tutorial. Thanks a lot for sharing your knowledge! 👍
Glad it helped!
It’s and excellent tutorial. Script is working perfectly
Great news 😁
Thanks for share this material !
First of all congratulations for the work. I've tested the script and came across the following situation: When a cell has text wrapping, the image option does not work in image generation. All text is on one line, cutting the text contained in the cell.
Great video. Thank you Mark.
Glad you enjoyed it. Thanks Ricardo.
You are brilliant, thank you very much.
You're welcome!
That's very kind of you to say. 😁
Thank you for a very good tutorial, Mark. I used it to create an image of a range in Excel. However, I use "wrap text" in one of the cells, but in the image, all the text is put on the same line. Do you have any idea how to get wrapped text in the image?
This is all down to how Excel renders the image. Therefore, I believe it is a bug. The best thing to do is use the Help -> Feedback feature to tell the Excel team about the problem.
@ExcelOffTheGrid thank you for quick response. I will contact Microsoft. My workaround for the current case was to put each line of text in separate cells, but that might not always be feasible.
Great Video. In my dashboard I have Carts and ranges. How can I paste that into email body using Power Automate. I tried your first method. That Only copies the test ranges not charts. Please help me in this
Charts and ranges are different objects. Which is why the Script can be used to get both.
You'll need to do it twice - once for the range, and again for the Chart.
Thanks for rhe video. However the images created are little blur. Any suggession to improve the image clarity would be great.
I think the only way to do it would be to create an oversized image initially. Then when it is resized it will look less blurry.
I've not tried it, but I can't think of another way.
Thank you so much! This guide is incredibly helpful. Is there a way I can make the file name dynamic so instead of just “Save Image.png” it could show the date. So something like “Save Image 7-19-23.png”
Figured it out. Easier than expected 😂🤣
Good stuff - they are my favourite questions… the ones that people answer themselves. 😀
Hello Mark,
Could you please share some resources/ YT channels/ books to learn power automate?
We have an issue when run PA - Get image from Excel script "Line 7: Workbook getWorksheet: The argument is invalid or missing or has an incorrect format", could you please advise how to fix?. Thanks
Is there a work flow using Excel or a CSV file that could automate individual unique images .png or .jpgs to send out in response to a received email?
Yes that would be possible. Using the techniques in this video.
If the excel reports are a regular occurrence, can we use one script for each new report?
Are they stored as a file, or within the excel sheet? If within excel, then do you need to add it to each and every new report?
Office Scripts are not saved in the workbook, they are separate files.
Therefore you can reuse any script in any workbook, you don’t need to add it.
@@ExcelOffTheGrid can this be done with VBscript within PAD, or would that need to call a macro on a separate excel sheet?
Currently have an excel with multiple columns and rows of images I need to extract and name.
Exploring the best, easily maintainable option atm
For the range example, if the picture is only on a single cell, how the range should be given? Does E5:E5 work if the picture is in E5 cell?
My guess is that just referencing E5 should work.
Why not just try it and see which works.
@@ExcelOffTheGrid E5:E5 works. An extension to the question, how can I loop through several images under a column to download them to onedrive or SharePoint library? Is it possible with office scripts? I have vb script which os downloding to local, am looking for office script. There is hardly any related content out there.
@@ResponsibleXI you would need to include a list of all the images in a Table.
Then use Power Automate to loop each row in the Table, run the script, then save the image.
At least, that is how I would do it.
@@ExcelOffTheGrid Images in excel rows are not same as text in excel rows. The column with images within excel table returns blank when looped through excel rows. That's when I figured out your video, your script pickups the image with the namee we pass, the problem is all the cells of the image column have the same image name. So flow always pickups the 1st image despite looping through all rows.
It´s awesome, but I have a problem... Sometimes, when I test it, I send an e-mail with an old version of the chart (both HTML and png file). I tried do run this flow twice before sending an e-mail but is not enough (I tried to use delay between some steps as well). I just can´t guarantee that I'm sending the updated version of the chart image. Can someone help me?
Sounds like you need something which forces Excel to calculate.
Then once the calculation is complete you can then get the image.
Therefore it’s an issue to resolve before running these scripts.
@@ExcelOffTheGrid I added some steps in your script, updating the row table that I'm using to generate the chart (Actually, i'm updating the values with the same values). Do you think this can solve it?
@@Ubeees
Testing it is the only real way to know.
@@ExcelOffTheGrid I've made some tests and I think know what is the problem, and it´s related to something I tried to solve already. The problem is: The chart was made in Excel desktop App, because I need an specific background image and this is not available in the browser version, and the script was made in the browser version, because it´s only available in this version. Besides that, the .xlsx file is in a Sharepoint site, so.... Long Story Short: I think the problem is the time necessary to sync the changes between ""workplaces"". That´s my guess because sometimes when I open the file with the desktop app it is not updated, but when I open in the browser version it´s ok. Well, it´s just a guess and I can´t be 100% sure about this. So my last chance is to insert longer delay times between some flow steps and hope for the best.