Read multiple excel files
34 ビュー (過去 30 日間)
古いコメントを表示
I am exporting multiple excel files and converting them to arrays. However, it can be time consuming to manually write the following code. So, I was thinking of using a for loop or some other technique that I don't have write repetitive code. How can I accomplish that? I really appreciate your help.
abc_table = readtable("Data\Some_Data.xlsx", 'Sheet', "abc");
def_table = readtable("Data\Some_Data.xlsx", 'Sheet', "def");
ghi_table = readtable("Data\Some_Data.xlsx", 'Sheet', "ghi");
jkl_table = readtable("Data\Some_Data.xlsx", 'Sheet', "jkl");
abc_vec = table2array(abc_table);
def_vec = table2array(def_table);
ghi_vec = table2array(ghi_table);
jkl_vec = table2array(jkl_table);
0 件のコメント
採用された回答
KSSV
2022 年 8 月 2 日
xlFiles = dir('*.xlsx') ;
N = length(xlFiles) ;
for i = 1:N
thisFile = xlFiles(i).name ;
T = readtable(thisFile) ;
% do what you want
end
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!