darshan_atha has asked for the wisdom of the Perl Monks concerning the following question:

hi , monks i am making a report and want to print header with bold tag into excell sheet and rest as it is ,can anybody help me how to print something in bold tag from my perl program. thanx in advance.

Replies are listed 'Best First'.
Re: print in excell sheet
by jmcnamara (Monsignor) on Nov 20, 2002 at 11:46 UTC

    One way to do it is to use Spreadsheet::WriteExcel:
    #!/usr/bin/perl -w use strict; use Spreadsheet::WriteExcel; my $workbook = Spreadsheet::WriteExcel->new('test.xls'); my $worksheet = $workbook->addworksheet(); my $heading = $workbook->addformat(bold => 1); $worksheet->write('A1', 'This is bold', $heading); $worksheet->write('B1', 'This is not' );

    There are other ways to do it as well, most notably via Win32::OLE.

    Have a look at cacharbe's Using Win32::OLE and Excel - Tips and Tricks.

    --
    John.

Re: print in excell sheet
by UnderMine (Friar) on Nov 20, 2002 at 11:18 UTC