MATLAB Answers

Is it possible to run Excel calculations in Matlab?

10 ビュー (過去 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 件のコメント

dpb 2016 年 12 月 7 日
Sure there is, but why not ditch Excel entirely? It's surely simpler to write the computations in Matlab than VBA.
Ibro Tutic
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 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 件)

Community Treasure Hunt

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

Start Hunting!

Translated by