vikram007 has asked for the wisdom of the Perl Monks concerning the following question:

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re: how to set column in excel using parseexcel in perl
by Corion (Patriarch) on Oct 17, 2012 at 06:40 UTC

    Have you read the Spreadsheet::WriteExcel documentation? If you look at Spreadsheet::WriteExcel::Examples, you will find the answers for the column width and how to write to an Excel sheet. To calculate a percentage, you will either have to do the calculation in Perl and write the result to an Excel cell, or you will have to write a formula into the Excel sheet.

[reply]
Re: how to set column in excel using parseexcel in perl
by 2teez (Vicar) on Oct 17, 2012 at 05:51 UTC
[reply]
Re: how to set column in excel using parseexcel in perl
by 2teez (Vicar) on Oct 17, 2012 at 06:51 UTC

    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
[reply]
[d/l]
      but i am using "use Spreadsheet::ParseExcel::SaveParser;" module than how i can set a column.
[reply]
[reply]

Back to Seekers of Perl Wisdom