MATLAB Answers

0

How to read multiple excel files with different names

Michela Gasperini さんによって質問されました 2018 年 12 月 19 日
最新アクティビティ xi
さんによって 回答されました 2018 年 12 月 19 日
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!!

製品


リリース

R2018a

1 件の回答

xi
Answer by 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 件のコメント

サインイン to comment.



Translated by