Working with structs & excel spreadsheets

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.

Answer 1

[Orion]

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});

Answer 2

[Guillaume]

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));

[Jo]

Hi Guillaume. Thanks for your answer. I tried this command but I got %In an assignment A(I) = B, the number of elements in B and I must be the same. I'm a bit confused!

[Guillaume]

Yes, sorry I just copied your code without thinking. Use a cell array for results:

results{sheet} = t.data.(sprintf('S%d', sheet));

[Jo]

great!thank you very much for your help.