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

Hi Michael,

If you get in a bind and decide to look for some commercial product assistance we have a couple options.

1.) RPG2SQL Integrator for reading and writing Excel and SQL database from RPG.
http://www.helpsystems.com/rjs

2.) AutoMate - Automate is a Windows product where you can write tasks to read and write Excel file and more. About 600+ Windows automation capabilities.
http://www.helpsystems.com/automate

Your task will be done in no time.

Regards,

Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-486-6802
RJS Software Systems | A Division of HelpSystems
richard.schoen@xxxxxxxxxxxxxxx
www.rjssoftware.com
Visit me on: Twitter | LinkedIn


----------------------------------------------------------------------

message: 1
date: Thu, 5 Nov 2015 12:18:55 -0500
from: Michael Ryan <michaelrtr@xxxxxxxxx>
subject: Re: Trying to get a RPG program to read a xlsx

Is the file name quoted? Try it with quotes around the name value to take care of embedded spaces.

On Thu, Nov 5, 2015 at 12:11 PM, Darryl Freinkel < dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

I need help. I have loaded the POI and other libraries onto the
machine and compiled. I am using Scott Klement's code and examples.



I am stuck with an error trying to open the spreadsheet with the
hssf_Open(path_and_filename). It errors out and the job log shows that
the file is not found.



1. The file name and path is long, over 100 characters. Is this a
problem?

2. The file name contains blanks. Is this a problem?

3. I cannot debug the HSSFR4 code. The compiler jumps over it and
will
not allow me to put in a break point. I am using the Java/GUI debugger
included with iAccess.



Any suggestions would help.

TIA



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.