You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Ruchi2 <ru...@yahoo.com> on 2008/09/17 18:59:05 UTC
Set gridlines in Excel thru POI not working.
Can anyone please guide me on how can i set grid lines in excel using POI. I
have tried the below, is that all what is needed?Can someone please confirm.
It does'nt work for me. Am i missing anything. Please do let me know.
sheet.setGridsPrinted(true);
sheet.setPrintGridlines(true);
sheet.setDisplayGridlines(true);
Thanks
--
View this message in context: http://www.nabble.com/Set-gridlines-in-Excel-thru-POI-not-working.-tp19536696p19536696.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Set gridlines in Excel thru POI not working.
Posted by Ruchi2 <ru...@yahoo.com>.
Thanks. Sorry for the confusion between gridlines and borders.
Ruchi2 wrote:
>
> Can anyone please guide me on how can i set grid lines in excel using POI.
> I have tried the below, is that all what is needed?Can someone please
> confirm. It does'nt work for me. Am i missing anything. Please do let me
> know.
>
> sheet.setGridsPrinted(true);
> sheet.setPrintGridlines(true);
> sheet.setDisplayGridlines(true);
>
> Thanks
>
>
--
View this message in context: http://www.nabble.com/Set-gridlines-in-Excel-thru-POI-not-working.-tp19536696p19540706.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
RE: Set gridlines in Excel thru POI not working.
Posted by "Laubach, Shawn CTR USAF AFMC 555 ACSS/GFLB" <Sh...@tinker.af.mil>.
You might look at http://poi.apache.org/hssf/quick-guide.html#Borders
-----Original Message-----
From: Ruchi2 [mailto:ruchiagrawal2@yahoo.com]
Sent: Wednesday, September 17, 2008 1:47 PM
To: dev@poi.apache.org
Subject: Re: Set gridlines in Excel thru POI not working.
Hi Shawn,
Thanks for your reply. I think i mis framed my question. I am seeing the
grid lines, but what i really want is borders. I guess my question
should
have been how do i set the dark borders around the grid.
Ruchi
Ruchi2 wrote:
>
> Can anyone please guide me on how can i set grid lines in excel using
POI.
> I have tried the below, is that all what is needed?Can someone please
> confirm. It does'nt work for me. Am i missing anything. Please do let
me
> know.
>
> sheet.setGridsPrinted(true);
> sheet.setPrintGridlines(true);
> sheet.setDisplayGridlines(true);
>
> Thanks
>
>
--
View this message in context:
http://www.nabble.com/Set-gridlines-in-Excel-thru-POI-not-working.-tp195
36696p19538664.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Set gridlines in Excel thru POI not working.
Posted by Ruchi2 <ru...@yahoo.com>.
Hi Shawn,
Thanks for your reply. I think i mis framed my question. I am seeing the
grid lines, but what i really want is borders. I guess my question should
have been how do i set the dark borders around the grid.
Ruchi
Ruchi2 wrote:
>
> Can anyone please guide me on how can i set grid lines in excel using POI.
> I have tried the below, is that all what is needed?Can someone please
> confirm. It does'nt work for me. Am i missing anything. Please do let me
> know.
>
> sheet.setGridsPrinted(true);
> sheet.setPrintGridlines(true);
> sheet.setDisplayGridlines(true);
>
> Thanks
>
>
--
View this message in context: http://www.nabble.com/Set-gridlines-in-Excel-thru-POI-not-working.-tp19536696p19538664.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
RE: Set gridlines in Excel thru POI not working.
Posted by Ruchi2 <ru...@yahoo.com>.
The grid lines do get printed when i actually "print" the sheet on paper. But
i also need them to show on the view when i open excel which is not working.
Laubach, Shawn CTR USAF AFMC 555 ACSS/GFLB wrote:
>
> Either of the first two should trigger that the grid lines get printed.
> If not, then there's a bug somewhere.
>
> Shawn
>
> -----Original Message-----
> From: Ruchi2 [mailto:ruchiagrawal2@yahoo.com]
> Sent: Wednesday, September 17, 2008 11:59 AM
> To: dev@poi.apache.org
> Subject: Set gridlines in Excel thru POI not working.
>
>
> Can anyone please guide me on how can i set grid lines in excel using
> POI. I
> have tried the below, is that all what is needed?Can someone please
> confirm.
> It does'nt work for me. Am i missing anything. Please do let me know.
>
> sheet.setGridsPrinted(true);
> sheet.setPrintGridlines(true);
> sheet.setDisplayGridlines(true);
>
> Thanks
>
> --
> View this message in context:
> http://www.nabble.com/Set-gridlines-in-Excel-thru-POI-not-working.-tp195
> 36696p19536696.html
> Sent from the POI - Dev mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/Set-gridlines-in-Excel-thru-POI-not-working.-tp19536696p19538298.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
RE: Set gridlines in Excel thru POI not working.
Posted by "Laubach, Shawn CTR USAF AFMC 555 ACSS/GFLB" <Sh...@tinker.af.mil>.
Either of the first two should trigger that the grid lines get printed.
If not, then there's a bug somewhere.
Shawn
-----Original Message-----
From: Ruchi2 [mailto:ruchiagrawal2@yahoo.com]
Sent: Wednesday, September 17, 2008 11:59 AM
To: dev@poi.apache.org
Subject: Set gridlines in Excel thru POI not working.
Can anyone please guide me on how can i set grid lines in excel using
POI. I
have tried the below, is that all what is needed?Can someone please
confirm.
It does'nt work for me. Am i missing anything. Please do let me know.
sheet.setGridsPrinted(true);
sheet.setPrintGridlines(true);
sheet.setDisplayGridlines(true);
Thanks
--
View this message in context:
http://www.nabble.com/Set-gridlines-in-Excel-thru-POI-not-working.-tp195
36696p19536696.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org