libXLL (and its QuantLib usage)

Posted by Ferdinando M. Ametrano-2 on
URL: http://quantlib.414.s1.nabble.com/libXLL-and-its-QuantLib-usage-tp2428.html

Hi all

I've added Jen's libXLL project code to the current xlw repository, in a
branch called libXLL-branch
libXll does add support for exposing the functions also to VBA, and to
develop COM objects.
Everybody can check out the code from sourceforge using:
cvs -z3 -q update -P -d -r libXLL-branch

There are a couple of problems that need to be solved, and then I'll merge
the libXLL branch into the trunk.
1) in XlfExcel.h Jérôme removed:
>///////////////////
>HINSTANCE hInst_;
>public:
>void DllHandle( HANDLE hDLL);
>HINSTANCE DllHandle() const;
>///////////////////

which was needed by Jens' code in the xllExample:
>BOOL APIENTRY DllMain( HANDLE hModule, DWORD dwReason, LPVOID)
>{
>if( dwReason == DLL_PROCESS_ATTACH)
>XlfExcel::Instance().DllHandle(hModule);
>return TRUE;
>}

I just commented out the DllHandle lines (as per Jens' suggestion), but I
would appreciate any help to fix this.

2) I tried to follow the guidelines on how to setup a project based on
xlw/libXLL (see "Docs/Setting up a project with libXLL.pdf" in the xlw
cvs). I tried with a COM/ATL project called QuantLibXL2. The Debug
configuration does compile and link, but with the "Debug Unicode"
configuration I have the following error:

>Linking...
>    Creating library build\DebugU/QuantLibXL2.lib and object
> build\DebugU/QuantLibXL2.exp
>QuantLibXL2.obj : error LNK2001: unresolved external symbol "public: void
>__thiscall XlfExcel::SendMessageW(char const *)"
>(?SendMessageW@XlfExcel@@QAEXPBD@Z)
>build\DebugU/QuantLibXL2.dll : fatal error LNK1120: 1 unresolved externals
>Error executing link.exe.
>
>QuantLibXL2.dll - 2 error(s), 0 warning(s)

and I connot find SendMessageW anywhere.

With all other configurations I have linking problems. I suspect this might
be because of linking with incompatible libraries. QuantLib (and its
cppunit test-suite) uses multithreaded DLL libraries. Is this the problem?
I could change QuantLib settings, but I should also recompile cppunit. It's
completely obscure to me the real difference between multithreaded and
multithreaded DLL, I just happily found out the the cppunit choice matched
the QuantLib one.
I attach here the QuantLibXL" code. Any help greatly appreciated


-------------

ciao -- Nando

PS the current version of QuantLibXL is in synch with QuantLib and the
libXLL branch. Also the spreadsheets do work