how can i get data from an Excel to app designer EDITFIELDS wit example folder and file

how can i get data from an Excel to app designer EDITFIELDS wit example folder and file

[Govind KM]

Moved comment to answer

[m.montaser sabry]

Thank it is working thank you It is clear

Answer 1

[Govind KM]

Hi @m.montaser sabry,

I assume you wish to read data from an Excel file, and display it in "EditField" components in MATLAB App Designer. This can be achieved by using the "readtable" function to read data from the specified Excel file within the code for your App, on App startup or in the callback for some other component.

For example, you could add an "EditField" and a "Button" to your app, with the "ButtonPushed" callback reading data from the Excel file and displaying the desired value in the "EditField" component. Here is sample code for such a callback:

function ButtonPushed(app, event)
    filename = fullfile(pwd, 'mydata.xlsx'); % Specify path to the Excel file
    data = readtable(filename); % Read the data from the Excel file
    
    % Set the desired value for the Edit Field from the Excel file data
    % Here the Edit Field value is set as the first element from the Name
    % column
    app.EditField.Value = string(data.Name(1));
end

Additional features could be included with this, such as using "uigetfile" to allow the user to select the Excel file instead of specifying the path in the App code, or adding components such as Sliders or Dropdowns to let the User select which data from the Excel file would be displayed in the Edit Field.

Kindly refer to the following documentation link for more information on the "readtable" function: https://www.mathworks.com/help/matlab/ref/readtable.html

Hope this helps!

[m.montaser sabry]

Thank you I accept answer

[m.montaser sabry]

When run that code it gives only one row not all rows why Thank you

[Walter Roberson]

It gives only one row because the posted code specifically does

    app.EditField.Value = string(data.Name(1));

To get all entries you would use

    app.EditField.Value = string(data.Name);

[m.montaser sabry]

What is the name ? i am using folder under name mirror1 which contain xlsx file beside that it gives error data is not numeric do not use string.i am using EditField (text). I am waiting your answer . Thank you in advance.

[Walter Roberson]

Use

    app.EditField.Value = string(data.(COLUMN_NUMBER));

for example

        app.EditField.Value = string(data.(2));

if the data is in column 2.

However, if the column is already text then use

            app.EditField.Value = data.(COLUMN_NUMBER);

[m.montaser sabry]

Thanks a lot but as you know in Excel columns are arranged as A B C …. When I referred to it it gives unknown A Or B How to overcome that message. Thank you for your help.

[Walter Roberson]

When you use readtable() each column gets assigned a variable name. If one of the first few lines of the input file looks like a list of headers then the headers are assigned as variable names; otherwise numbered variable names beginning with 'Var' are used (such as 'Var1').

When the syntax .(COLUMN_NUMBER) is used that accesses columns by index, regardless of the variable name associated with the column.

[m.montaser sabry]

excelfilepath=‘D:\mirror1\mirror1.xlsx’;
data=readtable(excelfilepath);
value=data(1,:);
appEditField.Value=string(value);

%The error is error using string conversion to string from table is not possible

[m.montaser sabry]

How to over come that problem since the previous advise does not work Also when i use the first 3 lines of my code with command window it works nicely Thank you again for your patience with me.

[Walter Roberson]

excelfilepath=‘D:\mirror1\mirror1.xlsx’;
data=readtable(excelfilepath);
value=data{1,:};
appEditField.Value=string(value);

or

excelfilepath=‘D:\mirror1\mirror1.xlsx’;
data=readtable(excelfilepath);
value=data.(1);
appEditField.Value=string(value);

[m.montaser sabry]

excelfilepath = 'D:\mirror1\mirror1.xlsx';
data = readtable(excelfilepath);
columnData = data(:, 1); % Assuming column A is the first column
app.EditField.Value = strjoin(string(table2array(columnData)), newline);

%That code is working well my be it will be good for others

Thanks

[m.montaser sabry]

I solved the problem and I posted it to be available for others .

Yours answer gives only one row but I want whole rows in one column so yours advise does not match what I want

So I accept your answer but did not solve my problem.

Thank you