Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
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
Replies are listed 'Best First'.
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 meditating upon the Monastery: (8)
As of 2015-08-30 14:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The oldest computer book still on my shelves (or on my digital media) is ...













    Results (349 votes), past polls