Using Excel sheet to make calculations, as a function.
6 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
KSSV
on 8 Feb 2017
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 Comments
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!