RE: Excel - Rpg

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx

On Behalf Of Prevesh Kuni
Sent: Friday, September 07, 2007 4:51 AM
To: RPG programming on the AS400 / iSeries; rpg400-l@xxxxxxxxxxxxxxxx
Subject: Re: Excel - Rpg

Hi,

Thanks for all the help thus far, just two more problems to get

Thanks Scott for the umpteenth time, the printSetup() Class works

but there are a few things that I still need to do:
I need to set the margins

The left, top and right to 0, I have tried to use the following code
d HSSFPrintSetup_setMarginLft...
d pr
extproc(*JAVA
d
:'org.apache.poi.hssf-
d
usermodel.HSSFPrintSetup'
d
:'setmarginlft'
d marginlft
like(jshort) value

d psetup s
like(HSSFPrintSetup)

/free

HSSFPrintSetup_setMarginLft(psetup: 0)

but I get the Java Exception Error - 'No Such Method' I'm assuming in

HSSFPrintSetup class?????

I am also trying to set the gridlines on

Anyone.........please



Prevesh Kuni
Developer
Smollan Group
(011) 640 8154
kunip@xxxxxxxxxxxxxx

rpg400-l@xxxxxxxxxxxxxxxx 2007/09/05 20:07:41 >>>

Actually, the link that Kevin posted was relatively old. The most
recent HSSF related stuff is here (it also contains links to all of

previous articles -- note: you need a membership in SystemiNetwork.com
to view this link, though a free Associate membership will work):

http://www.systeminetwork.com/article.cfm?id=55032

Keep in mind that the "latest" link will keep changing if I continue

write more about HSSF! :)

Prevesh Kuni wrote:

Thanks guys, I've just got the latest HSSF from the link that Kevin
posted written by Scott Klement(Thanks Scott), the one I had was

the article in 2004 which didn't have the HSSFPrintSetup class and

HSSFSheet_getPrintSetup () prototype.....Hopefully all will go
well.......

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

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 .
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

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.