How to read all CSV files from specific folders?

177 次查看（过去 30 天）
Roozbeh Yousefnejad
评论： Behtom 2023-11-9
Hi, I want to open all CSV files and do a calculation on them. I used the code below and it worked
files = subdir('C:\Users\roozm\Desktop\New folder\*.csv');
Subdir function can do it easily. Now I want to be more specific and only open folder with the name of BIN and then read CSV files in only BIN folders.
How can I do that?
  11 个评论
显示 9更早的评论
Roozbeh Yousefnejad
Roozbeh Yousefnejad 2018-6-1
I am just entering it in the command window. Honestly, I do not know how to check if the file is in my current directory.
Paolo
Paolo 2018-6-1
I'm not sure I understand what you mean by 'I do not know how to check if the file is in my current directory.'
Lets say your current working directory is :
C:\Users\roozm\
as from your OP. Could you list the full path of the .csv files you want, this way we can build the dir command?

请先登录，再进行评论。

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

回答（3 个）

Walter Roberson
Walter Roberson 2018-6-1
files = dir('C:\Users\roozm\Desktop\New folder\**\BIN*\*.csv');
fullpaths = fullfile({files.folder}, {files.name});
Now fullpaths is a cell array of fully qualified .csv files that are directly under a BIN* folder anywhere under "New folder"
  10 个评论
显示 8更早的评论
Roozbeh Yousefnejad
Roozbeh Yousefnejad 2018-6-4
编辑：Roozbeh Yousefnejad 2018-6-4
I am afraid that there is another reason behind it as I am running the code in the debugging mode and step by step (I've attached a pic) So I believe xlsread() doesn't have a problem with the loop. Also, the files are closed.
As you can see in the picture, the curser is on the subset line and it is only the first xlsread command that I get error.

请先登录，再进行评论。

Roozbeh Yousefnejad
I mean, I don't know how to find my directory path. The file that I want to open is in this path
C:\Users\roozm\Desktop\New folder\F21802010055\BIN\CSV
which is on my desktop.
  4 个评论
显示 2更早的评论
Paolo
Paolo 2018-6-1
编辑：Paolo 2018-6-1
I was referring to this command:
dir('*/BIN*/*.csv')
Use this one if you are running from 'New folder'

请先登录，再进行评论。

Roozbeh Yousefnejad
I replaced filename = filepaths{i}; instead of filename=files(i).name but got this error
Undefined variable "filepaths" or class "filepaths".
Error in new (line 8)
filename = filepaths{i};

类别

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

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by