Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: how to set column in excel using parseexcel in perl

by 2teez (Priest)
on Oct 17, 2012 at 06:51 UTC ( #999465=note: print w/ replies, xml ) Need Help??


in reply to how to set column in excel using parseexcel in perl

Corion++. Really, you said it all. :)

Hi, vikram007:
This can give you a kind of push, but really just like Corion said you need get into this Spreadsheet::WriteExcel::Examples

use warnings; use strict; use Spreadsheet::WriteExcel; my $wk = Spreadsheet::WriteExcel->new('test.xls'); my $ws = $wk->add_worksheet("set column"); # set column width $ws->set_column( 'A:F', 25 ); # write to these columns $ws->write_row( 0, 0, [qw{1 2 3 4 5 6}]); $ws->write( $., 0, [split] ) while (<DATA>); __DATA__ 20 50 12 56 78 90 78 56 23 80 34 67

If you tell me, I'll forget.
If you show me, I'll remember.
if you involve me, I'll understand.
--- Author unknown to me


Comment on Re: how to set column in excel using parseexcel in perl
Download Code
Re^2: how to set column in excel using parseexcel in perl
by vikram007 on Oct 17, 2012 at 06:59 UTC
    but i am using "use Spreadsheet::ParseExcel::SaveParser;" module than how i can set a column.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (6)
As of 2014-12-28 08:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (179 votes), past polls