Compare image files to Excel file

Get help. Get answers. Let others lend you a hand.

Moderator: Mr_Noodle

Compare image files to Excel file Thu Oct 25, 2018 4:58 am • by Anita
I have an excel file containing sku numbers, eg 9999. I have a folder with pack shots, file names are "9999 model color.jpg" or "model color 9999.jpg" (and many many variations). Only common thing they have is that they all contain one or more sku numbers. The pack shots are devided into subfolders of their models.

I want to tag the pack shots (eg "2019 Brand") if the file name contains a sku number from Excel file.

Is there a way to to this?
Anita
 
Posts: 2
Joined: Thu Oct 25, 2018 4:18 am

Re: Compare image files to Excel file Thu Oct 25, 2018 11:00 am • by Mr_Noodle
You'll need a script to read the Excel file as there's no built-in support to do that. I'm not sure of any commandline programs that can read Excel so you may need to search around a bit.
Mr_Noodle
Site Admin
 
Posts: 11240
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Re: Compare image files to Excel file Fri Oct 26, 2018 4:32 am • by Anita
I will keep digging :)
Anita
 
Posts: 2
Joined: Thu Oct 25, 2018 4:18 am


Return to Support