How to import all sheets of excel file with "UIgetfile" option?
28 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
taimour sadiq
le 19 Fév 2021
Commenté : taimour sadiq
le 19 Fév 2021
i m writing a code that fetch a excell file including all sheets and store that data in a Variable etc. What I've managed to do so far is i have written two codes, my first code is working but extracting only first sheet of any file...
filter = {'*.xlsx';'*.csv'};
[xlsfile,paht2xls] = uigetfile(filter,'Import-Daten');
FileData = xlsread(fullfile(paht2xls,xlsfile));
my second code extract all sheets of excel file but i m unable to integrate "uigetfile" in this code...
[~,sheet_name] = xlsfinfo('Data.xlsx');
for k = 1:numel(sheet_name)
data{k} = xlsread('Data.xlsx',sheet_name{k});
end
Kindly Guide either first code should extract all sheets of any excel file or second code which is extracting all sheets should work with "uigetfile" instead of specifying file name.... Thanks
0 commentaires
Réponse acceptée
Cris LaPierre
le 19 Fév 2021
Use uigetfile to select the file. Then use that name in your second code to import all the sheets. Maybe something like this (untested)
[xlsfile,paht2xls] = uigetfile(filter,'Import-Daten');
[~,sheet_name] = xlsfinfo(fullfile(paht2xls,xlsfile));
for k = 1:numel(sheet_name)
data{k} = xlsread(fullfile(paht2xls,xlsfile),sheet_name{k});
end
3 commentaires
Cris LaPierre
le 19 Fév 2021
If you are going to immediately turn your table into an array, you should use readmatrix instead of readtable.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!