How to compile/save the data extracted/read from multiple excel files from each iteration of loop into a single file???

1 次查看（过去 30 天）
kahhoong kok
kahhoong kok 2022-1-1
编辑： kahhoong kok 2022-1-1
Hi I am new to Matlab. I am extracting data from multiple excel files and I wish to save the data that I extracted from each excel file for each iteration without over-writting it after each iteration. Attached herewith the code that I have written:
xlFiles = dir('*.xlsx');
N = length(xlFiles);
for i = 1:N
thisFile = xlFiles(i).name;
T = readtable(thisFile,'Range','ax3:ba9', 'ReadVariableNames',false);
Tmat = table2array(T);
end
xlswrite('data.xlsx',Tmat);
Thank you and hope to receive any response from you all soon. Happy New Year.

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2022-1-1
编辑：KSSV 2022-1-1
xlFiles = dir('*.xlsx');
N = length(xlFiles);
Tmat = cell(N,1) ;
for i = 1:N
thisFile = xlFiles(i).name;
T = readtable(thisFile,'Range','ax3:ba9', 'ReadVariableNames',false);
Tmat{i} = table2array(T);
end
Tmat = cell2mat(Tmat) ; % assuming that each excel file have same dimensions of data
xlswrite('data.xlsx',Tmat);

更多回答（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!

Translated by