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! 👍
@ExcelOffTheGrid Жыл бұрын
Glad it helped!
@user-qe5st3wz2f5 ай бұрын
THANK YOU SO MUCH, you make quite a long complicated seemingly impossible task as easy as sending an email, brilliant and perfect thank you
@sidneycomandulli9460 Жыл бұрын
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.
@aritramech Жыл бұрын
It’s and excellent tutorial. Script is working perfectly
@ExcelOffTheGrid Жыл бұрын
Great news 😁
@RicardoJimenezCR Жыл бұрын
Great video. Thank you Mark.
@ExcelOffTheGrid Жыл бұрын
Glad you enjoyed it. Thanks Ricardo.
@Jobin.Thomas Жыл бұрын
Hello Mark, Could you please share some resources/ YT channels/ books to learn power automate?
@snorrefjeldbo5604 Жыл бұрын
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?
@ExcelOffTheGrid Жыл бұрын
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.
@snorrefjeldbo5604 Жыл бұрын
@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.
@goldentriangle5209 Жыл бұрын
You are brilliant, thank you very much.
@ExcelOffTheGrid Жыл бұрын
You're welcome!
@ExcelOffTheGrid Жыл бұрын
That's very kind of you to say. 😁
@NishanthKumar-rj4lq Жыл бұрын
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
@ExcelOffTheGrid Жыл бұрын
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.
@vasukollur Жыл бұрын
Thanks for rhe video. However the images created are little blur. Any suggession to improve the image clarity would be great.
@ExcelOffTheGrid Жыл бұрын
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.
@anthonyatchley Жыл бұрын
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”
@anthonyatchley Жыл бұрын
Figured it out. Easier than expected 😂🤣
@ExcelOffTheGrid Жыл бұрын
Good stuff - they are my favourite questions… the ones that people answer themselves. 😀
@hungdinhvan70919 ай бұрын
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
@neilseiffer9 ай бұрын
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?
@ExcelOffTheGrid9 ай бұрын
Yes that would be possible. Using the techniques in this video.
@alexl9610 Жыл бұрын
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 Жыл бұрын
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.
@alexl9610 Жыл бұрын
@@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
@ResponsibleXI11 ай бұрын
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?
@ExcelOffTheGrid11 ай бұрын
My guess is that just referencing E5 should work. Why not just try it and see which works.
@ResponsibleXI11 ай бұрын
@@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.
@ExcelOffTheGrid11 ай бұрын
@@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.
@ResponsibleXI11 ай бұрын
@@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.
@Ubeees Жыл бұрын
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?