Using Excel sheet to make calculations, as a function.
조회 수: 3 (최근 30일)
이전 댓글 표시
Hi everyone, i have an Excel sheet with lots of formulas between the cells. I was wandering if it were possible to use it as a function. I would like to write from MATLAB a value in a cell and then to read the corresponding value from another cell. Or alternately i would like to import not only the values of the cells but also the formulas, which link the cell one to eachother, so that i will be able to mange them within MATLAB. Is it possible? Thanks!
댓글 수: 0
채택된 답변
KSSV
2017년 2월 8일
May be this is the one you are looking for: http://in.mathworks.com/matlabcentral/fileexchange/9629-analyseexcelformulas
It is easy to write a formula in matlab to do array operations. I suggest you to write a function in matlab for operations.
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!