Is it possible to run Excel calculations in Matlab?
1 回表示 (過去 30 日間)
古いコメントを表示
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.
3 件のコメント
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 で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!