QuantLib › quantlib-users

QuantLibXL installation

Classic

List

Threaded

6 messages Options

letian

QuantLibXL installation

Hello,

I'm not sure if this has been asked but I have a basic question about the excel add-in installation error as:

"c:Program Files (x86)\QuantLibXL-1.1.0\xll\QuantLib-vc90-mt-s-1_1_0xll" is not a valid add-in

Does anyone know how to fix it? Thank you very much for the help.

I downloaded and installed the QuantLibXL-bin-1.1.0.exe. My excel is Office Professional Plus 2010. I also have Visual C++ 2010 installed but I guess it is not relevant here.

Letian

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

Eric Ehlers-2

Re: QuantLibXL installation

Hello,

On 2012-07-31 01:41, letian wang wrote:

> Hello,
>
> I'm not sure if this has been asked but I have a basic question about
> the excel add-in installation error as:
> "c:Program Files (x86)QuantLibXL-1.1.0xllQuantLib-vc90-mt-s-1_1_0xll"
> is not a valid add-in
>
> Does anyone know how to fix it? Thank you very much for the help.
>
> I downloaded and installed the QuantLibXL-bin-1.1.0.exe. My excel is
> Office Professional Plus 2010. I also have Visual C++ 2010 installed
> but I guess it is not relevant here.
>
> Letian

You're right, whether or not Visual C++ is installed should not be
relevant for the binary installation of QuantLibXL. Likewise the XLL
should not have any dependencies on any other DLLs since it was compiled
against the static runtime.

Do you have the 32- or 64-bit version of Excel 2010? Could there be a
problem with your trust center settings? Do you get the same error
whether you load the XLL from the addin manager, or open it as a normal
file? Can you try the installation on another machine?

Regards,
Eric
--
===================================================
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
* Distributed computing for pricing analytics
* Use Microsoft Excel as a client to the Grid

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

letian

Re: QuantLibXL installation

Hi Eric,

Thanks for the reply. I downloaded the file directly from

http://quantlib.org/quantlibxl/

and installed it along with the framework option.

It's excel 2010 64bit. Yes it might be an issue related to trust center. When I tried to open ..\framework\QuantLibXL.xla, it popped up a warning saying "This CA Root certificate is not trusted" and installing the certificate didn't give any help.

A different problem occurred when I tried to open framework2. It went directly to the VBA editor with a compile error message "The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute".

Finally when I load the ..\xll\QuantLibXL-vc90-mt-s-1_1_0.xll from the addin manager, excel complains that it is not a valid add-in. If I open it directly by doubling clicking the file, Excel displays it in some unreadable format.

OK. That is the situation when I tried to open these three files. Any suggestion? Thank you very much.

Letian

De : Eric Ehlers <[hidden email]>
À : [hidden email]
Envoyé le : mardi 31 juillet 2012 13h00
Objet : Re: [Quantlib-users] QuantLibXL installation

Hello,

On 2012-07-31 01:41, letian wang wrote:

Eric Ehlers-2

Re: QuantLibXL installation

Hi Letian,

On 2012-08-02 12:53, letian wang wrote:

> Hi Eric,
>
> Thanks for the reply. I downloaded the file directly from
> http://quantlib.org/quantlibxl/ [1]
>
> and installed it along with the framework option.
>
> It's excel 2010 64bit. Yes it might be an issue related to trust
> center. When I tried to open ..frameworkQuantLibXL.xla, it popped up
> a
> warning saying "This CA Root certificate is not trusted" and
> installing the certificate didn't give any help.
>
> A different problem occurred when I tried to open framework2. It went
> directly to the VBA editor with a compile error message "The code in
> this project must be updated for use on 64-bit systems. Please review
> and update Declare statements and then mark them with the PtrSafe
> attribute".
>
> Finally when I load the ..xllQuantLibXL-vc90-mt-s-1_1_0.xll from the
> addin manager, excel complains that it is not a valid add-in. If I
> open it directly by doubling clicking the file, Excel displays it in
> some unreadable format.
>
> OK. That is the situation when I tried to open these three files. Any
> suggestion? Thank you very much.

Regarding the XLL, I think the problem is simply that the XLL is
compiled for 32-bit and cannot be loaded in 64-bit Excel. The solution
would be to recompile the XLL for 64-bit, I do not know how involved
that is.

I know less about the VBA side but the error message you got is a
pretty good indication, it seems the VBA code needs modification for use
in 64-bit Excel. The VBA addin depends on the XLL addin so the XLL
would have to be upgraded first.

Everybody that I know is still on 32-bit Excel and I guess one reason
is that nobody is in a hurry to tackle these migration problems.

Regards,
Eric
--
===================================================
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
* Distributed computing for pricing analytics
* Use Microsoft Excel as a client to the Grid

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

letian

Re: QuantLibObjects Excel addin: QL gensrc error

Hi All,

Eric, I think you are right about the 32bit Excel addin. I have only 64bit though so I'm trying to compile one from the source, step by step. So far everything is fine until qlgensrc (btw ohgensrc is fine) there is a gensrc error as follows. I know little about python. Does anyone know how to handle this? Thank you very much.

Regards,

Letian

--------- Error Message Attached --------------------

1> if not exist build\vc mkdir build\vc

1> ..\..\gensrc\gensrc.py -a --oh_dir=..\..\ObjectHandler

1> begin ...

1> begin generating Excel...

1> >

1> > gensrc has encountered a fatal error.

1> >

1> > >>>>>>>>>> BEGIN STACK TRACE >>>>>>>>>>

1> >

1> > File "C:\build_ql_1_1_0\gensrc\gensrc.py", line 125, in <module>

1> > addinList.generate()

