Create table from excel spreadsheet with multiple sheets
27 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
alpedhuez
am 7 Jul. 2018
Kommentiert: dpb
am 7 Jul. 2018
Suppose I have xlsx file with multiple sheets. I want to create table A from the first sheet and create table B from the second sheet. Please advise.
0 Kommentare
Akzeptierte Antwort
Image Analyst
am 7 Jul. 2018
Try this:
folder = fileparts(which('patients.xls')) % Determine where demo folder is.
fullFileName = fullfile(folder, 'patients.xls');
[status, sheetNames] = xlsfinfo(fullFileName)
numSheets = length(sheetNames)
t1 = readtable(fullFileName, 'Sheet', 1)
t2 = readtable(fullFileName, 'Sheet', 2)
and so on. Put in a loop if you want.
2 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!