search

poidasmith / xlloop

XLLoop Excel Function (UDF) Server
104 stars 49 forks source link

Problem adding XLL file #5

Closed davidfsmith closed 12 years ago

davidfsmith commented 12 years ago

I'm getting the error 'xlloop-0.3.2.xll is not a valid add-in' when trying to add it using Excel Add-Ins manager.

Additionally i'm hoping to use xlloop to access some PHP code using JSON but can't seem to get anywhere with it, is there a simple how-to you can point me to to help me get started ?

davidfsmith commented 12 years ago

Additionally from looking around is it an issue with Excel 2010 ?

poidasmith commented 12 years ago

There is an example server here: https://github.com/poidasmith/xlloop/blob/master/org.boris.xlloop/servers/php/TestServer.php

There may be an issue with Excel 2010 - I haven't tested this version yet. Are you able to try with an older version to check?

poidasmith commented 12 years ago

Also, FYI there is a PHP server running here: http://xlloop.sourceforge.net/servers/php/TestServer.php

poidasmith commented 12 years ago

Also, set your INI file as below:

protocol=http url=http://xlloop.sourceforge.net/servers/php/TestServer.php log.output.debug.monitor=true log.level=debug

davidfsmith commented 12 years ago

Thanks for the prompt response.

With the exception of the log.output and log.level lines that's what I had for my initial test.

Still not working and sadly the only other version of Excel I have access to is on OSX !

(In case it makes a difference this is failing on Excel 2010 / 64bit) Is there a more recent build of the XLL file than 17/09/2011 ?

poidasmith commented 12 years ago

One thing you also need to check is that Visual Basic for Applications is installed.

Eg, see this thread: http://www.excelbanter.com/showthread.php?t=184569

davidfsmith commented 12 years ago

It is, have just re-checked. I've been doing a load of VBA in Excel already.

Also removed and re-installed office and VBA is installed and I'm still getting the same problem :-(

poidasmith commented 12 years ago

Ok, thanks for reporting. I will try to get hold of a copy of Excel 2010 and debug it.

davidfsmith commented 12 years ago

OK that would be cool, I'm using 64bit throughout with Windows7 and Excel, let me know if you want help with debug / testing builds

poidasmith commented 12 years ago

Are you using the 64bit version of Excel 2010? If so, xlloop won't work since it is a 32bit DLL. It would need a 64bit build for that version.

davidfsmith commented 12 years ago

Guess that explains that issue then :-( I can switch to 32bit for testing but XLLoop but would it be possible to get a 64bit build ?

poidasmith commented 12 years ago

Sure, can do. If you are testing the 32bit version of Excel 2010 could you report back on your success?

davidfsmith commented 12 years ago

Yep will do, just uninstalling 64bit and downloading installing 32bit from MSDN

davidfsmith commented 12 years ago

Ok works perfectly on 32bit Excel 2010 which is a good thing.

Config file is as per post earlier in this thread so using php/TestServer.php

Do you want me to open a separate issue for the .xll file not working on 64bit versions ?