How to read & display an excel file (using a button to select the file)?
6 次查看(过去 30 天)
显示 更早的评论
[file,path]= uigetfile({'*.*'},...
'select a file',app.filepath);
app.button1.Value= file;
t =xlsread('C:\Users\t.xlsx','sheet_3','A1:AA4');
I am trying this code, to read and display(in edit field) a selected file from a file explorer as soon as I click the 'Button1'.
I am able to display the file name, but the data in the file is not read (when I run the code and see in the command window).
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/780463/image.png)
Kindly, let me know where am I going wrong?
0 个评论
回答(1 个)
VBBV
2021-10-27
%if true
[N TT R] =xlsread('C:\Users\t.xlsx','sheet_3','A1:AA4');% Try to change the out
It seems you have the excel file name and variable to which you are reading in workspace are same. Also check if the sheet with name sheet_3 exists in the file.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!