Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re: "write" problem with "Spreadsheet::WriteExcel" Module

by 2teez (Priest)
on Oct 07, 2013 at 10:30 UTC ( #1057241=note: print w/replies, xml ) Need Help??

in reply to "write" problem with "Spreadsheet::WriteExcel" Module

Why not like thus:

package ExcelUtil; use warnings; use strict; use vars qw(@ISA @EXPORT); @ISA = qw(Exporter); @EXPORT = qw(writeCell); sub writeCell { my ( $obj, $row, $col, $str ) = @_; $obj->write( $row, $col, $str ); } 1;
use warnings; use strict; use Spreadsheet::WriteExcel; use ExcelUtil; my $wrk_bk = Spreadsheet::WriteExcel->new('sample.xls'); my $wrk_sht = $wrk_bk->add_worksheet('new_sheet'); writeCell( $wrk_sht, 1, $_, "Testing, Row-1, Col-$_" ) for 1..5;
Why even calling the subroutine within it module like you did in your "" like this
writeCell(1, 2, "testing, Row-1, Col-2");
With the code shown above you can even do like this: writeCell( $wrk_sht, $_, 1, "Testing, Row-$_, Col-1" ) for 1..5; And it still works for you.

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1057241]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (5)
As of 2016-08-30 23:17 GMT
Find Nodes?
    Voting Booth?
    The best thing I ever won in a lottery was:

    Results (424 votes). Check out past polls.