1> > File "C:\build_ql_1_1_0\gensrc\gensrc\addins\addinlist.py", line 74, in generate

1> > self.generateCode()

1> > File "C:\build_ql_1_1_0\gensrc\gensrc\addins\addinlist.py", line 83, in generateCode

1> > addin.generate(self.categoryList_, self.enumerationList_)

1> > File "C:\build_ql_1_1_0\gensrc\gensrc\addins\excel.py", line 100, in generate

1> > self.generateAddin()

1> > File "C:\build_ql_1_1_0\gensrc\gensrc\addins\excel.py", line 270, in generateAddin

1> > self.generateRegisterFunctions(cat)

1> > File "C:\build_ql_1_1_0\gensrc\gensrc\addins\excel.py", line 255, in generateRegisterFunctions

1> > self.outputRegisterFile(registerCode, unregisterCode, cat.name())

1> > File "C:\build_ql_1_1_0\gensrc\gensrc\addins\excel.py", line 243, in outputRegisterFile

1> > outputfile.OutputFile(self, registerFile, self.copyright_, self.bufferRegisterFile_)

1> > File "C:\build_ql_1_1_0\gensrc\gensrc\utilities\outputfile.py", line 89, in __init__

1> > self.outFile_ = file(self.fileNameTemp_, 'w')

1> >

1> > <<<<<<<<<< END STACK TRACE <<<<<<<<<<

1> >

1>EXEC : > gensrc error :

1> > [Errno 2] No such file or directory: u'C:\\build_ql_1_1_0\\QuantLibXL\\qlxl/register/register_abcd.cpp.temp'

1> >

1>> NMAKE : fatal error U1077: '..\..\gensrc\gensrc.py' : return code '0x1'

1> Stop.

1>C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\Microsoft.MakeFile.Targets(43,5): error MSB3073: The command "NMAKE /f Makefile.vc /a" exited with code 2.

========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========

Eric Ehlers-2

Re: QuantLibObjects Excel addin: QL gensrc error

Hi Letian,

Looks like it is having trouble accessing the filesystem.

Here I tried deleting directory
C:\build_ql_1_1_0\QuantLibXL\qlxl\register and I get the exact same
error as you.

The autogenerated files are included in the release and it should not
be necessary for you to recreate them yourself. When you first install
the release, is your C:\build_ql_1_1_0\QuantLibXL\qlxl\register present,
does it contain the autogenerated files? After you unpackaged the
release, could something have gone wrong to cause the error?

Regards,
Eric

On 2012-08-08 13:55, letian wang wrote:

> Hi All,
>
> Eric, I think you are right about the 32bit Excel addin. I have only
> 64bit though so I'm trying to compile one from the source, step by
> step. So far everything is fine until qlgensrc (btw ohgensrc is fine)
> there is a gensrc error as follows. I know little about python. Does
> anyone know how to handle this? Thank you very much.
>
> Regards,
> Letian
>
> --------- Error Message Attached --------------------
>
> 1> if not exist buildvc mkdir buildvc
> 1> ....gensrcgensrc.py -a --oh_dir=....ObjectHandler
> 1> begin ...
> 1> begin generating Excel...
> 1> >
> 1> > gensrc has encountered a fatal error.
> 1> >
> 1> > >>>>>>>>>> BEGIN STACK TRACE >>>>>>>>>>
> 1> >
> 1> > File "C:build_ql_1_1_0gensrcgensrc.py", line 125, in <module>
> 1> > addinList.generate()
> 1> > File "C:build_ql_1_1_0gensrcgensrcaddinsaddinlist.py", line 74,
> in generate
> 1> > self.generateCode()
> 1> > File "C:build_ql_1_1_0gensrcgensrcaddinsaddinlist.py", line 83,
> in generateCode
> 1> > addin.generate(self.categoryList_, self.enumerationList_)
> 1> > File "C:build_ql_1_1_0gensrcgensrcaddinsexcel.py", line 100, in
> generate
> 1> > self.generateAddin()
> 1> > File "C:build_ql_1_1_0gensrcgensrcaddinsexcel.py", line 270, in
> generateAddin
> 1> > self.generateRegisterFunctions(cat)
> 1> > File "C:build_ql_1_1_0gensrcgensrcaddinsexcel.py", line 255, in
> generateRegisterFunctions
> 1> > self.outputRegisterFile(registerCode, unregisterCode,
> cat.name())
> 1> > File "C:build_ql_1_1_0gensrcgensrcaddinsexcel.py", line 243, in
> outputRegisterFile
> 1> > outputfile.OutputFile(self, registerFile, self.copyright_,
> self.bufferRegisterFile_)
> 1> > File "C:build_ql_1_1_0gensrcgensrcutilitiesoutputfile.py", line
> 89, in __init__
> 1> > self.outFile_ = file(self.fileNameTemp_, 'w')
> 1> >
> 1> > <<<<<<<<<< END STACK TRACE <<<<<<<<<<
> 1> >
> 1>EXEC : > gensrc error :
> 1> > [Errno 2] No such file or directory:
> u'C:\build_ql_1_1_0\QuantLibXL\qlxl/register/register_abcd.cpp.temp'
> 1> >
> 1>> NMAKE : fatal error U1077: '....gensrcgensrc.py' : return code
> '0x1'
> 1> Stop.
> 1>C:Program Files
> (x86)MSBuildMicrosoft.Cppv4.0Microsoft.MakeFile.Targets(43,5): error
> MSB3073: The command "NMAKE /f Makefile.vc /a" exited with code 2.
> ========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========

--
===================================================
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
* Distributed computing for pricing analytics
* Use Microsoft Excel as a client to the Grid

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users