Posted by
Sinha, Amitesh-3 on
URL: http://quantlib.414.s1.nabble.com/RE-Err-Msg-Not-excel-add-in-format-for-Object-Handler-examples-tp4526p4529.html
We need to bear in mind, automation add-in are supported only on office xp and later version. for the versions below excel xp, I just wrap the function in a COM Coclass and use a VBA wrapper. Although there are tools to auatomataically generate xll from COM idl over the net, I resist the temptation to use xlls these days. Moreever,i can be wrong but Microsoft themselves does not want to promote the use of xlls, it seems to me.
Automation-addins are fairly accessible these days and are esp useful if you need to access COM exposed function from excel cell. There are many good references on these things and I would be repeating if I launch into a detailed explanations here..I will just list some good links to get started.
1.
http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx shows how to create a sample automation add-in, we cause expose our quantlib functions via a dll and access it
through C# using dllimport attribute. I do not think wrapping will slow down computations materially as they
still are done in quantlib's c++ compiled code.
2.
http://msdn2.microsoft.com/en-us/library/ms173189.aspx
However, for the office versions prior to office xp, I would simply make a com Add-in and wrap the functions in VBA.
Lots of firms eg matlab follow the approach outlined above. Microsoft also recommends using VBA wrapper for interfaces exposed through COM.
Regards
Amitesh
-----Original Message-----
From:
[hidden email]
[mailto:
[hidden email]]On Behalf Of Jerry
Jie Ji
Sent: Wednesday, March 01, 2006 10:36 AM
To: Sinha, Amitesh
Cc:
[hidden email]
Subject: RE: [Quantlib-users] Err Msg "Not excel add-in format" for
Object Handler examples
Whoa, such detailed answer really warrant its place in an FAQ. While I
crash through the material mentioned, could you please share with us
more on the automation add-in function/technology?
Thanks and regards,
Jerry
-----Original Message-----
From: Sinha, Amitesh [mailto:
[hidden email]]
Sent: Wednesday, March 01, 2006 9:44 AM
To: Jerry Jie Ji
Subject: RE: [Quantlib-users] Err Msg "Not excel add-in format" for
Object Handler examples
If you have excel 2003, why do not you use automation add-in to expose
the functions directory from quantlib library. XLL technology is getting
deprecated. Most of your efforts are likely to be lost in coming years.
Having said that, the following pointers may be of interest to you.
1.
http://www.planatechsolutions.com/xlpfaq/Q0011.htm essentially open your xll in visual studio tool "depends" and
see if any dll xll depends on is missing. I suspect log4cxx , oh dll
may not be in the path. If you do not have depends, go to
www.dependencywalker.com.
2. I am hoping that you are not mixing managed C++ and unmanaged C++ as
string in managed C++ are treating differently. Most likely you are
not doing this.
3. If point 1 does not rescue you, you may be mixing debug/release
libraries, just check that you are not doing this.
4. Using DumpBin /Exports should list the DLLs bound statically to your
code. You need to ensure they are in your
path, and not just lying around the target machine.
If you are familiar with COM, you might want to consider making
automation add-in. xlls are painful and deprecated technology. I just
use C# wrapper of C++ dlls. I even avoid explicit COM programming.
let me know if the problem goes away.
Regards
Amitesh Sinha
Valuation Risk Group
CREDIT SUISSE
Phone: +852-2101-6643
Mobile: +85267737571
email:
[hidden email]
-----Original Message-----
From:
[hidden email]
[mailto:
[hidden email]]On Behalf Of Jerry
Jie Ji
Sent: Wednesday, March 01, 2006 8:57 AM
To:
[hidden email]
Subject: RE: [Quantlib-users] Err Msg "Not excel add-in format" for
ObjectHandler examples
Similar problem here, just that I'm using MS VC++ 2005 Express (8)
and MS Excel (Office) 2003.
Many thanks in advance!
--
Jerry
Singapore
-----Original Message-----
From:
[hidden email]
[mailto:
[hidden email]] On Behalf Of Liu,
Xiaobo
Sent: Wednesday, March 01, 2006 6:43 AM
To:
[hidden email]
Subject: [Quantlib-users] Err Msg "Not excel add-in format" for
ObjectHandler examples
> Hi,
>
> I complied both latest versions of ObjectHandler
> and QuantlibAddin, but could not load up
> any *.xll files due to error msg stating that
> the xll files are NOT of Excel add-in format.
>
> I am using MSVC++ 6.0 and Excel 2000,
and would greatly appreciate any help on this.
> Regards,
> Xiaobo Liu
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
<a href="http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642">http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642
_______________________________________________
Quantlib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-usersCONFIDENTIAL NOTE: The information contained in this email is intended
only for the use of the individual or entity named above and may contain
information that is privileged, confidential and exempt from disclosure
under applicable law. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication is strictly prohibited. If you have
received this message in error, please immediately notify the sender and
delete the mail.
Thank you.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642_______________________________________________
Quantlib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users========================================================================
======
Please access the attached hyperlink for an important electronic
communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html========================================================================
======
CONFIDENTIAL NOTE: The information contained in this email is intended only for the use of the individual or entity named above and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete the mail.
Thank you.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642_______________________________________________
Quantlib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html==============================================================================