Re: Excel - Rpg

["Prevesh Kuni" <KuniP@xxxxxxxxxxxxx>]

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.......