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

4 次查看（过去 30 天）

显示更早的评论

Santosh Biradar 2022-7-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1768580-i-want-to-delete-the-row-data-from-excel-by-reading-column-in-the-same-sheet

评论： Santosh Biradar 2022-7-28

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

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

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

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2022-7-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1768580-i-want-to-delete-the-row-data-from-excel-by-reading-column-in-the-same-sheet#answer_1015750

在 MATLAB Online 中打开

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更早的评论隐藏 2更早的评论

Walter Roberson 2022-7-28

在 MATLAB Online 中打开

tab = readtable('SummaryResult.xlsx', 'sheetname', 'aaa', 'VariableRenaming', 'Preserve');
tab(startsWith(tab.('var5'),["Z"]),:) = [];
writetable('SummaryResult.xlsx', tab, 'sheetname', 'aaa')
numrow3 = size(tab,1);

Santosh Biradar 2022-7-28

@Walter Roberson

Thank you so much.

It worked.

Very thankful for your time and response.

请先登录，再进行评论。

更多回答（1 个）

Githin George 2022-7-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1768580-i-want-to-delete-the-row-data-from-excel-by-reading-column-in-the-same-sheet#answer_1015735

在 MATLAB Online 中打开

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