how do i merge multiple excel files into a single input
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have multiple files that i would like to merge as a single input. What function do i have to use?
0 commentaires
Réponses (1)
KSSV
le 16 Jan 2018
Read about xlsread . With this you can read excel data into matlab.
files = dir('*.xls') ; % Excel file extension
N = length(files) ; % total files
iwant = cell(N,1) ;
for i = 1:N
[num,txt,raw] = xlsread(files(i).name) ;
iwant{i} = num ;
end
Now you have all the data of excel files in iwant. You can write that into a single file.
0 commentaires
Voir également
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!