Reading Multiple sheets to different data sets

8 次查看（过去 30 天）

Aidan Roberjot 2020-11-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/659053-reading-multiple-sheets-to-different-data-sets

回答： Nora Khaled 2020-11-23

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 个评论
显示 1更早的评论隐藏 1更早的评论

Aidan Roberjot 2020-11-23

编辑：Aidan Roberjot 2020-11-23

2020_domestic_travel_data.xlsx

heres one of the data files, thanks for the help

Aidan Roberjot 2020-11-23

在 MATLAB Online 中打开

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