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! 👍
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.
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
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”
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
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.
@@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.
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.
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.
