search

poidasmith / xlloop

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

64Bit version of XLL add in #6

Open davidfsmith opened 12 years ago

davidfsmith commented 12 years ago

As per the thread regarding the testing on Excel 2010 do you know when there will be a 64bit version of the XLLoop Excel plugin available to test / use ?

poidasmith commented 12 years ago

Sorry, I don't have an ETA on this since I don't currently have access to a version of Excel 2010.

davidfsmith commented 12 years ago

Out of interest couldn't you use the 30 day trial to do a build ?

I tried doing it myself but ran out of skill / knowledge as it was complaining about some deprecated code and also a missing include (JDK related I think)

poidasmith commented 12 years ago

That might help for the initial version but for any bugs or future versions it would be tricky. So not really an option.

davidfsmith commented 12 years ago

BTW - is there any chance you can do a quick document on how to compile the addin from the source code, hopefully I can then compile a 64bit version and push it back into the project for you (assuming no major issues)

poidasmith commented 12 years ago

There should be no special setup. Just visual studio (2005 and above). Open the solution file and build.

davidfsmith commented 12 years ago

Will give it a try in the next couple of days and report back, thanks again.

davidfsmith commented 12 years ago

Ok I'm stuck on an issue with the build

Error   132 error LNK1112: module machine type 'X86' conflicts with target machine type 'x64'   \xlloop\xlloop-addin\build\msvcrt.lib(chkstk.obj)   XLLoop

After some googling around I didn't get any further but look to have setup my build correctly to Release and x64.

There are also 131 additional warnings to do with deprecated functions (sprintf, strdup, strcpy)

Again any help or thoughts appreciated, I love the XLLoop project and have some handy PHP code talking to a Mongo DB which works great on 32Bit, but I do need 64Bit support. ;-)

poidasmith commented 12 years ago

You'll have to use the visual studio runtime library for 64bit. Same for the other libs here as they are all 32 bit.

Take a look at my other project's build file. It has 32 and 64 bit support: https://github.com/poidasmith/winrun4j/blob/master/WinRun4J/build/WinRun4J.vcproj

mostbit commented 9 years ago

I managed to compile XLLoop for x64 use under Windows 8. I am happy to share the result/upload it if someone's interested in....

poidasmith commented 9 years ago

Yeah, would be interesting to see what code/project/build changes were required to get this working. Perhaps as a patch?

mostbit commented 9 years ago

Great - but how? I am new to this github. should I upload the whole VS2012 project to some place? I have a little list of steps to enhance the former VS2008 (version 0.3.2) project.

petefarmer commented 9 years ago

Hey mostbit, well done for building a 64bit version! I'll be happy to help you test it. I'm stuck on a 64bit machine at the moment which breaks the xlloop add-in. Sadness. It was working brilliantly on the 32bit machine I was using last week. Unfortunately I don't have build enviornment (Visual Studio) on this machine, but I would be so happy to get it running again. Thanks!

zenchanhk commented 9 years ago

Hi mostbit, would you like to send whole project to me via my email: zenchanhk@gmail.com? Thanks a lot!

mostbit commented 9 years ago

Hi, need to find it in my archives... will respond asap.

Am 13.02.2015 um 01:30 schrieb zenchanhk notifications@github.com:

Hi mostbit, would you like to send whole project to me via my email: zenchanhk@gmail.com? Thanks a lot!

— Reply to this email directly or view it on GitHub.

zenchanhk commented 9 years ago

Hi Kay, many thanks for your kind help. Best wishes, Cho Ho 2015/2/13 下午7:17 於 "mostbit" notifications@github.com 寫道：

Hi, need to find it in my archives... will respond asap.

rg km

Kay Moritzen

Am 13.02.2015 um 01:30 schrieb zenchanhk notifications@github.com:

Hi mostbit, would you like to send whole project to me via my email: zenchanhk@gmail.com? Thanks a lot!

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/poidasmith/xlloop/issues/6#issuecomment-74239150.

realkenlee commented 9 years ago

I would love to have a copy as well, why don't you share it on github.

— Sent from Mailbox

On Fri, Feb 13, 2015 at 6:21 AM, zenchanhk notifications@github.com wrote:

