Integrating MATLAB with Excel
显示 更早的评论
Hello!
I have a DCF model, which is Excel spread-sheet. I have put all assumptions of my model in separate sheet.
I want to run a Monte-Carlo simulation of this assumptions.
Ex I need to do the following: 1) Matlab will generate numbers according to specific distribution. 2) Then, Matlab will insert numbers in Excel spreadsheet. 3) Excel will recalcualte my model and build a distribution chart.
Is it possible to do this? Thank you!
回答（1 个）
Image Analyst
2012-11-25
0 个投票
Yes. You can just use xlswrite() to throw your data into your Excel workbook in the proper rows. Then when you open up the workbook in Excel, your model will be recalculated. If you need anything fancier than that, what is it? If so, you'll have to use ActiveX. I have a simple demo but doing anything fancy can be quite a chore because you need to figure out what the ActiveX method of Excel is that does what you want to do.
4 个评论
terance
2012-11-25
Image Analyst
2012-11-25
No. Just save up all your results in a matrix or cell array and then write it all one in just one call to imwrite.
terance
2012-11-25
Image Analyst
2012-11-25
Are you sure? I didn't see that exclusion in my documentation. If so, then call the Mathworks and ask them for an equivalent function to xlswrite that works on the Mac.
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
