MATLAB Answers

How to read multiple excel files with different names

91 ビュー (過去 30 日間)
Michela Gasperini
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!!

回答 (1 件)

xi
xi 2018 年 12 月 19 日
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.

サインイン してこの質問に回答します。

製品


リリース

R2018a

Translated by