MATLAB AppDesigner | Tutorial 17 | Using properties to add data to table

[@justthink5597]

Thanks Benito, this is the biggest tip to know IMO when using app designer

[@BenitoSebastian]

You are welcome, thanks for your questions. All the best!

[@mustahseenmobashwerdipro6736]

Great tutorial series! It helped me a lot. Thanks a ton. Btw, I am a Liverpool fan too haha

[@BenitoSebastian]

Nice, hopefully we will win the league this year and break some records too!

[@invertedsmile7258]

Got here cause of my bachelor thesis. Stayed because of the footballers. What a great lad you are haha #ynwa

[@tztz7114]

Very helpful tutorial, thank you!

[@rubengarciagarcia2238]

Excelent!

[@ajiekowski]

I hope Liverpool win the league this year, thank u!

[@mekkoyano]

Thanks Bonito, your videos are very helpful for me. I would like to ask you if I am building an app (called A) that contains a code that will open another app (B), and this app (B) provides me some variables stored in workspace, how to link these new variable with my first app (A) to use them ? Again, Thanks man, I appreciate your efforts in these videos.

[@BenitoSebastian]

Hi Ahmad, Thanks for your feedback. What you are trying to do is possible but it requires a couple of steps. I have attached a link which shows you how to create a multi window app and you can use your variables in different windows by defining it as a public property instead of private one . I will be making tutorials on this topic in the future. All the best ! uk.mathworks.com/help/matlab/creating_guis/creating-multiwindow-apps-in-app-designer.html

[@mekkoyano]

@@BenitoSebastian Thanks Benito !

[@amirroblex133]

Hi Benito I have been watching your videos in past days and learnt tons of useful thing, But i have a question, i want to make drop down menu in my app that if user choses option 1 value of lambda =100 ; phi =120 and if he choses option 2 value of phi and lambda gets changed. It seems to be easy but i have no clue what should i do to make it happen. TY

[@BenitoSebastian]

Hi Amir , Thankyou for your feedback. To change values based on a drop down menu value, I suggest using a switch statement or if statement. So I would do the following: 1. Create a DropDownValueChanged callback to a drop down menu. 2. Add a switch statement as follows: v = str2num(app.DropDown.Value); % Converting value from string to number switch v % Switching the value of the dropdown menu case 1 % When selected value in the dropdown menu is 1 % Lambda = 100; % phi = 120; case 2 % Lambda = 120; % phi = 140; otherwise % Lambda = 0; % phi = 0; end You can add as many cases as you like. All the best!

[@harishmogilipuri500]

Hi bentio your tourial is very helpful for learning matlab app Deginer. I am looking for browse excel file and plot data can you make video.

[@vojtaliska1430]

Hi Benito, good work with the tutorials, they're very helpful. Is there a way to save the modified data back to the .xlxs file?

[@BenitoSebastian]

Hi Vojta, Sorry for the late reply. Yes you can write back to an excel file using the following function writetable(T,filename,'Sheet',1,'Range','D1'). I will be making a tutorial on this soon. All the best!

[@EZIO2505]

@@BenitoSebastian Hi Benito, thank you for these usefull videos. I've a question: did you make that tutorial?

[@eliegedeonbikieyoudonangou5728]

@@BenitoSebastian I've tried, it works! I didn't put the 'Range' and 'D1' values, it automatically add to the last line of the excel table. Thank you !

[@bhagyeshshiyani4702]

Hey benito, I am beginner in appdesigner. I found lot clear way of explanation in your videos.i Have short question. I am creating table by adding rows with push button and writing data in cells. But i can't add strings data(ex. Names) into cells. Only numbers are allowed. Even i used code in push button app.UITable.ColumnFormat= ( 'char', 'char', 'numeric'). I want name, surname, and age in columns. Pls answer me.

[@thanismurugathas2929]

Maybe you have edit numeric fields rather than edit text fields?

[@tuncaykamas5275]

Hello Benito, I have found out that many people have an issue with the fact that syms does not work with standalone apps. Can you please make a brief tutorial that shows how to handle with this issue when we try to solve an equation with fzero or fsolve using symbolic variable(s). I guess many matlab appdesigner users would appreciate that.

[@gngh8160]

how can we find intercept or slope of a linear line ?

[@walterduesing5439]

Hey Benito thanks for your helpful tutorials.. I am not sure, if in the final part of this tutorial the goal of preventing the added names from being "wiped" is actually achieved.. And it looks like they are still being wiped when pressed read data...

[@REDSLibrary]

Dear, I made hundred of simulink models related to renewable energy desalination systems. My question is it possible to reform my simulink models into standalone application or App? If yes, how?

