How to import all sheets of excel file with "UIgetfile" option?

Question

taimour sadiq 2021-2-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/750124-how-to-import-all-sheets-of-excel-file-with-uigetfile-option

评论： taimour sadiq 2021-2-19

Data.xlsx

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Cris LaPierre 2021-2-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/750124-how-to-import-all-sheets-of-excel-file-with-uigetfile-option#answer_627934

在 MATLAB Online 中打开

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