Working with structs & excel spreadsheets

Question

Jo 2014-11-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/162058-working-with-structs-excel-spreadsheets

评论： Jo 2014-11-10

Hi.

I have a big excel spreadsheet with multiple sheets (n=39) and I want to import it to matlab and do some calculations. I have used the command %importdata and I have all the data in a struct. I have already built a script in order to access the data of the first sheet (%t.data.S1(:,:)) and do some calculations. I need to do the same for the rest sheets (S2..S39) using a for loop. I tried this [type, sheetname] = xlsfinfo('.xlsx');

i = length(sheetname);

for sheet = 1:i

results (sheet)= t.data.S(sheet);

Z(sheet).results= results(sheet)

end

but doesn't work!

Any ideas?Many thanks in advance.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Orion 2014-11-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/162058-working-with-structs-excel-spreadsheets#answer_158369

编辑：Orion 2014-11-10

在 MATLAB Online 中打开

You need to call xlsread at each iteration in order to read a new sheets.

XlsFile = 'YourXlsFile.xlsx';
% get the name of all your spreadsheets
[type, sheetname] = xlsfinfo(XlsFile);
% loop for each sheet
for i = 1:length(sheetname)
    MyData{i} = xlsread(XlsFile,sheetname{i});
end