Working with structs & excel spreadsheets

3 次查看（过去 30 天）
Jo
Jo 2014-11-10
评论： 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.

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

采纳的回答

Orion
Orion 2014-11-10
编辑：Orion 2014-11-10
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
just adapat this piece of code to your problem.
Instead of
MyData{i} = xlsread(XlsFile,sheet{i});
just put something like
MyData{i} = YourImportdataScript(XlsFile,sheet{i});

更多回答（1 个）

Guillaume
Guillaume 2014-11-10
You need to dynamic field names to access your sheets in the structure. You can construct the field name (which must be a string) with sprintf:
results(sheet) = t.data.(sprintf('S%d', sheet));
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2014-11-10
Yes, sorry I just copied your code without thinking. Use a cell array for results:
results{sheet} = t.data.(sprintf('S%d', sheet));
Jo
Jo 2014-11-10
great!thank you very much for your help.

请先登录，再进行评论。

类别

在 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