How to delete empty files/spreadsheets in a directory ?

2 次查看（过去 30 天）

Ivan Mich 2021-3-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/763246-how-to-delete-empty-files-spreadsheets-in-a-directory

评论： 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更早的评论隐藏 2更早的评论

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 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 2021-3-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/763246-how-to-delete-empty-files-spreadsheets-in-a-directory#answer_639771

编辑：Ivan Mich 2021-3-7

在 MATLAB Online 中打开

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更早的评论隐藏 3更早的评论

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?

Walter Roberson 2021-3-7

在 MATLAB Online 中打开

if size(C,1) == 1 && size(C,2) == 1
    delete(emptynew);
end

请先登录，再进行评论。

更多回答（1 个）

Fangjun Jiang 2021-3-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/763246-how-to-delete-empty-files-spreadsheets-in-a-directory#answer_639381

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 个评论
显示无隐藏无

Walter Roberson 2021-3-4

在 MATLAB Online 中打开

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 2021-3-5

在 MATLAB Online 中打开

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