I tried out your code, and it creates a nice spreadsheet. Thank you for providing your working code!
I'm not sure I understand your question. However.. If I was to write a function that takes your three values it would be thus:
sub Entry( $ $ $ $ ) {
my ( $row, $slno, $testid, $status ) = @_;
$worksheet->write( "A$row", $slno );
$worksheet->write( "B$row", $testid );
$worksheet->write( "C$row", $status );
}
and call it thus
# skip header row on Excel Spreadsheet
my @entries = (
[ "1", "00A", "pass" ],
[ "2", "01A", "fail" ],
[ "3", "01B", "fail" ],
[ "4", "02A", "pass" ],
);
for (my $i = 0; $i < @entries; $i++) {
my ( $slno, $testid, $status ) = @{$entries[$i]};
Entries( $i+2, $slno, $testid, $status );
}
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.