Posted by
Liu, Xiaobo on
URL: http://quantlib.414.s1.nabble.com/RE-Err-Msg-Not-excel-add-in-format-for-Object-Handler-examples-tp4526p4528.html
Now it is working, following steps in Eric's email:
(1)Ran www.dependencywalker.com to see what were missing in my *.xll
(2)Added ObjectHandler-vc6-mt-gd-0_1_2.xll in my system path.
Your help is greatly appreciated!
(I should have gone through the trouble shooting section in QL more
carefully.)
Regards,
Xiaobo
-----Original Message-----
From: eric ehlers [mailto:
[hidden email]]
Sent: Wednesday, March 01, 2006 4:15 AM
To: Sinha, Amitesh
Cc: Jerry Jie Ji; Liu, Xiaobo;
[hidden email]
Subject: Re: [Quantlib-users] Err Msg "Not excel add-in format" for
Object Handler examples
Hi All,
To clarify:
- ObjectHandler and QuantLibAddin are supported subprojects of
QuantLib, implemented using the Excel C API (XLLs)
- Liu and Jerry are troubleshooting a QuantLibAddin error message
- Amitesh is talking about scrapping ObjectHandler and QuantLibAddin
altogether and implementing something new in a different technology
e.g. automation
Let me address these issues separately:
1) "Addin not in Excel format" error message from QuantLibAddin
On 2/28/06, Liu, Xiaobo <
[hidden email]> wrote:
> > 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.
On 3/1/06, Jerry Jie Ji <
[hidden email]> wrote:
> Similar problem here, just that I'm using MS VC++ 2005 Express (8)
> and MS Excel (Office) 2003.
On 3/1/06, Sinha, Amitesh <
[hidden email]> wrote:
> 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.
Please see also:
http://quantlib.org/quantlibaddin/troubleshooting.html#startup_error