Why does uigetfile not open Excel files?
11 次查看(过去 30 天)
显示 更早的评论
Hi all,
I am using the following code to open and read data tables:
[FileName, PathName, FilterIndex] = uigetfile({'*.txt';'*.csv';'*.xls';'*.xlsx'},'File Selector');
T=readtable(strcat(PathName,FileName));
I have no issue opening .txt files, but I cannot select .xlsx files even after chosing this option via the file type selector (and even after choosing all file types!). What might cause this issue?
Edit: I selected the correct extension from the dropdown menu and it is still not possible to select Excel files. See below
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1019495/image.png)
Edit 2: I set the permissions to 'read and write' already, no change
回答(1 个)
Gagan Agarwal
2023-9-22
Hi Jesse Walters,
I reproduced the issue you described using MATLAB R2023a on Mac OS and encountered the same. It appears that this problem is specific to the operating system rather than MATLAB itself, as the code worked correctly on Windows OS.
However, there is a workaround to open Excel using the 'uigetfile' function. You can refer to the following code snippet as an alternative method to open Excel using the 'uigetfile' function:
% uigetfile function is used to open a file dialog box, allowing the user to select a file.
[file,path] = uigetfile('*');
% fval is the variable in which the file is loaded.
[~,~,fval]=fileparts(file);
For more information you can refer to the following documentation link:
I hope this workaround proves helpful to you!
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!