Count number of sheets in excel file

64 次查看（过去 30 天）
Michael Whipple
Michael Whipple 2019-2-5
移动：Image Analyst 2023-2-6
I want to count the number of sheets in an excel file. I want to read from an excel file and count the number of sheets in that file and save that number to use as iteration count in a for loop.

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

回答（3 个）

KSSV
KSSV 2019-2-5
[status,sheets] = xlsfinfo(filename)
laurent jalabert
laurent jalabert 2022-2-4
移动：Image Analyst 2023-2-6
d = uigetdir(pwd, 'Select a folder');
DATA = dir(fullfile(d, '*.xlsx'));
[status,sheets] = xlsfinfo(DATA.name);
sheets = sheetnames(DATA.name);
length(sheets)
Sulaymon Eshkabilov
编辑：Sulaymon Eshkabilov 2023-2-5
It is recommended to use: sheetnames() instead of xlsfinfo(), e.g.:
clearvars
D = uigetdir(pwd, 'Choose a folder to import XLSX data');
XLSfile = dir(fullfile(D, '*.xlsx'));
Nfiles = length(XLSfile);
MYdata = cell(1, Nfiles);
for k = 1:Nfiles
SName=(sheetnames(XLSfile(k).name));
Nsheets = length(SName);
for jj = 1:Nsheets
MYdata{k,jj} = readtable(XLSfile(k).name, 'Sheet', SName(jj)); % Collects all data
end
end
%% ALT. Way:
% XLSfile = dir('*.xlsx'); % If your current directory, where all MS Excel
% files are residing, then use this
clearvars
XLSfile = dir('*.xlsx');
Nfiles = length(XLSfile);
MYdata = cell(1, Nfiles);
for k = 1:Nfiles
SName=(sheetnames(XLSfile(k).name));
Nsheets = length(SName);
for jj = 1:Nsheets
MYdata{k,jj} = readtable(XLSfile(k).name, 'Sheet', SName(jj)); % Colects all data
end
end
  1 个评论
Steven Lord
Steven Lord 2023-2-5
FYI sheetnames was introduced in release R2019b which came out several months after this question was asked.

请先登录，再进行评论。

类别

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

标签

产品


版本

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by