I have a ubuntu 11.10 system running winxp on virtualbox. I will use xlloop to use python functions in excel. I would like to have the python server running under linux. I have a xlloop.ini file with:
providers=Python
include.volatile=true
server=my-laptop:5460
function.name=Python
On the WinXP virtual machine I can ping my-laptop but excel reports it cannot find the server.
When I run the server with the python on the WinXP vm and replace my-laptop with localhost all is working fine.
Can it be done? and is there a how-to?
Many thanks, janwillem
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Xlloop uses the standard windows (winsock) api so it should work. Could you try a simple telnet to that host/port to see if that connection succeeds? Your configuration/ini setup looks fine.
Thanks,
Peter
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I find that if I run VirtualBox in bridge mode it works fine, yet iin NAT mode it fails. In both cases I can telnet into the relevant port from the VM itself.
Unfortunately using bridge mode is not ideal though as the target IP changes each time the host machine moves to a different network.
I don't suppose anyone figured this out...?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I managed to work around this by starting an ssh tunnel from my VM to host machine, mapping 5454 on the VM to 5454 on the server. Then I can simply configure Excel to point at localhost:5454.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a ubuntu 11.10 system running winxp on virtualbox. I will use xlloop to use python functions in excel. I would like to have the python server running under linux. I have a xlloop.ini file with:
providers=Python
include.volatile=true
server=my-laptop:5460
function.name=Python
On the WinXP virtual machine I can ping my-laptop but excel reports it cannot find the server.
When I run the server with the python on the WinXP vm and replace my-laptop with localhost all is working fine.
Can it be done? and is there a how-to?
Many thanks, janwillem
Hi,
Xlloop uses the standard windows (winsock) api so it should work. Could you try a simple telnet to that host/port to see if that connection succeeds? Your configuration/ini setup looks fine.
Thanks,
Peter
This issue is the same as the one I'm trying to work through here: https://sourceforge.net/p/xlloop/discussion/802204/thread/a1e80064/
I find that if I run VirtualBox in bridge mode it works fine, yet iin NAT mode it fails. In both cases I can telnet into the relevant port from the VM itself.
Unfortunately using bridge mode is not ideal though as the target IP changes each time the host machine moves to a different network.
I don't suppose anyone figured this out...?
I managed to work around this by starting an ssh tunnel from my VM to host machine, mapping 5454 on the VM to 5454 on the server. Then I can simply configure Excel to point at localhost:5454.