Re: [Quantlib-dev] QuantLibXL function in Excel, limit in number of arguments?

[willshaw <wil...@gm...>]

Hi, to expose a function to Excel, I first define the function interface in
project "QuantLibObjects" under namespace QuantLibAddin, it should call the
real function in QuantLib, then edit the xml in project "qlgensrc", then
compile. No edit of autogenerated files. I use Excel 2003. 

Regards,



Eric Ehlers-2 wrote:
> 
> Hello,
> 
> There is a limit of 20 arguments to QuantLibXL functions.  I
> have added a new item in the FAQ to document this issue:
> 
> http://quantlib.org/quantlibaddin/faq.html#faq_item_numparams
> 
> I cannot explain why you are hitting a limit of 15.  How are
> you going about adding the additional arguments?  Are you
> editing the XML function metadata for gensrc?  Or are you
> manually editing the C++ source files that were autogenerated
> by gensrc?
> 
> Regards,
> Eric
> 
> On Tue, July 15, 2008 13:59, willshaw wrote:
>>
>> Hi,
>>
>> It seems that the function exposed to Excel by QuantLibXL has
> a
>> limit in
>> number of arguments, 15. If I have more than 15 arguments in
>> function,
>> although I can compile xll successfully, when I click the
>> function in Excel,
>> nothing happens. But if I reduced the arguments to less than
> 15
>> without
>> doing anything else, it works.
>>
>> Any idea?
>>
>> Thanks.
>> --
>> View this message in context:
>> http://www.nabble.com/QuantLibXL-function-in-Excel%2C-limit-in-number-of-arguments--tp18464649p18464649.html
> Sent from the quantlib-dev mailing list archive at
> Nabble.com.
>>
>>
>> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move
>> Developer's challenge
>> Build the coolest Linux based applications with Moblin SDK &
>> win great prizes
>> Grand prize is a trip for two to an Open Source event
> anywhere
>> in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> QuantLib-dev mailing list
>> Qua...@li...
>> https://lists.sourceforge.net/lists/listinfo/quantlib-dev
>>
> 
> 
> -------------------------
> Eric Ehlers
> nazcatech sprl | Brussels | http://www.nazcatech.be
> Distributed computing for pricing analytics - Use Microsoft
> Excel as a client to the Grid
> 
> 
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the
> world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> QuantLib-dev mailing list
> Qua...@li...
> https://lists.sourceforge.net/lists/listinfo/quantlib-dev
> 
> 

-- 
View this message in context: http://www.nabble.com/QuantLibXL-function-in-Excel%2C-limit-in-number-of-arguments--tp18464649p18602057.html
Sent from the quantlib-dev mailing list archive at Nabble.com.