Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
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

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?
[marioroy]: why do some posters not know to provide a good SSCCE? Nested loops?
[Corion]: marioroy: Producing good SSCCE is an acquired skill :) You have to produce bad SSCCEs for a long time until you get good. And when you get good, you don't need them that much anymore because you simply isolate the problem and then solve it ;)
[marioroy]: ... and kcott is able to provide something. Amazing.

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (8)
As of 2017-08-18 08:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Who is your favorite scientist and why?



























    Results (297 votes). Check out past polls.

    Notices?