I want to delete the ROW data from excel by reading Column in the same sheet

조회 수: 1(최근 30일)
Hello
%%raw is having data of excel size 10X20
%%SummaryResult.xlsx is excel havinnd "aaa" is sheet name
If aaa sheet contains initial with "Z" WORD then I will delete that ROW.
try
Index = find(contains(raw(1:numrow1,1:1),'Z'));
if (Index(:))
xlswrite('SummaryResult.xlsx',raw(~Index,:),'aaa','A2')   %%here I am trying to delete to delete those rows which is having Z letter
else
0;
end
end
Thank You

채택된 답변

Walter Roberson
Walter Roberson 2022년 7월 27일
xlsread() does not create a table; none of the columns will have column names. You should use readtable
tab = readtable('SummaryResult.xlsx', 'sheetname', 'aaa', 'VariableRenaming', 'Preserve');
tab(startsWith(tab.('Analysis Target or not'),["Z"]),:) = [];
writetable('SummaryResult.xlsx', tab, 'sheetname', 'aaa')
numrow3 = size(tab,1);
  댓글 수: 4
Santosh Biradar
Santosh Biradar 2022년 7월 28일
Thank you so much.
It worked.
Very thankful for your time and response.

댓글을 달려면 로그인하십시오.

추가 답변(1개)

Githin George
Githin George 2022년 7월 27일
Hi Santosh,
My understanding is that you will be importing the table, editing it and then writing it back to the excel sheet.
You can try out the following idea for removing the rows you want to
% tab is the imported column
% This line just deletes the rows for which YourColName of the table
% contains "Z"
tab(contains(tab.YourColName,["Z"]),:) = []
You can write the modified table to your excel sheet.
Hope it helps
  댓글 수: 3

댓글을 달려면 로그인하십시오.

제품


릴리스

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by