Hi Kay, many thanks for your kind help. Best wishes, Cho Ho 2015/2/13 下午7:17 於 "mostbit" notifications@github.com 寫道：

Hi, need to find it in my archives... will respond asap.

rg km

Kay Moritzen

Am 13.02.2015 um 01:30 schrieb zenchanhk notifications@github.com:

Hi mostbit, would you like to send whole project to me via my email: zenchanhk@gmail.com? Thanks a lot!

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/poidasmith/xlloop/issues/6#issuecomment-74239150.

Reply to this email directly or view it on GitHub: https://github.com/poidasmith/xlloop/issues/6#issuecomment-74260135

mostbit commented 9 years ago

You are right - I was about to share it on github but I failed, maybe rare, but I am new to github... Given that people are interested in the results, I will give it another try...

Am 13.02.2015 um 16:34 schrieb realkenlee notifications@github.com:

I would love to have a copy as well, why don't you share it on github.

— Sent from Mailbox

On Fri, Feb 13, 2015 at 6:21 AM, zenchanhk notifications@github.com wrote:

Hi Kay, many thanks for your kind help. Best wishes, Cho Ho 2015/2/13 下午7:17 於 "mostbit" notifications@github.com 寫道：

Hi, need to find it in my archives... will respond asap.

rg

Am 13.02.2015 um 01:30 schrieb zenchanhk notifications@github.com:

Hi mostbit, would you like to send whole project to me via my email: zenchanhk@gmail.com? Thanks a lot!

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/poidasmith/xlloop/issues/6#issuecomment-74239150.

Reply to this email directly or view it on GitHub: https://github.com/poidasmith/xlloop/issues/6#issuecomment-74260135 — Reply to this email directly or view it on GitHub.

mostbit commented 9 years ago

Ok, Sitting in a hotel and my visual studio is not running. For know I cannot do a lot but here at least the adjustments in the win32 project to compile for x64bit.

1) First create yajl for x64. You get the source package lloyd-yajl-1.0.12-0-g17b1790.zip from sourceforge For the compilation take the following options:

2) updating the XLLoop x64: take the win32 project and make the following changes:

get the following LIBs from the internet: --../lib/xlcall32.lib -> get the Excel-SDK from Microsoft (excelxllsdk.msi) for x64bit. After installed copy from the dir "Excel2013XLLSDK/Excel2013XLLSDK/lib/x64" --../lib/msvcrt.lib -> choose option /MT for multithreaded and enter "msvcrt.lib" --../lib/yajl.lib -> compiled new (as mentioned above)

I will follow up with the x64bit-project files once I get my Visual Studio running again.

zenchanhk commented 9 years ago

Hi Kay,

Many thanks again for your so prompt response. But I don't have Visual Studio installed in my computer. I usually use Sharp Developer to develop some programs in C# or IntelliJ for Java programming. It would be better to send me the compiled files at your convenient time. Or the source files will be Ok, I think I can intall the express version of VS to compile it. Thanks again. Have a nice weekend. Cheers, Cho Ho

2015-02-14 3:08 GMT+08:00 mostbit notifications@github.com:

Ok, Sitting in a hotel and my visual studio is not running. For know I cannot do a lot but here at least the adjustments in the win32 project to compile for x64bit.

1) First create yajl for x64. You get the source package lloyd-yajl-1.0.12-0-g17b1790.zip from sourceforge For the compilation take the following options:

  • /D "_CRT_SECURE_NO_WARNINGS"
  • set Include directory for yajl
  • Do not use precompiled headers

2) updating the XLLoop x64: take the win32 project and make the following changes:

  • set Multithreaded (/MT)
  • set pre-processor-def: NO_JAVA;%(PreprocessorDefinitions)
  • switch off Windows Runtime Extensions (!? in german "Erweiterungen")
  • add java (1.7) x64 include dir (right before jni.h/jni_md.h)
  • set inclue Dir XLLoop_x64\src get the following LIBs from the internet:
  • ../lib/xlcall32.lib -> get from "Excel2013XLLSDK/Excel2013XLLSDK/lib/x64" ../lib/msvcrt.lib -> choose option /MT for multithreaded and enter "msvcrt.lib" ../lib/yajl.lib -> compiled new (as mentioned above)

