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
Best Answer