[@BenitoSebastian]

Hi Reds, You can run simulink models using a GUI made on app designer or send the output signals to an app on app designer. You can then share the application as as matlab app. This is quite involved and I will be shortly making tutorials on how to connect your simulink to appdesigner.

[@REDSLibrary]

@@BenitoSebastian very good, I will be waiting for that.

[@malvikakamat7233]

Hi Benito, Really liked your tutorials. Could you please also tell me how to link .mat file to a table in app designer? Thanks in advance

[@BenitoSebastian]

Hi Malvika, Sorry for the late reply. So if you have a matrix or structure, you have to convert it to a table using array2table function. So for example: data = array2table(yourvariable) Once this is done, save it as a .mat file. Then in appdesigner you can load the .mat file as follows: app.t = load('data.mat'); app.UITable.Data = app.t.table. The reason why you need t.table is because the table is stored with the field name .table inside variable data. Hope that makes sense.

[@malvikakamat7233]

@@BenitoSebastian thank you so much for your reply 😊

[@BenitoSebastian]

@@malvikakamat7233 You are welcome, did you get it working?

[@sunilgiri7718]

Hi Benito, Can you please guide me on 'How to control, I mean access and edit the values of n-D look-up table elements which are used in a Simulink model' using the MATLAB App Designer? Thank you in anticipation!

[@juandavidrojas930]

hi Benito. I learn too much with your videos. I have a question, I need to find a word or number in the table that i recently input in the app. It exist a way to search any word directly in my app. Just like excel.

[@BenitoSebastian]

I am glad to hear that Juan. To search for a word you can use the strcmp function to compare strings. For example you can loop through each row in a table and compare each cell value using the code: strcmp(i,'Juan'). All the best!

[@aykutsirma4260]

Nice Tutorial. When we open the excel file with "Read .xlsx" the data table appears and it is possible to click to the boxes there and it become blue for the chosen box. Thus, it is possible to print the selected box of the excel data appeared inside of table to text edit field section and how can we add such a feature? thank you.

[@akashsaseendran7815]

Hi Benito, Thank you for the videos, they are really helpful. I need to create a table that gets updated after entering each row depending on a parameter(for eg: 'age' in your video) that is calculated using another function. Can you give some insights on this?

[@thuannv1988]

Great work Benito! Is there any way to add a new row to an arbitrary position in the table? Thanks!

[@hongtse6723]

Hey, maybe you don't respond because, this is an old video. But it seems like for nr you can only have 2 variables instead of more. When you add an additional variable in the curly brackets, I would get an error Cannot concatenate the table variable '***' because it is a cell in one table and a non-cell in another. What can I do to resolve this? edit: I think I also have problems with numbers in excel. I can't seem to add numbers.

[@thanismurugathas2929]

Hi, do you mean adding a new row with 3 variables? Such as nr = {1; 2; 3}? The reason this isn't possible with his tables is that his tables only have 2 columns therefore you can only input 2 values into each column to make a new row. If he had a table of 3 columns then you would be able to add a new row with 3 values.

[@achilles6171]

can you please make videos on how to read a text file?

[@suhafaleh5708]

hi when I add value in edite field I get the error Error setting property 'Data' of class 'Table': Values within a cell array must be numeric, logical, or char

[@ayushanandsagar4701]

hii Benito I am having a problem updating the table after entering the data in the app designer how do I update the sheet and then save it to excel??

[@fatihcanuslu2462]

Are we able too change colors of columns ?

[@quotesofbooksandlife6511]

Hi, I add the Private property but Matlab does not let me save any modifications to it, does someone know how to solve it?

[@fahminrahman3543]

Can the titles of each column like 'column 1' , 'column 2' be changed to desired titles?

[@arvee3451]

for that you just have to change it on design view, double click the column names

[@znsxoli]

at 5:10 wouldnt app.UITable.Data=[ app.UITable.Data nr]; work?

[@aliyaman6669]

how to change the variable names? app.t=readtable("Yeni Microsoft Excel Çalışma Sayfası.xlsx","Sheet","Sayfa3"); app.t.Properties.VariableNames{1}='Name'; app.t.Properties.VariableNames{2}='Surname'; app.t.Properties.VariableNames{3}='Age'; app.UITable.ColumnName=app.t.Properties.VariableNames; app.UITable.Data=app.t; it works, but i get warrnings that related to orders. What must be correct orders of line?

[@yusufhassan3710]

how to fill the table with in the code without using the excel fill?

[@supersosiska]

Are properties similar to global variables?

[@TheBlackCatpk]

how to i export the updated data ?

[@rishabhbanavalikar8155]

Bet you're not a Liverpool fan