Info

此问题已关闭。 请重新打开它进行编辑或回答。

Extract specific excell files from a folder and merge all the data in a single file

1 次查看(过去 30 天)
Hello everybody,
I have a folder with 1000 excell file. I would like to copy the data from specific file and paste in a file where I will paste all the data extracted from the orginal files. I would like to do it in an automatic way but I don't know how to pass the right name to xlsread() function. Let me show you an example:
Folder of orginal files:
20200210091035.jpg
20200210091035_ave.xls
20200210091035_cur.xls
20200210091042.jpg
20200210091042_ave.xls
20200210091042_cur.xls
and so on.
I have to extract in order the data from all the "..._cur.xls" files and put it in single file. My problem is that the name of the file not vary in a continous way. The only fixed parameter is that the file I have to extract is every 3 files.
Thank you in advance to everybody.

回答(1 个)

Anurag Agrawal
Anurag Agrawal 2020-3-30
编辑:Anurag Agrawal 2020-3-30
Hi Raffaele
You can use dir function to filter out the content of your folder.
In this case you can use the follwoing command:
>> myFiles = dir('*_cur,xls');
% '*' here acts as a wildcard
This will help you store all the desired file in the variable myFiles which you can use later to copy data from. You can pass the myFiles(1).name, myFiles(2).name,.. and so on in xlsread() command.

此问题已关闭。

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by