Re: Error RNQ0202 HSSFR4 HSSF_GETSH

On Mon, May 9, 2016 at 10:03 AM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 5/6/2016 5:29 PM, pat wrote:

be patient (i'm new in java !!)

The problem is that you are fighting several things all at once, and
it's going to be confusing that way. If I may make a suggestion, don't
start using Java this way. Instead, try it on your PC. Put the POI
classes on your PC, set your CLASSPATH and try the POI examples on your
PC to create (or read) a spreadsheet. I learnt many useful lessons this
way.

I like this suggestion. It's what I would recommend if learning Java
is a specific goal, just as I almost always recommend learning Python
on a PC (or Linux box or Mac), even if ultimately you want to use it
on the i.

However, if learning Java isn't so much an explicit goal as a
necessary step in being able to manipulate Excel spreadsheets on the
i, then I feel it's worth considering iSeriesPython instead of Java.

The whole setting-up-Java-for-POI-on-the-i thing is an oft-recurring
thread, and it just seems so much more susceptible to complications
than necessary. I specifically recommend iSeriesPython instead of Java
(and not even IBM's Python for PASE, unless you already have it
installed) because there are far fewer versions and other moving parts
to worry about. Everyone on V5R3 or later should be using the exact
same iSeriesPython version (namely, python27_revE.zip, as of this
writing), with the exact same setup, which takes just minutes to
achieve with little more than unpacking a couple of save files, then
doing one RSTOBJ and one RST.

If you don't already know Java and don't already have Java and POI
*properly* set up, consider iSeriesPython and either XlsxWriter or
OpenPyXL instead.

John Y.