Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all who kindly choose to read this...
I'm trying to use Excel Link to pull out functions from MATLAB for use in Excel. I'm currently using the matlabsub function provided by Excel Link. I am working directly in the worksheet, and not using VBA code. (My boss, the person who uses this spreadsheet, doesn't like to use VBA. He prefers to work directly in the worksheet cells.) Anyway, I'm running into a snag with this. If I try to pull a function that yields more than one result, e.g. cfamounts(coupon, start date, end date) = [CFlowAmounts, CFlowDates], only the first vector (CFlowAmounts) is showing up in Excel's cells. I won't see the CFlowDates results at all. Does anybody know how to get multiple vectors to populate Excel's cells?? The way I currently have this spreadsheet set up is as follows... =matlabsub(B10,C10, D10,E10,F10) B10 = cfamounts (function name) C10 = P10 (the cell I want the output to begin) D10 = 8.25 (coupon amount) E10 = 31-Jan-2002 (start date) F10 = 31-Jan-2009 (end date) I've tried fiddling with input signifying the output start cell with no luck. The reason I have it set up like this is because I want to be able to pull many different MATLAB functions, mostly user built. I want to be able to specify them as I go. If anybody could help shed some light on this I would be very grateful. Please let me know if I have been unclear about anything, and I will try to correct this. Thanks in advance! Cheers, The Improper Californian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use Excel like Matlab? | Excel Discussion (Misc queries) | |||
Matlab & Excel interface? | Excel Discussion (Misc queries) | |||
Matlab & Excel interface? | Excel Programming | |||
how can ý call matlab function from matlab to excel | Excel Discussion (Misc queries) | |||
VBA with Matlab using Excel Link but not Excel Builder | Excel Programming |