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

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
Comment on Re: "write" problem with "Spreadsheet::WriteExcel" Module
Select or Download Code

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: (10)
As of 2016-06-01 08:12 GMT
Find Nodes?
    Voting Booth?

    No recent polls found