清空筛选条件
清空筛选条件

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

1 次查看（过去 30 天）
Ferej
Ferej 2015-3-18
回答： Image Analyst 2015-3-19
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.

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

回答（1 个）

Image Analyst
Image Analyst 2015-3-19
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by