Import/convert an Excel file with more worksheets into a structure with more fields, one field for each worksheet

Hi All,

I would like to import/convert an excel file which has n worksheets, into a structure with n fields, like S.f1, S.f2, ..., S.fn, one field for each worksheet of the Excel file, in MATLAB.

Is there anyone who could help me?

Thanks,

Mike

[Stephen23]

"into a structure with n fields, like S.f1, S.f2, ..., S.fn"

This would be better a non-scalar structure, with one field (or indeed, simply a cell array).

https://www.mathworks.com/help/matlab/matlab_prog/access-multiple-elements-of-a-nonscalar-struct-array.html

Answer 1

[Bob Thompson]

Generally, importing multiple excel sheets is done by calling the xlsread command multiple times. One of the flags of the command is for designating which sheet you are using. The command does not import the information into a structure array, but you can reorganize the information from the imported matrix into a structure array easily enough.

for i = 1:nsheets
    [~ ~ data] = xlsread('myexcelfile.xlsx',i);
    [mystruct.data1] = data{range1};
    [mystruct.data2] = data{range2};
    [mystruct.data3] = data{range3};
    [mystruct.data4] = data{range4};
end

Obviously you need to make your own ranges and structure fields, but the basic concept is sound.

[Mike]

Thank you very much, Bob!

[Guillaume]

Numbered variables (or fields) are a very bad idea. Indexed variables or fields are so much easier to use. e.g. the above becomes:

excelfile = 'C:\somewhere\someexcelfile.xlsx';
[~ sheets] = xlsfinfo(excelfile)
for i = 1:numel(sheets)
    [~, ~, mystruct.data(i)] = xlsread(excelfile, i);
end

[Bob Thompson]

I didn't know you could import directly into a structure like that, but I suppose it makes sense because mystruct.data will just be a large cell array.

[Guillaume]

Well, actually, I made a mistake and indeed should have made data a cell array

for i = 1:numel(sheets)
    [~, ~, mystruct.data{i}] = xlsread(excelfile, i);  %correct syntax!
end

edit: or another option is to make data a matrix and make the structure an array by indexing the structure rather than the field:

for i = 1:numel(sheets)
    [~, ~, mystruct(i).data] = xlsread(excelfile, i);
end

[Mike]

Thank you very much Guillame! I really appreciate your help.

Best regards,

Mike