MATLAB: Delete excel rows whose first column is 0

excel

Hi, I want to delete rows if the first column in this row is 0. I know there are some answers online, I tried actxserver, but somehow it didn't work. Here is my code:
excelfilename = 'A.xlsx';
sheet = 'Sheet1';  
[num,txt,raw]=xlsread(excelfilename,'Sheet1');
  columnA = num(:,1);
      nrows=length(columnA);
    for i=1:nrows
        if (columnA(i,1)==0)
            row=i;
            excel = actxserver('Excel.Application');
workbook = excel.Workbooks.Open(file);
worksheet = workbook.Worksheets.Item(sheet);
worksheet.Rows.Item(row).Delete;
        end
    end
workbook.Save;
excel.Quit;
But I kept getting errors. May anyone kindly give me a hand? Many thanks in advance.

Best Answer

I just created some test data (numeric/text) to try and remove the rows that contain zeros in the first column. Think this is one of the easiest ways to do it, without using actxserver.
clear all;
%%----------- creating test data -----------
%Creating values
values = {1, 2, 3 ; 
          0, 5, 'x'; 
          4, 0, 2;
          3, 8, 9};
%Write xlsx file
xlswrite('A.xlsx',values,'Sheet1');
% ----------- end creating test data -----------
%%----------- Reading test data -----------
%Read xlsx file
[N,T,RAW] = xlsread('A.xlsx');
%Find zeros in first column
ind = find(cell2mat(RAW(:,1))==0);
%Remove rows
N(ind,:) = [];
%New data saved to second sheet of same file
xlswrite('A.xlsx',num2cell(N),'Sheet2');
Related Question