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

To test if you're using the right path and file name, use WRKLNK...

ie..

WRKLNK '/my directory/myfile.ext'

If it doesn't show the file, you're using the wrong format.

A lot of my customers who do the same thing get the folders and directories
mixed up. Folders are part of the IFs, but they're s special part reserved
for those who want to live in the Windows 3.x folder and file naming world.
:)

Brad
www.bvstools.com

On Thu, Nov 5, 2015 at 1:51 PM, Darryl Freinkel <dfreinkel@xxxxxxxxxxxxxxxxx

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



--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.