Reading file in subfolders with readtable

36 次查看（过去 30 天）
mehtap agirsoy
mehtap agirsoy 2021-6-29
评论： mehtap agirsoy 2021-6-29
Hi guys,
I need to run my code in the mainfolder "Rainbow" which has 5 different subfolders. Each subfolder contains .xls files and .dat files. For each loop code needs to read related .xls files and make some calculations with the .dat files. When I run the code in the Rainbow folder I got this:
Error using readtable (line 245)
Unable to find or open 'M1_Normal_T1.xls'. Check the path and filename or file permissions.
Error in Rainbow_analysis (line 17)
DAT = readtable((fname), 'VariableNamingRule', 'preserve' );
My path and filename:
fname = 'M1_Normal_T1.xls'
pname ='/Users/mehtap/Documents/MATLAB/Rainbow/M1_Normal_T1/'
When I copy the code in one of the subfolders it runs but this time doesn't read the .dat files in the other subfolders just use the ones inside it. I should run the code in the Rainbow folder but always I received error. I really got stuck this single line. Could you please help? Thanks in advance.

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

采纳的回答

Mohammad Sami
Mohammad Sami 2021-6-29
use the function fullfile to get the fullpath to the file.
fullpath = fullfile(pname,fname);
DAT = readtable(fullpath, 'VariableNamingRule', 'preserve' );

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by