Count number of sheets in excel file
49 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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.
0 Kommentare
Antworten (3)
laurent jalabert
am 4 Feb. 2022
Verschoben: Image Analyst
am 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)
0 Kommentare
Sulaymon Eshkabilov
am 5 Feb. 2023
Bearbeitet: Sulaymon Eshkabilov
am 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 Kommentar
Steven Lord
am 5 Feb. 2023
FYI sheetnames was introduced in release R2019b which came out several months after this question was asked.
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!