Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

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 ?

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!' );

    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.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://842059]
Approved by Corion
[thezip]: Ooops... I lied. I guess Cygwin is back. I'll just do a tail -f instead. Better. Sorry for the noise.
[Corion]: Once more, I'm looking for a sane client-side framework, but I guess these don't exist. Everything I look at either uses a weirdo home-grown templating language (like Angular in all its incarnations) or uses weirdo Javascript incarnations (like ...
[Corion]: ... Inferno.js, which uses ES2015) or uses some horrible amount of Javascript infrastructure before you can even render a single file.
[Corion]: I'd really like to create a dynamic frontend for my Google Keep clone, but so far, all the templating solutions seem to bring their own template language or require me to hand-code everything in (their own flavour of) Javascript. I'd like something ...
[Corion]: ... that can use templates from the HTML (via <script language="text/ template">... my template ...</script> and otherwise gets out of my way. But it seems that is not how the Javascript world is, currently :-/

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (11)
As of 2017-03-27 18:58 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (321 votes). Check out past polls.