How to read and save multiple excel sheets in Matlab?

3 visualizzazioni (ultimi 30 giorni)
Moe
Moe il 8 Giu 2015
Risposto: dpb il 8 Giu 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 Commento
Moe
Moe il 8 Giu 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?

Accedi per commentare.

Accedi per rispondere a questa domanda.

Risposte (1)

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

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by