exposing a new class to Excel

Posted by Misha Fomytskyi on
URL: http://quantlib.414.s1.nabble.com/exposing-a-new-class-to-Excel-tp9588.html

I have two questions regarding exposing complex data structures to Excel using QuantLibXL.

1) If I have a class MyClass, what is the easiest way to create an instance of it in Excel and use it?
    First I want to create an instance of an object ( get a pointer into excel cell), then modify the object, then call some function on the object.
    Basically, could you point me to the simplest example, which can exercise the following interface in Excel:
    class MyClass
    {
       public:
         MyClass( double x );
         void change( double z);
         double get() const;
    }


2) I need to create a function, which returns a lot of stuff. Not all the stuff will be used all the time. Ideally, I would return a value of type ObjectHandler::ValueObject into Excel (map from string to any), then get only the fields I need at the time. The fields may be dynamic, e.g. value is always calculated, but greeks and diagnostic information are optional. Could you point me to an example of how I can create such a function?

Many thanks in advance!

Misha

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev