Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Excel::Writer::XLSX 0 byte outfile

by Corion (Patriarch)
on Nov 14, 2014 at 17:56 UTC ( [id://1107230]=note: print w/replies, xml ) Need Help??


in reply to Excel::Writer::XLSX 0 byte outfile

Normally, the ->close() method should be called implicitly, but maybe it isn't called in your case. Have you tried explicitly calling $workbook->close at the end of your program?

Replies are listed 'Best First'.
Re^2: Excel::Writer::XLSX 0 byte outfile
by doc1623 (Novice) on Nov 14, 2014 at 19:30 UTC
    thanks, close does work here but why, when I remove the format line, it works. On my program the close gets
    Can't call method "get_xf_index" on unblessed reference at /usr/share/ +perl5/site_perl/Excel/Writer/XLSX/Worksheet.pm line 6946, <$fh> line +42.

      It seems that something goes wrong when you create your format in $text_format and you then pass undef along to the ->write call. I don't see anything in the code of Excel::Writer::XLSX why that should happen, but maybe you find something. Maybe debugging this with Data::Dumper to see what you get in $text_format could help.

      It seems that something goes wrong when you create your format in $text_format and you then pass an unblessed hash along to the ->write call. I don't see anything in the code of Excel::Writer::XLSX why that should happen, but maybe you find something. Maybe debugging this with Data::Dumper to see what you get in $text_format could help.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2024-03-29 08:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found