MATLAB: Importing different sheets of an Excel Data

importing excel data

Hello. I am trying to import different sheets of an Excel file in my MATLAB code. I need for example use sheet 1, do some calculation, do same calculation on sheet 2 and so on. Then, get an average from my calculations on sheet1 ,2… Also, Should I know how many sheets do I have? I am asking because I need to generalize it. Thanks

Best Answer

You can retrieve the name of the sheets in an excel file with xlsfinfo

Related Solutions

MATLAB: Importing data from excel sheet

sheet={'sheet1','sheet2'}, %specify your sheets
out=cellfun(@(x) xlsread('book1.xlsx',x),sheet,'uni',false)

if you want one line command (for 4 sheets)

out=cellfun(@(x) xlsread('book1.xlsx',x),cellfun(@(y) ...
sprintf('sheet%d',y),num2cell(1:4),'uni',false),'uni',false)

MATLAB: Importing text from Excel sheets

Here's an example on how to use fprintf with cells:

C{1} = sprintf('Hello\n');
c = {'A','B','C';1,2,3};
C{2} = sprintf('%s\t%d\n',c{:});
s = char(C)
fprintf('%s',C{:})

Best Answer

Related Solutions

MATLAB: Importing data from excel sheet

MATLAB: Importing text from Excel sheets

Related Question