How to delete empty files/spreadsheets in a directory ?

9 次查看（过去 30 天）
Ivan Mich
Ivan Mich 2021-3-4
评论： Walter Roberson 2021-3-7
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 个评论
显示 2更早的评论
Walter Roberson
Walter Roberson 2021-3-4
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?
Ivan Mich
Ivan Mich 2021-3-4
编辑：Ivan Mich 2021-3-4
I should delete files that have no line of data (see the format of the EMPTY.xlsx' file I uploaded) and I should keep files that have one or more than one line of data.
Did you understand?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Ivan Mich
Ivan Mich 2021-3-5
编辑：Ivan Mich 2021-3-7
After your suggestions I wrote finally this script that works
clc
clear
% C = readcell('EMPTY.xlsx');
% isempty(C)
emptyfiles=dir('*xlsx')
for k=1:numel(emptyfiles)
emptynew=emptyfiles(k).name
[STATUS, SHEETS] = xlsfinfo(emptynew);
% if length(SHEETS) > 1; next; end %assume multiple sheet files are special
C = readcell(emptynew, 'sheet', SHEETS{1});
if isempty(C);
delete(emptynew);
end
end
  5 个评论
显示 3更早的评论
Ivan Mich
Ivan Mich 2021-3-7
Ok, one last question. Can I delete files that have only 1 row and one column empty (I mean 1x1 double) and keep all the other files?

请先登录，再进行评论。

更多回答（1 个）

Fangjun Jiang
Fangjun Jiang 2021-3-4
  1. run [STATUS,SHEETS] = xlsfinfo(FILENAME). Most likely, it will tell you there is only one sheet
  2. run [NUM,TXT,RAW]=xlsread(FILENAME). Most likely, isempty(NUM) and isempty(TXT) are both true
  3. delete(FILENAME)
  2 个评论
Walter Roberson
Walter Roberson 2021-3-4
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
Ivan Mich
Ivan Mich 2021-3-5
I run this code after your suggestions:
[STATUS, SHEETS] = xlsfinfo('*.xlsx');
if length(SHEETS) > 1; next; end %assume multiple sheet files are special
C = readcell('*.xlsx', 'sheet', SHEETS{1});
if isempty(C); delete('*.xlsx'); end
BUT NO USE!
Do you know why?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Entering Commands 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by