Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
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 chilling in the Monastery: (9)
As of 2015-07-07 13:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls