Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://999465]
[Discipulus]: fore every 2 good old monks that come back, we will accept 1 clinical
[planetscape]: Might be "well, come back!" Discipulus ;-)
[stonecolddevin]: that's a 2.0 k/d ratio, i'll take it
[choroba]: #cbstream still down?
[erix]: yeah, annoying
[choroba]: last ambrus: 1 week ago :-(
[erix]: let's invade Hungary
[planetscape]: darn
[erix]: probably on holiday, the slacker

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (8)
As of 2017-06-22 21:05 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (530 votes). Check out past polls.