Reading Multiple sheets to different data sets

2020 11 23
1 个回答
更新时间：2020 11 23
3 次查看（30 天）

0 个投票

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更早的评论

Mathieu NOE
Mathieu NOE 2020-11-23
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
Aidan Roberjot 2020-11-23
编辑：Aidan Roberjot 2020-11-23
heres one of the data files, thanks for the help
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

0 个投票

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

类别

在 帮助中心 和 File 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