Pat,
Sorry change the statements that
have:
book = new_XSSFWorkbook();
filename = '/home/example.xlsx';
to:
book = new_hssfWorkbook();
filename = '/home/example.xls';
Bill
From: broehmer@xxxxxxxxxxxxxxx
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/09/2016 09:10 AM
Subject: Re: Error RNQ0202 HSSFR4 HSSF_GETSH
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
Pat,
There seem to be a lot of "moving" parts to
your problem. I would suggest a different
approach since we don't know all of the
issues you are having.
Maybe you should back up a little
and determine what works and doesn't
work.
Have you ever created an Excel file
using HSSFR4? If not, maybe
you should try one of Scott's earlier
examples just to make sure you don't
have other issues before you attempt
to modify a spreadsheet.
From an earlier post you indicated that you
are on V7R1 but clearly you are on V6R1.
Not that that really matters but lets start
with a simple Excel create.
As an example you might try:
H DFTACTGRP(*NO) BNDDIR('HSSF')
/include *libl,qrpglesrc,hssf_H
/copy *libl/Qrpglesrc,STDIO_H
/copy *libl/Qrpglesrc,IFSIO_H
D book s like(SSWorkbook)
D sheet s like(SSSheet)
D row s like(SSRow)
D cell s like(SSCell)
D filename s 100a varying
/free
ss_begin_object_group(100);
book = new_XSSFWorkbook();
filename = '/home/example.xlsx';
sheet = SS_newSheet(book: 'Test');
row = SSSheet_createRow(sheet: 0);
cell = SSRow_createCell(row: 0);
SSCell_setCellValueD(cell: 1234);
HSSF_Save(book:filename);
HSSF_End_Object_Group();
*inlr = '1';
Bill
From: pat <p.caroti@xxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 05/06/2016 05:30 PM
Subject: Re: Error RNQ0202 HSSFR4 HSSF_GETSH
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
<broehmer@...> writes:
Pat,
Try running qsh.
(STRQSH)
then: java -version
That will show what version you are running.
Then
go licpgm and use option 10.
that will show what is on your machine 57xxJV1 and can be
run.
Mine's shows java 1.6 and I have JDK 1.4, 5.0 J2SE 5/32bit, 5/64bit
and JDK 6 both 32/64. So with my environment I have it pointed to
jdk 6/32. Don't think 64 will make a difference.
This is all preliminary stuff that may be irrelevant but it could
show something I can't see. Just clearing the deck so to speak.
java -version
java version "1.6.0"
Java(TM) SE Runtime Environment (build pap3260sr16fp4-20150414_01(SR16
FP4))
IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 OS/400 ppc-32
jvmap3260sr16fp4-20150414_01.zip (JIT enabled, AOT enabled)
J9VM - 20150406_242976
JIT - r9_20150402_88984
GC - GA24_Java6_SR16_20150406_1410_B242976)
JCL 20150413_01
$
5733907 V1R4M0 Firmware del server
5770DG1 V7R1M0 IBM HTTP Server per i
5761JV1 V6R1M0 IBM Developer Kit per Java
5761JV1 V6R1M0 J2SE 5.0 32 bit
5761JV1 V6R1M0 J2SE 5.0 64 bit
5761JV1 V6R1M0 Java SE 6 32 bit
5761JV1 V6R1M0 Java SE 6 64 bit
in the main time i have tested with jdk50 /jdk60 e jdk626 with 64bit
generate also memory dump
Thanks
midrange.com
