Re^2: Excel::Template corrupt output

[Anonymous Monk]

Excel::Template 0.12
Spreadsheet::WriteExcel 2.03
MS Excel 2003
Linux w/2.4 kernel, Perl 5.6.2
Command line

#!/usr/bin/perl -w
use strict;
use Excel::Template;

my $excel_template = Excel::Template->new(filename => 'test_template.x
+ml');

$excel_template->write_file('test.xls');

Here's the template:

<workbook>
    <worksheet name="Test">
        <cell text="A single cell"/>
    </worksheet>
</workbook>

[dragonchild]

I ran your code with the following setup and it worked just fine without any errors. You sure you're using a binary transfer mode when ftp'ing the file?
• RH9 (2.4 kernel), Perl 5.8.0 (vendor build)
• S::WE 2.04, E::T 0.12
• MS Excel 2002 (I don't have access to Office2k3)

[Anonymous Monk]

Yes, I'm sure. I'm transferring the file with Samba.

I can successfully run the code on Windows with Perl 5.8.x and the file opens without warning; the only thing I've noticed is that the corrupt file is 2 bytes larger (5,634 bytes vs. 5,632).

[dragonchild]

Please go ahead an open a bug on rt.cpan.org and I'll look at it. The suspect I'm looking at right now is the Perl version - 5.6.x vs. 5.8.x, but I don't have a 5.6.x version handy. It might be a few days before I get one installed and running (work is heating up right now).

Try installing 5.8.x on the linux box and see if that fixes things. When I ran on Linux using 5.8.0, my file was 5632 bytes long.