Installing openpyxl on a machine that is off the internet.

[guanac...@gmail.com]

Hello all, 

Before I begin, this issue is urgent to my situation, but I know I am not special or deserve special attention. That being said, any immediate help is greatly greatly appreciated!

For security reasons at my current job, our dev machines are offline. I have just taken on a new project of converting old VBA script to python scripts and I need to get python on my windows machine (offline).

What I have does thus far: I have downloaded python 2.7.16 which is a .msi file to run on windows. AND I have also downloaded the openpyxl 2.6.2 source files (the .tar) files. 

I want to install python and be able to use openpyxl package in my development. I will be also installing another package named pyinstaller which takes a python project and bundles it into an executable for use on other machines. 

I want to ensure that I will be able to install and use everything, but I do not know how to do this. I have searched around but haven't found a whole lot on installing packages locally on a machine without internet. To clarify, I downloaded the packages on another machine with internet, and transferred those files to the development machine, but now I need to set up a working python environment with the packages installed. 

Thank you in advanced,

Please help!

[Charlie Clark]

I recently had to help someone in a similar situation. You can download
the Zip files from pypi and install using them. You'll need openpyxl,
jdcal and et_xmlfile, though lxml is preferable. For lxml you should be
able to download a wheel for your system.

You can install from zipfiles directly using easy_install. Otherwise you
just need to unzip the files and run the setup.py. Or you could create
your own wheels from the zipfiles and use those.

Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226

[jreyes]

UPDATE:

I am mostly concerned with dependencies and how to go about that. Also F.Y.I python 2.7.16 comes with pip just incase that makes a difference.

[jreyes]

 

Thanks Charlie, do I need to do anything for dependencies? Also I think I am going to go with the setup.py option which seems the easiest at the moment. 

[Charlie Clark]

Am .07.2019, 16:16 Uhr, schrieb jreyes <guanac...@gmail.com>:

> Thanks Charlie, do I need to do anything for dependencies? Also I think I
>> am going to go with the setup.py option which seems the easiest at the
>> moment.

jdcal and et_xmlfile are the only hard dependencies. Both are pure Python
libraries and can be installed in the same way. If wheels are available
for any package, then these can be installed directly using pip.

[Biru Singh]

Hi Guana,

Installing python won't be issue as you have msi file.It is just a normal installation process like other software.But, provide the proper path for python environment variable, that is the only concern.

To check python path is set properly, just type python on CMD, then it should launch your python.

And for openpyxl , you have tar file which has to be untarred and then open a CMD with the folder path of openpyxl having setup.py file. Then just type python setup.py install , your package will be installed.

To verify, just type pip list, it must show the openpyxl package name.

And last thing conversion to executable file.Refer to Google, hell lot of examples which are working.

Cheers,

Reply if still facing issue.

--
You received this message because you are subscribed to the Google Groups "openpyxl-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openpyxl-user...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/openpyxl-users/48008665-4683-4937-978d-e7b6c2148a4c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[jreyes]

Hey Biru,

going to give things a try this morning and return if I need help. Thanks for your help so far, I appreciate it. Plan to get everything running today.

Thanks

To unsubscribe from this group and stop receiving emails from it, send an email to openpyx...@googlegroups.com.

[Charlie Clark]

Am .07.2019, 12:38 Uhr, schrieb jreyes <guanac...@gmail.com>:

> going to give things a try this morning and return if I need help. Thanks
> for your help so far, I appreciate it. Plan to get everything running
> today.

I've just tested using pip wheel from a checkout:

pip install -e .
python setupy.py sdist
pip wheel build/openpyxl-2.6.2.tar.gz

If you do this on a system with an internet connection then this will
create a wheel for installing on any system and it will also create wheels
for jdcal and et_xmlfile.

Wheels are great when they work and I would create wheels directly if only
Python's packaging would respect the manifest when doing so, which it
doesn't. So I don't.