Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Excel::Template corrupt output

by dragonchild (Archbishop)
on Aug 19, 2004 at 13:03 UTC ( [id://384272]=note: print w/replies, xml ) Need Help??


in reply to Excel::Template corrupt output

I'm the author of Excel::Template. A few questions:
  • What version of E::T are you using? The latest version is 0.12
  • What version of Spreadsheet::WriteExcel?
  • What version of MS Excel?
  • What OS / Perl version are you using to generate the Excel file?
  • Are you using mod_perl or straight CGI? If mod_perl, are you using MP1 or MP2?
  • Can you give us a snippet of the Perl code that's generating the file? Try and make it the smallest amount of code that will reliably reproduce the error.

------
We are the carpenters and bricklayers of the Information Age.

Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

I shouldn't have to say this, but any code, unless otherwise stated, is untested

Replies are listed 'Best First'.
Re^2: Excel::Template corrupt output
by Anonymous Monk on Aug 19, 2004 at 15:33 UTC
    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>
      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)

      ------
      We are the carpenters and bricklayers of the Information Age.

      Then there are Damian modules.... *sigh* ... that's not about being less-lazy -- that's about being on some really good drugs -- you know, there is no spoon. - flyingmoose

      I shouldn't have to say this, but any code, unless otherwise stated, is untested

        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).

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://384272]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (5)
As of 2024-04-19 04:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found