How to read and save multiple excel sheets in Matlab?

2 visualizaciones (últimos 30 días)
Moe
Moe el 8 de Jun. de 2015
Respondida: dpb el 8 de Jun. de 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 comentario
Moe
Moe el 8 de Jun. de 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?

Iniciar sesión para comentar.

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

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

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by