Importing data from excel sheet

2012 9 18
1 个回答
回答已采纳
6 次查看（30 天）

0 个投票

I want to import all the data from excel worksheets.
I tried using following command, >> Ans = xlsread(FILEPATH);
After executing this line, the data only from first sheet is getting uploaded.
Is there any other way to upload entire data using single command?

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

 采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2012-9-18
编辑：Azzi Abdelmalek 2012-9-18

0 个投票

sheet={'sheet1','sheet2'}, %specify your sheets
out=cellfun(@(x) xlsread('book1.xlsx',x),sheet,'uni',false)
if you want one line command (for 4 sheets)
out=cellfun(@(x) xlsread('book1.xlsx',x),cellfun(@(y) ...
sprintf('sheet%d',y),num2cell(1:4),'uni',false),'uni',false)

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by