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:
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 件)

カテゴリ

Help Center および File ExchangeData Import from MATLAB についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by