Trying to debug Perl code to create and write an Excel file. My code worked for years, but stopped working a while back. Most often I read that I should use the module Excel::Writer::XLSX, but my ISP on whose system the code runs refuses to include this (for reasons of security, they say). The code which used to work, should create the excel file in a file with the name specified by the attachment name and put into the downloads directory 

my $attachment_name = $start_hour . "_" . $hour_count;
 
  print $cgi->header(-type=>"application/vnd.ms-excel",
                     -attachment=>"$attachment_name.xls");
  print $cgi->start_html(-title=>"Exported Excel results");
  
# Write the data 

  print $cgi->end_html;</

[download]

The data is no longer written into a created Excel file

2024-08-13 Athanasius fixed leading code tag.

In reply to Excel file in perl program by MikeGerard

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.