RE: CSV to XLS(x)

Comments inline and trimmed for bandwidth...

Terry

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Yeung
Sent: Tuesday, December 04, 2012 5:09 PM
To: Midrange Systems Technical Discussion
Subject: Re: CSV to XLS(x)

On Tue, Dec 4, 2012 at 3:16 PM, Winchester Terry
<terry.winchester@xxxxxxxxxxxxxxx> wrote:

The latest version for the xlwt package named xlwt-0.7.4.tar.gz
contains a python script named "BIFFRecords.py". Within this script
there are strange quotation characters at line 1728 and greater that
must be converted to a normal double-quote before placing
this in the IFS otherwise you will receive the following error:

I didn't get that error, and I copied the Python files for xlwt
directly to the IFS (using FileZilla). I was actually expecting to
have to do some minor tweaking, but everything worked right out of the
box.

My guess is that your FTP settings (or however it is you got the files
to the IFS) are different than mine, or maybe it has to do with CCSID
settings on your i.

I used FireFox to download the XLWT tar file (right click, save as)
then opened it with WinZip, extracted it to a folder on my PC then
copied the complete folder contents to the IFS via OpsNav.

The BIFFRecords.py file contained the problem in class RefModeRecord.
Here it is - not sure if this will come thru correctly:

The "RC" mode uses numeric indexes for rows and columns,
i.e. "R(1)C(-1)", or "R1C1:R2C2".
The "A1" mode uses characters for columns and numbers for rows,
i.e. "B1", or "$A$1:$B$2".

These are not standard double quotes but once they were converted
to double-quotes the error message disappeared.

If it was a PITA to get iSeries Python installed, I would like to hear
about what was giving you trouble, because one of the maintainers of
that package is quite active and impressively good at troubleshooting,
as well as eager to make it as easy as possible to install. (He keeps
an eye on the iSeries Python forum (the "Posts" tab on
http://www.iseriespython.com), so posting there is an effective way to
reach him.)

Actually, I should have added the word "package" because installing
Python was fairly easy. It was the XLWT package that was confusing.
The instuctions indicated it should be installed via Python but I
couldn't figure out how to do that on the iSeries:

Any OS: Unzip the .zip file into a suitable directory, chdir to
that directory, then do "python setup.py install".

So...I created a xlwt folder under the site-package folder and copied
the tar files using OpsNav after fixing the quotes and it worked!
I think I got lucky...LOL Unfortunately, it seems that this method
didn't create the doc or examples folder as the README.html stated :(

Confidentiality Notice:

The preceding e-mail message (including any attachments) contains information that may be confidential, protected by applicable legal privileges, or constitute non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution or reproduction of this message by unintended recipients is
not authorized and may be unlawful.