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

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

Answer 1

[Walter Roberson]

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);

[Santosh Biradar]

Hi @Walter Roberson

Getting this error.

Unrecognized table variable name 'Analysis Target or not'.

[Santosh Biradar]

Here, tab is Unable to read Analysis Target or not.

It is reading it as var5.

Pls check attached imageimage

[Walter Roberson]

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]

@Walter Roberson

Thank you so much.

It worked.

Very thankful for your time and response.

Answer 2

[Githin George]

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

[Santosh Biradar]

Hello @Githin George

Thankful for your response.

Facing error.

[num,txt,raw] = xlsread('SummaryResult.xlsx','aaa');
tab(contains(tab.Analysis Target or not,["Z"]),:) = [];
%%Index = tab(contains(tab.Analysis Target or not,["Z"]),:)  
xlswrite('SummaryResult.xlsx',raw(Index,:),'aaa','A2')
 numrow3 = size(raw,1);

Error: File: CompSummary.m Line: 36 Column: 31

Invalid expression. Check for missing multiplication operator, missing or unbalanced delimiters, or other syntax error. To

construct matrices, use brackets instead of parentheses.

[Githin George]

The issue could be your column name. Please verify whether column name in 'tab' is matching 'Analysis Target or not'

[Santosh Biradar]

Thank you@Githin George for your help.