MATLAB AppDesigner | Tutorial 15 | Reading and Plotting Data from Excel

☑️ In this video:
0:37 Reading excel data in
1:42 Adding an axes for plotting
2:27 Defining the variable to plot the graph
4:09 Table to array function
4:34 Plotting the graph
5:20 Adding a grid to the plot

▶️ If you are finding my videos helpful please leave a like and subscribe to my channel.

⏭️ In the upcoming videos I'll teach how to use all the components in components library and how to connect AppDesigner to Simulink.

✉️ Get in touch:
If you do need some one to one support, feel free to drop an email via my contact page on my website. I will try my best to get back to you.

Thanks for watching everyone!

[brucedickson]

Hi Benito - informative as always. I've found another weirdness of v2018a. You can't use double quotes when calling a column, so
x = table2array(t(:, 'x_Data'));
works while
x = table2array(t(:, "x_Data"));
causes an error. Note also the (required) underscore which I commented on for Tutorial 14.

[ryanzhang]

I watched all 15 tutorials and really learned something! Thanks a lot! Your teaching is really clear and helpful, hope to see more tutorials from you

[carlbickford]

Thank you very much for this content. I teach a basic MATLAB class to engineers (I'm not a programmer) and was familiar with GUIDE. This series easily got me to switch my mindset for App Designer. It is a significant improvement!

[neetuprasad]

Hello Mr. Sebastian, Your tutorial are very helpful to lern app building in MATLAB. Thank you for that. It would be great if you could also teach how to make the table editable by user and plot the graph of the data fed by user in the table.

[abdulkadirgozuoglu]

Thank you for all 15 tutorials.We are expecting App designer and Arduino applications. Such as transfer sampled array data from arduino and real time plot in app designer.

[abidemna]

Thank you so much it works perfectly, I was wonder how can I read constantly the table: always reading without the button ???, by the way, your series is my first source what great work !!

[sadadreza]

Can you tell how to do linear regression by taking data from an excel file in this app designer?

[pinakpadman]

Thank you for the amazing tutorial Benito. I was trying to plot a graph with 1 column of data for X axis and 2 columns of data for Y axis on the same graph. Could you please help me with the syntax? Thank you in advance.

[tahiramajeed]

Hello! can you please make a tutorial about Histograms. how to draw 2-D histograms in app designer?

[rolanossi]

Hello Benito,
Perfect video as always.
But how can I send the imported excel data from Appdesigner to a Simulink block and then plot the result?

Thank you in advance.

Hi, how to access the table column value and split into two columns after reading data from an excel file?

[uriasdomingos]

Hi Benito may you plz tell how can I take a value on the table(or imported from excel sheet) to make a simple calculation in app designer?

[ylyopstar]

Hi, I have a problem while writing the plot(app.UIAxes, x, y); it said "Error using plot, invalid data argument"
So how to solve this problem?

[fabioklingon]

Hey Benito, Great Work! I have a question where I couldn't find any answer.

I want to read an huge excel table with lot of variables in app designer, then do some calculation with those variables and save them as a .mat file in the end.

How can a read ALL the variables?

Before (in my .m script) I was easily store it into a number and text cell and was using the assignin() command to put them into the workspace and save it as an mat.

Thanks a lot!

[fredecallesen]

Thank you Benito, nice tutorials, can you choose your excel file or txt file from app if yes, how ?

[khairuannas]

I have 3 questions.


1) Why do I get error of "Subscript indices must either be real positive integers or logicals." at where you convert table to array? All my data are positive integer, only random number and not following the order (i.e. 2, 4, 6, ...).


2) I humbly want to ask this question. I'm really slow at this, therefore I'm sorry but I wish to know. I do not see the formula of x square in the process of plotting the graph. How does reading table can plot graph y=x^2? What if I want to plot y=x^3+2x^2+3?


3)The whole learning process here is really helpful. I am curious, can you plot a simple control chart using a sample set of data from excel into UIAxes?


Thanks!

[bambiikiyo]

Thank you for the tutorial ! May I know if it's possible to plot data from excel with just one column of y data and the number of rows is the x value ? I've tried to modify the code to x = 0:length(y) but it tells me "Error using plot
. Vectors must be the same length"

[amirachouikh]

can you tell me please how to read the dimensions of an excel table ?

[joshuaraj]

can you show how to plot a bar graph in appdesigner

[rishabhbanavalikar]

How do i plot a linear regression model from a table ?