Share
Report
1,121I have an excel sheet downloaded from a 3rd party API which has got a image column with images in each row. The image object is named as "Picture 1" on every image under the image column. Now I would like to generate the base64 string of this image so that I can use this image in other data sources like SharePoint, SQL Server etc. I figured out how to convert it to base 64. The problem I have is I am unable to get the position of this image in each row so I can define the base64 string of this image in the same row on a new column called "base64 text". I understood getRange function is not supported for images, charts or shapes. But how do I get the position of the image now? I tried searching all over but couldn't find anything. Here are the steps I would like to do using office script.
- Get Row number of the image. Name the object with row number like "Picture 1" for row 1, "Picture 2" for row 2.
- Once I have the row number, I would like to get the shape or image at this position and get base64 text of this image under "base64 text" column.
- Use this base64 string in other data sources.
Please help me with the directions. Thanks a lot in advance.
All responses (
Answers (
