Rename file with data from Excel

Post Reply
BartDenolf
Newbie
Posts: 7
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: 577
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.
Chat: open-automation @ gitter
Code: open-automation & dominickp @ GitHub
Tools: Switch, Pitstop, EPMS, Veracore, PageDNA, SmartStream, Metrix
Post Reply