Borrar filtros
Borrar filtros

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

2 visualizaciones (últimos 30 días)
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.
for i=1:n
data=xlsread(fullfile(files(i).folder, files(i).name));
I am not getting how to apply filter and save the files. Here is attachement of error.
  3 comentarios
bushra fatima
bushra fatima el 17 de Jul. de 2019
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
Bob Thompson el 17 de Jul. de 2019
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'];

Iniciar sesión para comentar.

Respuestas (1)

Mario Chiappelli
Mario Chiappelli el 18 de Jul. de 2019
This task would be a lot easier to accomplish in Visual Basic (VBA).


Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by