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 Comment

You you please explain the combined excel document?
I coundn't see any combined table1 and table2 in that

Sign in to comment.

Answers (0)

Categories

Asked:

on 31 May 2021

Commented:

on 1 Jun 2021

Community Treasure Hunt

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

Start Hunting!