Movefile with variable file names

10 vues (au cours des 30 derniers jours)
gosox2017
gosox2017 le 20 Mar 2017
Commenté : gosox2017 le 20 Mar 2017
After an excel file is pulled from a webpage it saves to my downloads. I want to pull this file into a different folder and then run readtable(). My issue is the file has a date in it so the file name changes every day. Is there a way to use a variable filename in a path in a movefile call? ie. d = datetime('today','format','MM-dd-yyyy'); fileName = strcat('Stock List(',char(d),').xls'); movefile user\blah\downloads/(fileName) users\blah\destination
If this doesn't work how can I use readtable with a path to the file. xlsread() messes with the tables formatting. Thanks!

Réponse acceptée

Adam
Adam le 20 Mar 2017
Modifié(e) : Adam le 20 Mar 2017
Use the function syntax of movefile to use a variable...
movefile( source, destination );
  1 commentaire
gosox2017
gosox2017 le 20 Mar 2017
Awesome, thanks Adam! That works great!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Files and Folders dans Help Center et File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by