MATLAB Answers

How to detect which type of data user selected 'text' or 'excel' file via "uigetfile" and then perform further code?

1 view (last 30 days)
i have written a code that allows user to input data and give both options of "text" and "Excel"..that is
[filename, pathname] = uigetfile({'*.xlsx','Excel Files(*.xlsx)'; '*.txt','Txt Files(*.txt)'}, 'Pick a file');
if '*.xlsx' % if excel file select
disp('User Selected Excel File.');
else
disp('User Selected Text File.');
end
% i tried isfile function but is detects data type.. kindly Guide. Thanks

Accepted Answer

Cris LaPierre
Cris LaPierre on 19 Feb 2021
Use this syntax of uigetfile
Here, indx corresponds to what filter was selected (see here). If that doesn't work, you can implement your own check using fileparts.
Here, ext will be the file extension of filename.
  3 Comments
taimour sadiq
taimour sadiq on 21 Feb 2021
Dear Thanks More than Thanks for ur Help, which Finally lead me to achieve my goal.. So nice of You.. Sharing the Working Code and code file attached also..
clc; clear all; close all;
BaseDir = 'C:\Program Files\Matlab\bin\';
[filename, pathname] = uigetfile({'*.xlsx','Excel Files(*.xlsx)';...
'*.txt','Txt Files(*.txt)'}, 'Pick a file', BaseDir);
if isequal(filename, 0)
disp('User aborted file choosing.');
return;
else
[fPath, fName, fExt] = fileparts(filename);
switch lower(fExt)
case '.xlsx'
disp = 'User Selected Excell Data'
case '.txt'
disp = 'User Selected Text Data'
otherwise % Under all circumstances SWITCH gets an OTHERWISE!
error('Unexpected file extension: %s', fExt);
end
end

Sign in to comment.

More Answers (0)

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!