How to create blank work book in Perl Spreadsheet ?

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

Dear Monks,

In Spreadsheet-WriteExcel module

How to create blank workbook

that means , workbook should not contains rows and columns. Border should be hidden

Comment on How to create blank work book in Perl Spreadsheet ?

Replies are listed 'Best First'.
Re: How to create blank work book in Perl Spreadsheet ? by jmcnamara (Monsignor) on May 28, 2010 at 16:46 UTC
To hide gridlines use the hide_gridlines() method. `use Spreadsheet::WriteExcel; my $workbook = Spreadsheet::WriteExcel->new('test.xls'); my $worksheet = $workbook->add_worksheet(); $worksheet->hide_gridlines(2); $worksheet->write( 'A1', 'Hi Excel!' );` [download] I'm not sure what you mean by "workbook should not contains rows and columns" but set_row() and set_column() have options to hide rows and columns. -- John.	[reply] [d/l]

Replies are listed 'Best First'.

Re: How to create blank work book in Perl Spreadsheet ?
by jmcnamara (Monsignor) on May 28, 2010 at 16:46 UTC

hide_gridlines()


    use Spreadsheet::WriteExcel;

    my $workbook  = Spreadsheet::WriteExcel->new('test.xls');
    my $worksheet = $workbook->add_worksheet();

    $worksheet->hide_gridlines(2);
    $worksheet->write( 'A1', 'Hi Excel!' );
[download]

I'm not sure what you mean by "workbook should not contains rows and columns" but set_row() and set_column() have options to hide rows and columns.

--
John.

[reply]
[d/l]