MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 2014

Setting up Python XlsxWriter on IBM i



fixed

I have some time on my hands and am trying to set up Python and XlsxWriter on an IBM i. Keep in mind that I have minimal Linux knowledge (i.e. don't laugh too hard).

Python was no problem. I downloaded version 27 revE from http://sourceforge.net/projects/iseriespython/files/, and followed the instructions in the README.txt contained in the .zip file. I have a Python27 library now, and successfully started Python and did a print "Hello".

In a post back in December 2013 (http://archive.midrange.com/midrange-l/201312/msg00640.html) John Yeung mentioned XlsxWriter. I want to be able to read as well as write, so I got OpenPyXL (openpyxl-2.0.3.tar.gz) instead from https://pypi.python.org/pypi/openpyxl, and extracted the contents to folder /openpyxl on the IBM i./

/The instructions at http://pythonhosted.org//openpyxl/ suggest using pip or easy_install, but those do not exist on the IBM i; besides, I've already downloaded the file and extracted it. The next thing it says is to do "python setup.py install". So from an OS400 command line I tried

PYTHON PROGRAM('/openpyxl/setup.py') PARM(install)

Traceback (most recent call last):
File "/openpyxl/setup.py", line 27, in <module>
from setuptools import setup, Extension, find_packages
ImportError: No module named setuptools
Press ENTER to end terminal session.

Presumably pip or easy_install would've gotten all these dependencies. Do I just keep slogging through this, finding each missing package, downloading it and installing it? Or is there an easier way?

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact