Rename file with data from Excel

Post Reply
BartDenolf
Member
Posts: 31
Joined: Thu Aug 04, 2016 4:06 pm

Rename file with data from Excel

Post by BartDenolf »

Hello,

Is their a way with Switch to search within an excel for the name of a file and then rename the file with the data from the column next to the found cell?

Greetings
Bart
User avatar
gabrielp
Advanced member
Posts: 645
Joined: Fri Aug 08, 2014 4:31 pm
Location: Boston
Contact:

Re: Rename file with data from Excel

Post by gabrielp »

If it's a CSV, you can use https://appstore.enfocus.com/product/csvlookup

Otherwise, I'd imagine you'd need a script to parse xls,xlsx files which can be rather difficult.
Free Switch scripts: open-automation @ GitHub
Free Switch apps: open-automation @ Enfocus appstore

Want to hire me? I'm looking for my next gig. Contact me on LinkedIn or via email.
Post Reply