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

1 次查看（过去 30 天）
Santosh Biradar
Santosh Biradar 2022-7-27
评论： Santosh Biradar 2022-7-28
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 个评论
显示 2更早的评论
Walter Roberson
Walter Roberson 2022-7-28
tab = readtable('SummaryResult.xlsx', 'sheetname', 'aaa', 'VariableRenaming', 'Preserve');
tab(startsWith(tab.('var5'),["Z"]),:) = [];
writetable('SummaryResult.xlsx', tab, 'sheetname', 'aaa')
numrow3 = size(tab,1);

请先登录，再进行评论。

更多回答（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 个评论
显示 1更早的评论
Githin George
Githin George 2022-7-27
The issue could be your column name. Please verify whether column name in 'tab' is matching 'Analysis Target or not'

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by