Clear Filters
Clear Filters

Count number of sheets in excel file

112 views (last 30 days)
Michael Whipple
Michael Whipple on 5 Feb 2019
Moved: Image Analyst on 6 Feb 2023
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.

Answers (3)

KSSV
KSSV on 5 Feb 2019
[status,sheets] = xlsfinfo(filename)

laurent jalabert
laurent jalabert on 4 Feb 2022
Moved: Image Analyst on 6 Feb 2023
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 on 5 Feb 2023
Edited: Sulaymon Eshkabilov on 5 Feb 2023
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 Comment
Steven Lord
Steven Lord on 5 Feb 2023
FYI sheetnames was introduced in release R2019b which came out several months after this question was asked.

Sign in to comment.

Products


Release

R2017b

Community Treasure Hunt

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

Start Hunting!