how to read multiple excel files, apply hampel filter and save them into folder with same names as input files

Hi everyone

I have 20 excel files in a folder, I want to read those files, apply hampel filter and save them into a folder with same names.

files=dir('E:\EEG_RECORDING\Male_Data\*.csv');

files=files(~[files.isdir]);

n=length(files);

for i=1:n

data=xlsread(fullfile(files(i).folder, files(i).name));

a=hampel(data,y)

end

I am not getting how to apply filter and save the files. Here is attachement of error.

[Bob Thompson]

What is 'y,' and what is the class of 'data?'

What file format do you want to save your data as? The exact command is going to depend on what format you want, but you'll just add another line to the interior of your for loop to save the file.

Making a new folder can be done with mkdir. This should also be added to your for loop.

[bushra fatima]

Thankyou for your response

'y' is currently output file (result of hampel filter). I want to save data as csv file and want to generate same names as input files. How can I generate file name in loop and save them to a folder. my main is to apply hampel filter to 20 files and save them to a folder.

[Bob Thompson]

Making a file name within a loop is usually accomplished by concatonating a string. I will provide an example, but you will have to change it to come up with your specific desired output.

y = [files(i).folder,'\output_',num2str(i),'.csv'];

Answer 1

[Mario Chiappelli]

This task would be a lot easier to accomplish in Visual Basic (VBA).