You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Da...@porsche-engineering.de on 2004/07/30 14:00:09 UTC
HSSF: column headers on each print page
Hi list,
I've been fooling around with HSSF for a little time now, and run into the
following problem:
Is it possible to have the generated Excel-sheet display column headers on
every page when printing? Im currently browsing the documentation, but
aside from setDisplayRowColHeadings() I did not find anything yet.
Thanks for your time,
Daniel Krippner
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: HSSF: column headers on each print page
Posted by Danny Mui <da...@muibros.com>.
I know HSSF has repeating rows and columns but that doesn't sound like
what you're looking for.
Daniel.Krippner@porsche-engineering.de wrote:
> Hi list,
>
> I've been fooling around with HSSF for a little time now, and run into the
> following problem:
> Is it possible to have the generated Excel-sheet display column headers on
> every page when printing? Im currently browsing the documentation, but
> aside from setDisplayRowColHeadings() I did not find anything yet.
> Thanks for your time,
> Daniel Krippner
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Antwort: RE: Antwort: RE: HSSF: column headers on each print page
Posted by Da...@porsche-engineering.de.
> In POI it's repeating rows and columns:
Doh! Thanks very much... somehow I put these into another drawer :-(
Sorry for the stupid questions,
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
RE: Antwort: RE: HSSF: column headers on each print page
Posted by Shawn Laubach <sh...@cox.net>.
In POI it's repeating rows and columns:
http://jakarta.apache.org/poi/hssf/quick-guide.html#Repeating
Shawn
-----Original Message-----
From: Daniel.Krippner@porsche-engineering.de
[mailto:Daniel.Krippner@porsche-engineering.de]
Sent: Monday, August 02, 2004 1:28 AM
To: POI Users List
Subject: Antwort: RE: HSSF: column headers on each print page
> How do you make it do it in excel?
I'll try to explain, I have the german language version of excel here so
I'll have to translate menu names, I hope not too much will get "lost in
translation" :-)
To make a group of cells appear on every page when printing, open the
"File" menu, then "Page setup", then the "Table" tab. There is a section
called "Print title", and the first field is called something like "Repeat
header line" ("Wiederholungszeile oben" in german). Here one can chose a
line of cells that will appear on every page when printing.
hth, if that doesn't work with HSSF out of the box, I'd also be glad for
some hints where to look at what in the sources...
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Antwort: RE: HSSF: column headers on each print page
Posted by Da...@porsche-engineering.de.
> How do you make it do it in excel?
I'll try to explain, I have the german language version of excel here so
I'll have to translate menu names, I hope not too much will get "lost in
translation" :-)
To make a group of cells appear on every page when printing, open the
"File" menu, then "Page setup", then the "Table" tab. There is a section
called "Print title", and the first field is called something like "Repeat
header line" ("Wiederholungszeile oben" in german). Here one can chose a
line of cells that will appear on every page when printing.
hth, if that doesn't work with HSSF out of the box, I'd also be glad for
some hints where to look at what in the sources...
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
RE: HSSF: column headers on each print page
Posted by Shawn Laubach <sh...@cox.net>.
How do you make it do it in excel?
Shawn
-----Original Message-----
From: Daniel.Krippner@porsche-engineering.de
[mailto:Daniel.Krippner@porsche-engineering.de]
Sent: Friday, July 30, 2004 7:00 AM
To: poi-user@jakarta.apache.org
Subject: HSSF: column headers on each print page
Hi list,
I've been fooling around with HSSF for a little time now, and run into the
following problem:
Is it possible to have the generated Excel-sheet display column headers on
every page when printing? Im currently browsing the documentation, but
aside from setDisplayRowColHeadings() I did not find anything yet.
Thanks for your time,
Daniel Krippner
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org