Dear Friends: Thanks for taking patience in answering the question. I have the issue resolved like this but I am not sure how it works. Here is the code 


my $subject="Monthly Report";

my $file_link="\n Dear Customer: Please click on the link below to dow
+nload the Monthly Report for the month of 2019-05. <br><br> <a href=\
+"https://$hostname/ui_report/download_report?file=$fileloc\">Download
+ Report</a></center> \n\n"; # $fileloc contains the path of the store
+d file in our server.

&SendEmail($from,$toAddress,$cc,$bcc,$subject,'text/html',$file_link,$
+from); # This module sends an email with link - by clicking will down
+load the excel report.



In the "download_report" script:

if ($file =~ /\.xlsx$/) {
    
print "Content-type: application/vnd.openxmlformats-officedocument.spr
+eadsheetml.sheet\n";
# The Content-Disposition will generate a prompt to save the file.
print "Content-Disposition: attachment; filename=$file\n";
print "\n";
&download ($fileloc);
exit 0; # NEWLY ADDED DUE TO ISSUE IN EXCEL REPORT OPENING
} 

print "Content-Type: text/html\r\n\r\n";
 my $cgi = new CGI;
 print $cgi->redirect("tent");
 print "The redirect seems to have failed.";
 die;

[download]

By simply adding "exit 0; " statement I am able to download and view the report without any warnings. I believe previously after the execution of if block, it continued the execution and it might have created the problem. Please let me know if my explanation is not sufficient.

Above

In reply to Re^3: Excel-Writer-XLSX : Excel file with warning messages by rajan
in thread Excel-Writer-XLSX : Excel file with warning messages by rajan

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.