Using MATLAB Optimization toolbox functions in Excel
3 views (last 30 days)
Show older comments
Hi, I'm trying to get matlab optimization functions (like fmincon) to work in an excel sheet just like the excel solver. The challenge is these functions require functions as one of their input arguments so i need them to see a cell range as a function not just an variable. I've tried Spreadsheet link EX and MATLAB Builder Ex but I don't seem to be making a headway.
I'll appreciate any useful suggestions.
Thanks
0 Comments
Answers (1)
Matt J
on 12 Apr 2013
Edited: Matt J
on 12 Apr 2013
Well, you could call xlsread and xlswrite inside your objective function to access the spreadsheet, but that seems rather inefficient. It's unclear why you wouldn't just read your Excel data into MATLAB and work from there.
2 Comments
Matt J
on 12 Apr 2013
Since your simulator writes data to Excel via a process similar to xlswrite, it's hard to imagine you'd increase your data communication time by an order of magnitude by calling xlsread/write once per data set. Also, since FMINCON is iterative, I'd expect it could be your computational bottleneck anyway.
See Also
Categories
Find more on Data Export to MATLAB in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!