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:
- Use Matlab to create the inputs for the Excel spreadsheet
- Open the Excel spreadsheet, copy inputs from Matlab into relevant fields and 'run' the calculation done in the spreadsheet
- 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.