MATLAB Answers

How to read and save multiple excel sheets in Matlab?

7 ビュー (過去 30 日間)
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 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 2015 年 6 月 8 日
doc xlsread
Use the optional SHEET name to read more than the default first sheet.

Community Treasure Hunt

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

Start Hunting!

Translated by