A quicker alternative, which I found out by chance a few months ago.
Simpler without ::Simple. :-)
#!/usr/bin/perl -w
use strict;
use Spreadsheet::ParseExcel::Simple;
use Spreadsheet::WriteExcel; # <---
my $xls = Spreadsheet::ParseExcel::Simple->read('old.xls');
my @data;
for ($xls->sheets) {
while ($_->has_data) {
push @data, [$_->next_row];
}
}
my $ss1 = Spreadsheet::WriteExcel->new('new.xls');
my $ws = $ss1->add_worksheet('transposed');
$ws->write('A1', \@data);
# Yes. IT IS transposed!
As a side note, in your example, instead of Math::Matrix you can use tye's Algorithm::Loops.
use Algorithm::Loops qw(MapCar);
# ....
$ss->write_row($_) for MapCar {[@_]} @data ;
-
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.
|