- or download this
my @rows = Spreadsheet::Read::rows($book->[1]);
foreach my $i (1 .. scalar @rows) {
...
say chr(64+$i) . " $j " . ($rows[$i-1][$j-1] // '');
}
}
- or download this
#!/usr/bin/perl
use strict;
...
'D3 ' => ''
};
Column/row: A2
- or download this
#!/usr/bin/perl
use strict;
...
'D1 ' => '% Commission'
};
Column/row: C1 Value: Sales Amount