How to delete empty files/spreadsheets in a directory ?

2021 3 4
2 个回答
回答已采纳
更新时间：2021 3 7
5 次查看（30 天）

0 个投票

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
Walter Roberson 2021-3-4
Ran in:
Ran in:
data = {};
writecell(data, 'test.xlsx');
!ls -l test.xlsx
-rw-r--r-- 1 mluser worker 2053 Mar 4 20:15 test.xlsx
If I understand correctly, you are indicating that the files have no visible content, but still take up about 10 kb of space.
If so then that would suggest that they might have template or macro material written into them, or might have additional sheets.
How do you want to decide whether a particular spreedsheet is empty enough for your purposes?
Ivan Mich
Ivan Mich 2021-3-4
If I open some files the have one line of data, whereas some somes have no data.
The .xlsx files are outcome of a loop which creates multiple files.
I am importing you two examples of files (one empty and one with data)
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

0 个投票

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

Fangjun Jiang
Fangjun Jiang 2021-3-5
This script won't work, if you've run it!
Ivan Mich
Ivan Mich 2021-3-7
I modify it. Now it works. I have one question. If I want to specify it in order to delete files that have empty only the second column how could I make it? I mean one file that has only the first column with data and all the others are empty how could this file be deleted , after a code modification?
Thank you in advance
Walter Roberson
Walter Roberson 2021-3-7
if isempty(C) || size(C,2) < 2
delete(emptynew);
end
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?
Walter Roberson
Walter Roberson 2021-3-7
if size(C,1) == 1 && size(C,2) == 1
delete(emptynew);
end

请先登录，再进行评论。

更多回答（1 个）

Fangjun Jiang
Fangjun Jiang 2021-3-4

0 个投票

  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?

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Variables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by