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

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
[download]

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 (Initiate) on Oct 17, 2012 at 06:59 UTC
but i am using "use Spreadsheet::ParseExcel::SaveParser;" module than how i can set a column.	[reply]
Re^3: how to set column in excel using parseexcel in perl by Corion (Patriarch) on Oct 17, 2012 at 07:03 UTC
I don't believe you can do that, but maybe looking through the Spreadsheet::ParseExcel::SaveParser documentation tells you more.	[reply]

In Section Seekers of Perl Wisdom