Using Excel sheet to make calculations, as a function.

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!

Answer 1

[KSSV]

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.