How to read & display an excel file (using a button to select the file)?
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
[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 commentaires
Réponses (1)
VBBV
le 27 Oct 2021
%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 commentaire
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!