Reading Multiple sheets to different data sets

2 次查看(过去 30 天)
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 个评论
Aidan Roberjot
Aidan Roberjot 2020-11-23
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);

请先登录,再进行评论。

回答(1 个)

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

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by