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

22 次查看（过去 30 天）
taimour sadiq
taimour sadiq 2021-2-19
评论： taimour sadiq 2021-2-19
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

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

采纳的回答

Cris LaPierre
Cris LaPierre 2021-2-19
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 个评论
显示 1更早的评论
Cris LaPierre
Cris LaPierre 2021-2-19
If you are going to immediately turn your table into an array, you should use readmatrix instead of readtable.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by