PERL + Repeat header on every page while printing excel
- From: venkatasatyasuresh@xxxxxxxxx
- Date: Fri, 28 Dec 2007 04:13:08 -0800 (PST)
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.
Printing the excel file is done manually from the exported
excel. But when he prints the excel, header should repeat on each
page.
Somehow we have found doing this in excel. from File -> page set
up -> *** tab, we have to select rows to repeat at top.
But we want this to be done programmatically from PERL. I mean
to say when I export the data to excel file, this file should have
this setting (rows to repeat at top i have to set programmatically).
I can't request the end-user to do this manually.
So any input on this would be great help to me.
Thanks
Suresh
.
- Follow-Ups:
- Re: PERL + Repeat header on every page while printing excel
- From: Ivan Novick
- Re: PERL + Repeat header on every page while printing excel
- Prev by Date: Re: close a filehandle for all processes
- Next by Date: Re: Problem about type glob reference
- Previous by thread: FAQ 5.14 How come when I open a file read-write it wipes it out?
- Next by thread: Re: PERL + Repeat header on every page while printing excel
- Index(es):