How can I delete a row in a excel dokument if the value in a colonm is = F???

Question

Peter Johansen 2017-5-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/341098-how-can-i-delete-a-row-in-a-excel-dokument-if-the-value-in-a-colonm-is-f

回答： MathReallyWorks 2017-5-22

Screen Shot 2017-05-20 at 14.13.43.png

I have an assignment In Matlab, and I am not a very experience user of it, so I would love if any1 og you could help me out.

this is part of my assignment and I only need help top the question D

I have two excel dokument one with Social Security numbers in column 1. and income in column 2. the other dokument I have SSN I column 1. and gender in colonm 2 (F or M) for the gender. I really hope some of you guys can help me out.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

MathReallyWorks 2017-5-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/341098-how-can-i-delete-a-row-in-a-excel-dokument-if-the-value-in-a-colonm-is-f#answer_267877

在 MATLAB Online 中打开

Hello Peter Johansen,

Here you go. Use this code. It deletes all the F rows and the corresponding rows in income excel sheet too. It saves the final excel sheets as genderlistfinal.xls and incomelistfinal.xls in current folder. Check it out.

[num,txt,raw] = xlsread('gender.xls');
[num1,txt1,raw1] = xlsread('income.xls');
num1=num1(:,2); %income
j=1;
for i=1:10
  if char(txt(i))=='M'
      num2(j)=num1(i);
      txt2(j)=txt(i);
      j=j+1;
  end
end
filename1 = 'genderlistfinal.xls';
xlswrite(filename1,txt2')
filename2 = 'incomelistfinal.xls';
xlswrite(filename2,num2')