Reading Multiple sheets to different data sets

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

[Mathieu NOE]

hello

it all depends what info you need from your sheets and what kind of data / strings / format we are talking about

readtable is nice and very versatile but slower than "focused" methods

if you could share a data file and explain in more details what you need, we might find a faster solution

tx

[Aidan Roberjot]

heres one of the data files, thanks for the help

[Aidan Roberjot]

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);

Answer 1

[Nora Khaled]

this may help

https://www.mathworks.com/matlabcentral/answers/300842-importing-data-from-excel-across-multiple-sheets-and-filenames