How can I gather data from multiple Excel data in one Excel file using matlab script

I have not used matlab scripting before, my issue is that I have multiples Excel files with two sheets each like shown in the picture: Sheet 1
and the other sheet content is something like:
I have already the excel files saved, but how to write a (.m) script to fetch all information in multiple excel files in an only one excel file like this:
My thought was something like this, but not really sure how to proceed!
for iStudent = 1:numel(Students) % indices
Student= Students{iStudent};
if (iStudent == numel(Students))
for iStudent = 1:numel(Students) % indices
Student= Students{iStudent};
%% Define file name
resultsFilePath = strcat([FolderPath, 'Results ', 'All Students', ' ', '.xls']);
end
end

1 件のコメント

Kunal Kandhari
Kunal Kandhari 2021 年 6 月 1 日
You you please explain the combined excel document?
I coundn't see any combined table1 and table2 in that

サインインしてコメントする。

回答 (0 件)

質問済み:

2021 年 5 月 31 日

コメント済み:

2021 年 6 月 1 日

Community Treasure Hunt

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

Start Hunting!

Translated by