[Quantlib-dev] exposing a new class to Excel

[Misha F. <fo...@gm...>]

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