How to read & display an excel file (using a button to select the file)?

[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).

Kindly, let me know where am I going wrong?

Answer 1

[VBBV]

%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.

[VBBV]

Recommended function is readmatrix from Matlab. Try it.