How to delete empty files/spreadsheets in a directory ?
7 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Ivan Mich
el 4 de Mzo. de 2021
Comentada: Walter Roberson
el 7 de Mzo. de 2021
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 comentarios
Walter Roberson
el 4 de Mzo. de 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?
Respuesta aceptada
Más respuestas (1)
Fangjun Jiang
el 4 de Mzo. de 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 comentarios
Walter Roberson
el 4 de Mzo. de 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
Ver también
Categorías
Más información sobre Whos en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!