MATLAB is not deleting requested values.

I want to remove the first couple lines in an excel file as it is irrelevant information. I could do this in excel however, it would be much easier in Matlab as I have a lot of data files to import into Matlab.

Here is my code:

clear, clc, close all
AE_data = readmatrix('file')
AE_data(1:2,:) = [];

For some reason when I run this code it does not delete the rows. When i evaluate the specific line of code it deletes the rows. What am I doing wrong? I cannot figure out why Matlab will not delete these rows.

Thanks.

[Jan]

"when I run this code it does not delete the rows. When i evaluate the specific line of code it deletes the rows." - Please explain, what this means. I sounds like a contradiction.

The code does delete the 1st and 2nd row. So I assume that your observation is not correct.

[Steven Lord]

The code you've written does delete the first two rows in the copy of the data you loaded into MATLAB. It does not delete the first two rows in the file itself. Is the latter what you're trying to do?

[Reed Smith]

I have no idea why. It simply does not delete the rows no matter what. I am going to delete this question as I think this is an error with my Matlab and not the code.

Answer 1

[Sulaymon Eshkabilov]

Here is one example that shows it works:

D = readmatrix('Data2.xlsx', 'Sheet', 1)  % All imported

D = 13×2

1 5 2 7 3 9 4 11 5 13 6 15 7 17 8 19 9 21 10 23

D(1:2,:)=[]                              % Two rows are removed

D = 11×2

3 9 4 11 5 13 6 15 7 17 8 19 9 21 10 23 11 25 12 27