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

1 次查看（过去 30 天）
Joh adam
Joh adam 2021-5-31
评论： Kunal Kandhari 2021-6-1
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:
Sheet 2
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:
Combined excel document
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

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by