Re: PERL + Repeat header on every page while printing excel

On Dec 28, 6:32 am, Ivan Novick <i...@xxxxxxxxxx> wrote:
On Dec 28, 4:13 am, venkatasatyasur...@xxxxxxxxx wrote:

Hi,
I am working on an application using PERL 5.8.

I have a requirement where i am getting data from Oracle
database & exporting it to an excel. Users will print this excel file.
We are getting bulk data from database & its printing multiple pages.
On every page we want the header to be present.

I am hoping you are printing to excel in csv plain text format and not
using binary api specifically for excel.
Why?

If you are printing in csv format and want to repeat a header on every
page you can use "perl format" to do this:

http://perldoc.perl.org/functions/format.html

Using an api would give you far more control over the spread***
formatting than the "perl format"

Spread***::WriteExcel - Write to a cross-platform Excel binary file.
http://search.cpan.org/~jmcnamara/Spread***-WriteExcel-2.20/lib/Spread***/WriteExcel.pm#repeat_rows($first_row,_$last_row)
.