RE: quantLib and Excel

Posted by Bernd J Wuebben on
URL: http://quantlib.414.s1.nabble.com/quantLib-and-Excel-tp1897p1900.html

This is what I was talking about a few weeks back Nando, when
you asked me about how to go about the Excel implementation. Jens
is 100% on the money with his remarks. IDL/COM is the way
to go, especially because it allows you to pump data into
Excel

Jens, I would love to see your work!
Thanks!
Bernd
 

> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]] On Behalf
> Of Jens Thiel
> Sent: Friday, March 15, 2002 6:38 AM
> To: [hidden email]
> Cc: [hidden email]
> Subject: Re: [Quantlib-users] quantLib and Excel
>
>
>
> Hello,
>
> we are using our own C++ library, where functions are defined
> in IDL and
> then automatically exported as Add-In worksheet functions --
> together with
> all the necessary hints for the function wizard. This should
> work with all
> current and previous Excel versions.
>
> The exported functions are not only available to Excel
> workbooks, but to
> every application that understands a TypeLib. There are also
> some helpers
> to manually register functions, which is not TypeLib
> compatible. Starting
> with Excel 2002, it is generally possible to use COM/IDL to
> write worksheet
> functions -- and I think it will be the preferred way.
>
> If anyone wants to try it out send me a PM, and I'll wrap it
> up together
> with a few examples.
>
>
> Jens.
>
>
> > I've started toying with an Excel interface for QuantLib, and I
> > followed  Bernd's suggestion:
> >>                         http://www.ifrance.com/xlw/
> >>
>
>
>
>
> _______________________________________________
> Quantlib-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-users
>