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

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.

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

Regards,
Ivan Novick
http://www.0x4849.net
.

Relevant Pages

  • Re: PERL + Repeat header on every page while printing excel
    ... I am working on an application using PERL 5.8. ... Users will print this excel file. ... We are getting bulk data from database & its printing multiple pages. ... I am hoping you are printing to excel in csv plain text format and not ...
    (comp.lang.perl.misc)
  • Re: Using Perl to Parse Excel File
    ... >when the script runs it is printing as ... See if you can invoke a function with a name like "formatted", ... Excel convert the internal format to displayed text format. ...
    (comp.lang.perl.misc)
  • RE: Attaching to Running Process
    ... the prn file created when printing is a binary ... format file and Excel does not know how to read it. ... the prn file directly with Excel your Windows Explorer? ...
    (microsoft.public.excel.programming)
  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)
  • RE: Export to Excel: 2nd, 3rd, etc excel files not opening up
    ... early bindings to use the built-in functions of excel to format my excel ... Well based on your suggestions my understanding is that in my early binding ... Set xlApp = New Excel.Application ... I also was able to format that same exported excel ...
    (microsoft.public.access.formscoding)