Loading multiple excel files with different names
3 views (last 30 days)
Show older comments
Ziv Kassner on 24 Jun 2014
Commented: Sara on 24 Jun 2014
I need to load multiple excel files with different names (it's important that they'll keep their names) and put a calculation that I've made into a new parameter i.e. create a vector of numbers that each one of them belongs to a different excel file.
Sara on 24 Jun 2014
Look up xlsread for reading parts of the excel file. For the loop, it depends on how the files are named. You can use ls or dir to get the list of files in one directory for instance and cycle only thru the excel ones. The specifics of the script depend on what exactly you want to do. Try those functions and if you can't get anywhere, publish your code for people to comment upon.
Dishant Arora on 24 Jun 2014
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!