Using Excel sheet to make calculations, as a function.

4 visualizaciones (últimos 30 días)
Antonio Carlo Bertolino
Antonio Carlo Bertolino el 8 de Feb. de 2017
Respondida: KSSV el 8 de Feb. de 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!

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

KSSV
KSSV el 8 de Feb. de 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.

Más respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by