How to read and save multiple excel sheets in Matlab?

Moe
8 Jun 2015
1 Answer
Updated 8 Jun 2015
4 Views (30 days)

0 votes

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.

1 Comment
Show -1 older comments Hide -1 older comments

Moe
Moe on 8 Jun 2015
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?

Sign in to comment.

Sign in to answer this question.

Answers (1)

dpb
dpb on 8 Jun 2015

1 vote

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

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Asked:

Moe
Moe
on 8 Jun 2015

Answered:

dpb
dpb
on 8 Jun 2015

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!