How to delete empty files/spreadsheets in a directory ?
5 views (last 30 days)
Show older comments
Hello,
I have a directory with milions of .xlsx files. The point is that I want to remove empty files. Is there a way to do it using a command in matlab? Instead of the fact that these files are empty, they have 10kb.
Could you please help me?
4 Comments
Walter Roberson
on 4 Mar 2021
To clarify:
Files that have only one line of data should be deleted, but files that have more than one line of data should not be deleted?
Accepted Answer
Ivan Mich
on 5 Mar 2021
Edited: Ivan Mich
on 7 Mar 2021
More Answers (1)
Fangjun Jiang
on 4 Mar 2021
- run [STATUS,SHEETS] = xlsfinfo(FILENAME). Most likely, it will tell you there is only one sheet
- run [NUM,TXT,RAW]=xlsread(FILENAME). Most likely, isempty(NUM) and isempty(TXT) are both true
- delete(FILENAME)
2 Comments
Walter Roberson
on 4 Mar 2021
Alternative to the second step:
C = readcell(FILENAME);
isempty(C)
For example,
[STATUS, SHEETS] = xlsfinfo(FILENAME);
if length(SHEETS) > 1; next; end %assume multiple sheet files are special
C = readcell(FILENAME, 'sheet', SHEETS{1});
if isempty(C); delete(FILENAME); end
See Also
Categories
Find more on Entering Commands in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!