Re: 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?

Comment on Re: Excel::Writer::XLSX 0 byte outfile Select or Download Code

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.` [download]	[reply] [d/l]
Re^3: Excel::Writer::XLSX 0 byte outfile by Corion (Patriarch) on Nov 15, 2014 at 09:22 UTC
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.	[reply] [d/l] [select]
Re^3: Excel::Writer::XLSX 0 byte outfile by Corion (Patriarch) on Nov 15, 2014 at 09:23 UTC
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.	[reply] [d/l] [select]