Is there a way in matlab where I can delete the first row of 50 excel files in a folder?

Hi,

I would like to delete the first row from 50 different excel files all saved in a same folder. Is there a way to do it in matlab? All I could have come across so far is how to delete the rows from a single file.

Any help would be appreciated!

Answer 1

[Cris LaPierre]

You would take the code for a single file, and put it inside a for loop that iterates through every file in the folder. You can either hardcode the path to the folder or use uigetdir. Once you have the folder, use the dir function to get the file names. Then set your loop to run from 1:length(filenames).

[muhammad choudhry]

Can you give me an example or can guide me what I need to do more in the code below I am working on, it reads the file but I am not sure what else to do to delete the first row from each file and save it.

Creating a code: # this code only reading the number of files available

csvFiles = dir("*.csv") ;

N = length(csvFiles) ;

for i = 1:N

.................

end

[Cris LaPierre]

Perhaps this post can get you started.