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

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.

Answer 1

[Anurag Agrawal]

Hi Raffaele

You can use dir function to filter out the content of your folder.

https://www.mathworks.com/help/matlab/ref/dir.html

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.

[Raffaele Fracchetti]

Hello,

Thank you. It worked well.

Appreciated

[Anurag Agrawal]

Welcome :)