App designer (excel /database /sheets )
5 ビュー (過去 30 日間)
I have a great database excel (several table in a single Excel sheet) and I want to use it for calculation in Matlab App designer,
my question is how can I get my data from this database (Excel) and use them on Matlab App designer,
MY solution is:
- I stored these table in Matlab as variable cell array , and I want every time I need a data I will go to find these variables.
Unfortunately my solution does not work, that's why I come to you to solicit you, give me an idea?
(how to use an excel static database file for calculations in matlab (app designer)
thanks in advance.
Nicolas B. 2019 年 11 月 14 日
you can directly read/write the excel file with readtable/readmatrix and writetable/writematrix. That works pretty fluently if you don't have too much data because you have to read the full table each time (but you can only write the cells you want to change).
Otherwise, take a look to the database toolbox and this example.