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.
1 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!