I will follow up with the x64bit-project files once I get my Visual Studio running again.

— Reply to this email directly or view it on GitHub https://github.com/poidasmith/xlloop/issues/6#issuecomment-74308290.

coderofsalvation commented 9 years ago

can anybody put the 64bit up for download please?

Possibilities for people not familiar with github:

herste commented 9 years ago

Would you be so kind to share the 64bit project files? Probably open up a fork on github to share patches, etc.

Thanks alot!

mostbit commented 9 years ago

I generated now a x64 Xlloop and started a "pull request" to commit to github. Please check if my commit was succesfull. As I mentioned above: I am new to github and I tried my very best... Please give me advice if you want me to do any changes.

herste commented 8 years ago

Thanks alot for your help, mostbit. Unfortunately it seems that your repo is even with the master of poidasmith, I cannot see any changes to the project you have made in your master repo. Can you please verify that you have committed all changes to your master branch on github?

btw. - i have seen that you created your pull request against the V0_3_3_BRANCH branch. was that intended or did you do this by accident?

Cheers!

mostbit commented 8 years ago

Yes, my commit to V0_3_3_BRANCH was by accident. My second commit was to master branch. for this I simply cloned the folder "xlloop-addin" and committed it as new folder "xlloop-addin-x64" (not a good way - I know). You should see it in the repository.

herste commented 8 years ago

Hello mostbit,

it seems that you removed your xlloop repo, can you please re-add?

Cheers!

mostbit commented 8 years ago

How is it possible to contact user privately in github? Would it be ok if we first discuss several issues I see offsite? As I mentioned - I am new to github and I do not want to share all my github problems here in public...

herste commented 8 years ago

sure, drop me an email to qwertz@patronas.com ....

mnar53 commented 8 years ago

I've found a package with a subfolder called xlloop-addin-x64. It compiled under Visual Studio 2013, and the 64 bits xll works well with Excel 2013 64bits. Only flaw: a message error when Excel exits, but probably it depends from the python server, and it was already mentioned. Luckily, the server doesn't stop. Unfortunately, I'm not able to track from where I found the package, I suspect it it the one mostbit was working. If it can help to find it, package name when downloaded is xlloop-05d0662f6f5c00586075b6ad91098cce67861c4b.

bernardorusso commented 8 years ago

@mostbit Do you have the 64bit add-in available?

asndev commented 8 years ago

@bernardorusso we've done it and published it here: https://github.com/PATRONAS/xlloop (We've also built a more high level solution which works similar to xlloop but doesn't use low-level C code. You can find it over here: https://github.com/PATRONAS/xlloop )

mnar53 commented 8 years ago

Here is the dll, compiled to 64 bit and with a function table allowing 10000 exposed functions, plus some files

using the python server (with, more or less, the usual packages: numpy, scipy, alglib). Also included an Excel

test workbook (requires the server started before).

Let me know if it works for you: to pass the .sln file and the source tree requires some cleanup that I can't do right now.

Da: Bernardo Russo Guedes notifications@github.com Inviato: lunedì 27 giugno 2016 23.34 A: poidasmith/xlloop Cc: mnar53; Comment Oggetto: Re: [poidasmith/xlloop] 64Bit version of XLL add in (#6)

@mostbithttps://github.com/mostbit Do you have the 64bit add-in available?

You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/poidasmith/xlloop/issues/6#issuecomment-228882751, or mute the threadhttps://github.com/notifications/unsubscribe/AH7JoDYVBg6FjgJ5bMhjNO3cvjWRkrOvks5qQEH2gaJpZM4AC3W7.

rpseng commented 6 years ago

Anybody has a compiled 64bit version working? Apparently this guy https://github.com/PATRONAS/xlloop has the project configured for 64 bit but do not provide compiled releases. I'm really trying to avoid MS Visual Studio...

Thank you in advance.

ivanooi commented 5 years ago

Same here. I'm looking for 64bit as well. Thanks. I will try put that into github if anyone can send me the 64 bit compiled version. Thanks

GijsHu commented 3 years ago

Hi all, I'm also looking for a 64bit compiled file aswell. Is there someone who has it available?