How to read and save multiple excel sheets in Matlab?

3 Ansichten (letzte 30 Tage)
Moe
Moe am 8 Jun. 2015
Beantwortet: dpb am 8 Jun. 2015
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 Kommentar
Moe
Moe am 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?

Melden Sie sich an, um zu kommentieren.

Melden Sie sich an, um diese Frage zu beantworten.

Antworten (1)

dpb
dpb am 8 Jun. 2015
doc xlsread
Use the optional SHEET name to read more than the default first sheet.

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by