I 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.
Please help me with the directions. Thanks a lot in advance.