MATLAB Answers

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

3 views (last 30 days)
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!

  0 Comments

Sign in to comment.

Accepted Answer

Cris LaPierre
Cris LaPierre on 28 Oct 2020
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).

  2 Comments

muhammad choudhry
muhammad choudhry on 28 Oct 2020
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

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by