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

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.

Replies are listed 'Best First'.
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.

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.