Re: Trying to get a RPG program to read a xlsx

So in your original post you mentioned that your path variable is defined as 100A. If by some chance you are calling from the command line (or using SBMJOB) and passing a value into that 100A field, the end of it can have funky character in it because of the 32 byte thing Vern mentioned. You can't trim those off even if they are unprintable since trim only removes blanks (x'40') from the beginning and/or end depending on which one you use. If you need to do this, you can create a command object which lets you define the length of the parameter, and execute that from the command line or SBMJOB. Or you will need some other method of passing parameters. For submitted jobs with long parameters, I sometimes use a keyed data queue. The interface is not to complex, and fast. and you can put almost anything you want on it.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx> wrote: -----
To: "RPG programming on the IBM i (AS/400 and iSeries)" <rpg400-l@xxxxxxxxxxxx>
From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Date: 11/05/2015 02:50PM
Subject: Re: Trying to get a RPG program to read a xlsx

Darryl

Are you using a literal in one of the parameters? Is the character after
the name somewhere around of after position 32?

I don't know who it would happen in your case - but character literals
in SBMJOB or from a command line that are less then 32 characters are
padded only out to 32 - whatever is in memory after that is what the
receiving parameter will get, if longer than 32.

Just a crazy guess, eh?

Vern

On 11/5/2015 1:51 PM, Darryl Freinkel wrote:

Status so far.



I eliminated all the blank issues. Created a folder called test and a file
called test.xlsx.



I get the same issue.



I have tried both ss_open and xssf-open. Same result.



I added the test for Book = *NULL, it fails before the IF.



The path is now: /ax_on_i/test/

Should ss-Open be '/ax_on_i/test/' or be '/ax_on_i/test/test.xlsx' ?



In the job log I get a RNX0301 which shows the path as be
'/ax_on_i/test/test.xlsx' but it also has some character after it. I see a
block. I have trimmed the file and path so I do not know where that comes
from.







Darryl Freinkel

Assignment 400 Group, Inc.

Tel: 770.321.8562 ext 111 | Fax 770.321.8562 | 2247 La Salle Dr, Marietta
GA, 30062, USA | PO Box 72556, Marietta, GA 30007-2556