Reading Multiple sheets to different data sets

4 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
Edited: Aidan Roberjot on 23 Nov 2020
heres one of the data files, thanks for the help
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!