× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



HSSFPrintSetup doesn't have a setMarginLft method. Just header and
footer.
http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFPrintSet
up.html shows all the available methods. HSSFSheet does have a
LeftMargin field, but I've never tried to use it personally.
http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFSheet.ht
ml


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto: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
through!
Thanks Scott for the umpteenth time, the printSetup() Class works
great,
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
the
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
the
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
to
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
from
the article in 2004 which didn't have the HSSFPrintSetup class and
the
HSSFSheet_getPrintSetup () prototype.....Hopefully all will go
well.......

--
This is the RPG programming on the AS400 / 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 .
--
This is the RPG programming on the AS400 / 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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.