Reading Multiple sheets to different data sets

10 views (last 30 days)
I was wondering if there was a faster or more concise way to import my data that what I currently have which is to use the readtable command to import each sheet as its own variable, and I cant use xlsread as that isnt importing the string values
  3 Comments
Aidan Roberjot
Aidan Roberjot on 23 Nov 2020
so currently my code looks like this for 20 lines, and i just cant imagine its the best way to go about it
data2019=readtable('2019_domestic_travel_data.xlsx','PreserveVariableNames',1);
data2018=readtable('2018_domestic_travel_data.xlsx','PreserveVariableNames',1);
data2017=readtable('2017_domestic_travel_data.xlsx','PreserveVariableNames',1);

Sign in to comment.

Answers (1)

Nora Khaled
Nora Khaled on 23 Nov 2020
this may help
https://www.mathworks.com/matlabcentral/answers/300842-importing-data-from-excel-across-multiple-sheets-and-filenames

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!