Count number of sheets in excel file

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.

Answer 1

[KSSV]

[status,sheets] = xlsfinfo(filename)

Answer 2

[laurent jalabert]

d = uigetdir(pwd, 'Select a folder');
DATA = dir(fullfile(d, '*.xlsx'));
[status,sheets] = xlsfinfo(DATA.name);
sheets = sheetnames(DATA.name); 
length(sheets)

Answer 3

[Sulaymon Eshkabilov]

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

[Steven Lord]

FYI sheetnames was introduced in release R2019b which came out several months after this question was asked.