multiple excel file with different but know sequence names reading in one folder
1 view (last 30 days)
Show older comments
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.
0 Comments
Answers (1)
Image Analyst
on 19 Mar 2015
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.
0 Comments
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!