Using Excel sheet to make calculations, as a function.

4 vues (au cours des 30 derniers jours)
Antonio Carlo Bertolino
Antonio Carlo Bertolino le 8 Fév 2017
Réponse apportée : KSSV le 8 Fév 2017
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!

Connectez-vous pour répondre à cette question.

Réponse acceptée

KSSV
KSSV le 8 Fév 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.

Plus de réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by