Why does uigetfile not open Excel files?

22 次查看（过去 30 天）
Jesse Walters
Jesse Walters 2022-6-2
回答： Gagan Agarwal 2023-9-22
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
Edit 2: I set the permissions to 'read and write' already, no change
  3 个评论
显示 1更早的评论
Jesse Walters
Jesse Walters 2022-6-2
It will not open any excel file in ANY folder
Jan
Jan 2022-6-2
编辑：Jan 2022-6-2
By the way, prefer fullfile instead of strcat to concatenate parts of a path.
Please try:
cd('~')
[f, p] = uigetfile('*.*', 'File Selector')
When did this start? What has happend before?
Does this help: https://discussions.apple.com/thread/7532389

请先登录，再进行评论。

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

回答（1 个）

Gagan Agarwal
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:
https://www.mathworks.com/help/matlab/ref/uigetfile.html
I hope this workaround proves helpful to you!

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by