How to read and save multiple excel sheets in Matlab?

Hi everyone,

I have an excel file with 10 sheets. Sheets names are as default from sheet1, sheet2, sheet3, ...., sheet10. How can I read multiple sheets in Matlab that give me a separate matrix with same name of sheet.

[Moe]

I'm using this code:

S = importdata('Filename.xlsx')

It's working, but I want to see all of different excel sheets in the workspace. Does anyone has any idea?

Answer 1

[dpb]

doc xlsread

Use the optional SHEET name to read more than the default first sheet.