You'll have to simply iterate over the collection of files, reading each and searching for the string and then delete that file if found. The <FAQ> is helpful; particularly for something like the above the dir solution is quite useful.
d=dir('*.xlsx'); % list of the files
for i=1:length(d)
[~,txt]=xlsread(d(i).name,1,'M6'); % read the text
if strcmp(txt,'DepthLHS')
delete(d(i).name)
end
end
If DepthLHS is a variable instead of a literal string, make the obvious substitution. NB: This is essentially duplicate of at least two others (I deleted one as being identical other than the file extension which is totally immaterial); the other has a question of how to modify a document.
As for that secondary question, on Windows you use the AciveX/COM interface for the given application; specific commands for that are part of the documentation for the application and are NOT a Matlab question; you'll have better luck on those with a MS-specific forum.
There are some examples of working with Word/Excel in the Matlab documentation that may get you started in that direction.
