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