Reading excel file sheets

1 次查看（过去 30 天）
NETHRAVATHI S
NETHRAVATHI S 2021-3-19
评论： laurent jalabert 2022-2-4
How to read sheets of an excel file and save it. also I want to access these sheets inside a for loop for further analysis and plottig.
I have done like this.
filename = 'timeframe_wodsm.xls';
VHC = xlsread(filename,1);
HC = xlsread(filename,2);
MC = xlsread(filename,3);
LC = xlsread(filename,4);
Here I am getting 4 different files for each sheets,
For further analysis, logic is the same but i have to repeat it for 4 times. How to keep it in a loop?
Also how to plot 4 graphs for each of the sheets inside the loop itself?
  1 个评论
laurent jalabert
laurent jalabert 2022-2-4
d = uigetdir(pwd, 'Select a folder');
DATA = dir(fullfile(d, '*.xlsx'));
[status,sheets] = xlsfinfo(DATA.name);
sheets = sheetnames(DATA.name);
for ii=1:length(sheets)
EachSheet{ii} = readtable(DATA.name,'Sheet',ii);
end

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2021-3-19
编辑：KSSV 2021-3-19
It is suggested to use readtable instead.
filename = 'timeframe_wodsm.xls';
data = = cell(4,1) ;
for i = 1:4
data{i} = xlsread(filename,i);
end

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by