I have an Excel sheet with the following columns
- Product ID
- Product Name
Images are placed on the worksheet but not in any cell. I want to extract the images as files (jpg, png, gif, etc) and I also want them to be named according to values in the "Product Name" column.
So the 1st image will be named according to the 1st value in "Product Name" Column, the second according to the second etc.
As a workaround, I'm able solve the extracting part by saving the Excel sheet as a HTML document, which also saves the images I want. However I'm unable to control the image names: Excel sets a pre-defined name, like image1.jpg, image2.jpg etc.
So, what I want is
if the "product name" column has the following values ;
I should have images with the name