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

2 vues (au cours des 30 derniers jours)
Joh adam
Joh adam le 31 Mai 2021
Commenté : Kunal Kandhari le 1 Juin 2021
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 commentaire
Kunal Kandhari
Kunal Kandhari le 1 Juin 2021
You you please explain the combined excel document?
I coundn't see any combined table1 and table2 in that

Connectez-vous pour commenter.

Réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by