How to read and save multiple excel sheets in Matlab?

8 次查看（过去 30 天）
Moe
Moe 2015-6-8
回答： dpb 2015-6-8
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 个评论
Moe
Moe 2015-6-8
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?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by