Is it possible to run Excel calculations in Matlab?

4 次查看（过去 30 天）
Ibro Tutic
Ibro Tutic 2016-12-7
评论： dpb 2016-12-7
Basically I have an extremely involved Excel spreadsheet that calculates stress/strain on different materials. There are various inputs in the Excel spreadsheet and then it calculates data points corresponding to stress/strain. Is there a way to:
  1. Use Matlab to create the inputs for the Excel spreadsheet
  2. Open the Excel spreadsheet, copy inputs from Matlab into relevant fields and 'run' the calculation done in the spreadsheet
  3. Extract stress/strain data to plot in Matlab.
The spreadsheet itself has a worksheet with the data values that I am interested in plotting in Matlab, but I need to be able to define input parameters in Matlab and plot the curves in Matlab, not in Excel.
  3 个评论
显示 1更早的评论
Ibro Tutic
Ibro Tutic 2016-12-7
编辑：Ibro Tutic 2016-12-7
It's mainly due to the complexity of the spreadsheet. There are probably 100s of if statements, each referencing a different cell on different sheets. I would have to look through the entire spreadsheet, figure out which equation references what data, what the equation is specifically, dig through VBA, write the computations in Matlab, etc. For what I am trying to do, I just need to be able to input the values into Matlab, have Matlab stick it in Excel, and have Excel run the calculation and then I take the data from a worksheet in the Excel doc.
Everything is already coded in the spreadsheet, so redoing in Matlab isn't a good use of time if I don't need to.
dpb
dpb 2016-12-7
Well, start with
doc xlsread
doc xlswrite
Then, of course, there's the ActiveX server that let's you interact directly at low-level.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by