MATLAB Answers

How to read multiple excel files with different names

68 views (last 30 days)
Michela Gasperini
Michela Gasperini on 19 Dec 2018
Answered: xi on 19 Dec 2018
Hi everyone, I have 41 excel files that I have to import to MATLAB. From these files I need to get the value of a specific cell (for every file the cell number and letter are the same). I would like to create an arrow containing the all the values from each of the file. Any idea how I can do it?
Thank you!!

Answers (1)

xi
xi on 19 Dec 2018
you can use this commend to select multiple files from the same folder..
[files,path]=uigetfile('*.xlsx','multiselect','on')
and then use xlsread to access data in each file. and do whatever you want. see xlsread
for i=1:41
[~, ~, data{i}]=xlsread(fullfile(path,files{i}))
end

  0 Comments

Sign in to comment.


Translated by