Hi Adjriou
>In my laptop , the xll works fine because I have Visual C++, but in my >desk, I just have Excel and >and when I open the xll, i Have a message error. which error message. what is you xll? is it QuantLibXL? >What libraries do I need to make it run without Visual C++ ? the error message might be telling you that. ciao -- nando |
> In my laptop , the xll works fine because I have Visual C++, but in my desk,
> I just have Excel and > and when I open the xll, i Have a message error. > What libraries do I need to make it run without Visual C++ ? In the simplest case an xll has no external dependencies - you start Excel, load the xll, and away you go. If your xll stops working when you install it on a non-development machine, I'd suspect one of two problems 1) you've compiled the xll in such a way as to create a run-time dependency. For example, you linked the xll to some lib such that the xll depends on the corresponding dll at runtime 2) There's some other difference between your dev box and the box you installed to - for example different versions of Excel - xlls can be flaky about different versions of Excel and not all of the differences are documented, debugging is the only way. Regards Eric |
In reply to this post by Ferdinando M. Ametrano-3
We've
come across this problem with xlls built under visual C++ .net . There are a
couple of dlls that the xll requires and returns
a
library not recognized error if you don't have them.
the
relevant ones may be mscvp70.dll
mscvi70.dll
msvcr70.dll
regards
Mark
*********************************************************************************** The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. Authorised and regulated by the Financial Services Authority This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate. Visit our websites at: http://www.rbs.co.uk/CBFM http://www.rbsmarkets.com ******************************************************************************** |
In reply to this post by Ferdinando M. Ametrano-3
I have had this kind of problems in a lot of situations, and then I found a
tool that just shows you all the dependencies of a dll so that you quickly find out what you're missing. http://www.dependencywalker.com/ It's free and it works. :-) My guess is that you have a run-time dependency on a version of the C or C++ runtime library which versions are different on the two machines. But this is just speculation: start the dependency walker and you'll know exactly.. :-) -Daniele -----Original Message----- From: eric ehlers [mailto:[hidden email]] Sent: Wednesday, February 09, 2005 5:41 PM To: Adjriou Belak Cc: [hidden email]; [hidden email] Subject: Re: [Quantlib-users] what do I need to make run an xll ? > In my laptop , the xll works fine because I have Visual C++, but in my > desk, I just have Excel and and when I open the xll, i Have a message > error. What libraries do I need to make it run without Visual C++ ? In the simplest case an xll has no external dependencies - you start Excel, load the xll, and away you go. If your xll stops working when you install it on a non-development machine, I'd suspect one of two problems 1) you've compiled the xll in such a way as to create a run-time dependency. For example, you linked the xll to some lib such that the xll depends on the corresponding dll at runtime 2) There's some other difference between your dev box and the box you installed to - for example different versions of Excel - xlls can be flaky about different versions of Excel and not all of the differences are documented, debugging is the only way. Regards Eric |
In reply to this post by JOSHI, Mark, Group Risk Mgmt
On 02/10/05 10:20:51, JOSHI, Mark, Group Risk Mgmt wrote:
> We've come across this problem with xlls built under visual C++ .net . > There are a couple of dlls that the xll requires and returns > a library not recognized error if you don't have them. Mark, did you download the xll binaries, or did you build it yourself? In the latter case, you might want to try changing some compilation settings. I don't have .NET, but there should be a project setting (on VC6 it used to be under 'C++/Code generation') letting you choose the run-time library to use. You should have the alternative between depending on DLLs or linking the run-time library statically. Hope this helps, Luigi ---------------------------------------- Weiler's Law: Nothing is impossible for the man who doesn't have to do it himself. |
In reply to this post by eric ehlers
Hi,
I've used QuantLibAddin to build a couple of spreadsheet for training purposes. I've added a handful of functions: + a function qlXiborFixing to retrieve the fixing of an index + two functions qlRateHelperImpliedQuote, qlRateHelperQuoteError to retrieve the implied quote and the error of a rate helper + a constructor qlForwardSpreadedTermStructure to build a curve with a given spread + a constructor qlForwardCurve for a piecewise-constant forward curve starting from the given forward rates Should I commit these additions? Also, I would like to use the advance method of calendars and the yearFraction method of day counters. Is it possible, in the framework of QuantLibAddin, to use these as functions without having to export the Calendar/Day counter constructor? If so, how do you do that? Marco Marco Marchioro StatPro Italia Phone: +39 02 4331 7497 Fax: +39 02 4391 1424 www.StatPro.com |
Hi Marco,
> I've used QuantLibAddin to build a couple of spreadsheet for training > purposes. > I've added a handful of functions: Fantastic. > Should I commit these additions? That would be much appreciated. I've just completed a large batch of enhancements to the srcgen script so unfortunately your code will probably need some updates to bring it in line with CVS. > of day counters. Is it possible, in the framework of QuantLibAddin, to use > these > as functions without having to export the Calendar/Day counter constructor? > If so, how do you do that? In a metadata file having headerOnly='true' you define your functions with class Procedure. Then somewhere under qla you implement a wrapper for the QuantLib function. For examples of this please see srcgen/utilities.xml qla/utilites.cpp Regards, Eric |
The add-in source code need to handle the xlAutoClose callback. added to the bug reporting tool http://sourceforge.net/tracker/index.php?func=detail&aid=1392393&group_id=12740&atid=112740 Regards Lars
Yahoo! for Good - Make a difference this year. |
Hi Lars,
> The add-in source code need to handle the xlAutoClose > callback. In theory you would implement the xlAutoClose function and there call xlfUnregister for each of an XLL's functions. However xlfUnregister is broken so in practice Excel provides no mechanism to unregister functions. The only reason to implement xlAutoClose would be if there were other resources that needed to be released which is not the case for QuantLibAddin. Regards, Eric |
In reply to this post by eric ehlers
Hi,
I finished the development of the few additional functions under QuantLibAddin. I've modified the dsp for Visual Studio 6 and the makefiles. I've added a new category "basic" with the function necessary to advance a calendar and to compute an year fraction. I'll commit the code and wait for comments. Ciao, Marco At 08:27 PM 2005-12-23, eric ehlers wrote: >Hi Marco, > > > I've used QuantLibAddin to build a couple of spreadsheet for training > > purposes. > > I've added a handful of functions: > >Fantastic. > > > Should I commit these additions? > >That would be much appreciated. I've just completed a large batch of >enhancements to the srcgen script so unfortunately your code will >probably need some updates to bring it in line with CVS. > > > of day counters. Is it possible, in the framework of QuantLibAddin, to use > > these > > as functions without having to export the Calendar/Day counter constructor? > > If so, how do you do that? > >In a metadata file having headerOnly='true' you define your functions >with class Procedure. Then somewhere under qla you implement a >wrapper for the QuantLib function. For examples of this please see >srcgen/utilities.xml >qla/utilites.cpp > >Regards, >Eric > > >------------------------------------------------------- >This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >for problems? Stop! Download the new AJAX search engine that makes >searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >http://ads.osdn.com/?ad_idv37&alloc_id865&opick >_______________________________________________ >Quantlib-dev mailing list >[hidden email] >https://lists.sourceforge.net/lists/listinfo/quantlib-dev Marco Marchioro Head of Product Development StatPro Italia Phone: +39 02 4331 7497 Fax: +39 02 4391 1424 www.StatPro.com |
Hi Marco
> I'll commit the code and wait for comments. All looks good to me. Random thoughts - - I confirmed that it all works under Calc/Linux - Your "basic" stuff offers a new approach for direct access to general QuantLib functionality and I'm sure this feature will prove useful Many thanks for your contribution. Regards, Eric |
Free forum by Nabble | Edit this page |