MATLAB Answers

Is it possible to run Excel calculations in Matlab?

15 views (last 30 days)
Ibro Tutic
Ibro Tutic on 7 Dec 2016
Commented: dpb on 7 Dec 2016
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 Comments

dpb
dpb on 7 Dec 2016
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 on 7 Dec 2016
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 on 7 Dec 2016
Well, start with
doc xlsread
doc xlswrite
Then, of course, there's the ActiveX server that let's you interact directly at low-level.

Sign in to comment.

Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by