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

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

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

도움말 센터File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

질문:

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