Reading Multiple sheets to different data sets

8 ビュー (過去 30 日間)
Aidan Roberjot
Aidan Roberjot 2020 年 11 月 23 日
回答済み: 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 件のコメント
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 日
this may help
https://www.mathworks.com/matlabcentral/answers/300842-importing-data-from-excel-across-multiple-sheets-and-filenames

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

製品


リリース

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by