Read 'next sheet' in excel file

I have multiple excel files with many sheets of different name. (5 excel files, each has >20 worksheets)

my objective is to read cell B2 from every sheet and store them in a big matrix

its really really time consuming to write something like this f=xlsread(InputFileName1,sheet1,'B2'); f=xlsread(InputFileName1,sheet2,'B2'); f=xlsread(InputFileName1,sheet3,'B2'); f=xlsread(InputFileName1,sheet4,'B2'); etc...

every sheet is nammed differently, so in the above example, i have to rename every single sheet (again time consuming)

xlsread is a very slow command, is there a more efficient way to read all one shot? or any command to "read next sheet", so i dont have to rename the sheet name one by one in my m file?

please help, thanks:-)

Answer 1

[Image Analyst]

You need to use ActiveX. Search the Answers forum for examples, or use Brett's code: http://www.mathworks.com/matlabcentral/fileexchange/4415-readfromexcel