Importing data from excel sheet

Question

Abhijit Bahirat 2012-9-18

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?

Answer 1

Azzi Abdelmalek 2012-9-18

编辑：Azzi Abdelmalek 2012-9-18

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)

Abhijit Bahirat 2012-9-20

Thank you Mr.Azzi!

I shall reply back for further queries.