multiple excel file with different but know sequence names reading in one folder

I need to read multiple excel files with different names but know sequence. the name contain both number and letters. the letters do not change but the number do. For example H100h0Q2_1,H100h0Q2_2,H150h0Q2_1,H100h0Q2.5_1 are few. in addition, in each excel file I have three sheets which their name could vary. How can read each file and form a big matrix of the data I have. thank you.

Answer 1

[Image Analyst]

See the FAQ: http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Chances are you can use either dir() or sprintf().

To get the sheet names, use xlsinfo():

[status,sheets] = xlsfinfo(filename) % Returns the name of each spreadsheet in the file.