Reading file in subfolders with readtable

61 vues (au cours des 30 derniers jours)
mehtap agirsoy
mehtap agirsoy le 29 Juin 2021
Commenté : mehtap agirsoy le 29 Juin 2021
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.

Réponse acceptée

Mohammad Sami
Mohammad Sami le 29 Juin 2021
use the function fullfile to get the fullpath to the file.
fullpath = fullfile(pname,fname);
DAT = readtable(fullpath, 'VariableNamingRule', 'preserve' );
  1 commentaire
mehtap agirsoy
mehtap agirsoy le 29 Juin 2021
Many thanks Mohammad, really appreciate it.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Cell Arrays dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by