Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

How to create blank work book in Perl Spreadsheet ?

by selva (Scribe)
on May 28, 2010 at 15:54 UTC ( #842059=perlquestion: print w/ replies, xml ) Need Help??
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 ?
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!' );

    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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://842059]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (6)
As of 2014-10-21 03:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (95 votes), past polls