I want to delete the ROW data from excel by reading Column in the same sheet
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Santosh Biradar
le 27 Juil 2022
Commenté : Santosh Biradar
le 28 Juil 2022
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 commentaires
Réponse acceptée
Walter Roberson
le 27 Juil 2022
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 commentaires
Walter Roberson
le 28 Juil 2022
tab = readtable('SummaryResult.xlsx', 'sheetname', 'aaa', 'VariableRenaming', 'Preserve');
tab(startsWith(tab.('var5'),["Z"]),:) = [];
writetable('SummaryResult.xlsx', tab, 'sheetname', 'aaa')
numrow3 = size(tab,1);
Plus de réponses (1)
Githin George
le 27 Juil 2022
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 commentaires
Githin George
le 27 Juil 2022
The issue could be your column name. Please verify whether column name in 'tab' is matching 'Analysis Target or not'
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!