App designer (excel /database /sheets )

조회 수: 2 (최근 30일)
kinidi
kinidi 2019년 11월 14일
댓글: kinidi 2019년 11월 14일
hello everyone,
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.
  댓글 수: 3
kinidi
kinidi 2019년 11월 14일
Capture.PNG
kinidi
kinidi 2019년 11월 14일
my problem is that I can not get the cells of the tables stored forms of variable on Matlab from App designer by browsing the tables,

댓글을 달려면 로그인하십시오.

채택된 답변

Nicolas B.
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.
  댓글 수: 1
kinidi
kinidi 2019년 11월 14일
thank you for this answer ,
I think you did not understand me too well, so
my excel file is full of data tables
and I stored all these tables forms variables on Matlab (cell array)
and my question is, how do I go through this table of data(cell array) to retrieve the value to use in each calculation ,and all that needs to be done with app designer
thanks

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

제품


릴리스

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by