MATLAB Answers

How to convert my Matlab code into an Excel add-in?

31 views (last 30 days)
Ji Li
Ji Li on 16 Aug 2018
Commented: Ji Li on 16 Aug 2018
I would like to use Matlab to run a model simulation, all the calculations are done in Matlab, but inputs are from Excel file and the outputs are also returned to this excel file. How can I realize this process?

  0 Comments

Sign in to comment.

Answers (1)

Paul Shoemaker
Paul Shoemaker on 16 Aug 2018
Ji Li,
I'm not sure about doing an add-in, but have you considered using the Matlab command "xlsread" to read an Excel spreadsheet, which then feeds your Matlab simulation, and then using the Matlab command "xlswrite" to write results back to an Excel spreadsheet?
The workflow is different than what you described, but may be suitable for your needs.

  1 Comment

Ji Li
Ji Li on 16 Aug 2018
Thank you! This can be a way to get the result. But I hope to call Matlab commands directly in Excel, all the calculations are done behind the scene. I don’t even need to open Matlab.

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!