Uhh ... gotta say it, but ...
The most-significant textual clip from the OP, IMHO, is this one: The most important line is header("Content-Disposition: attachment; filename=BOBreport.xls"); I need to have it in my perl script to export a html table data to Excel.
It quite-frankly appears to me that the OP is most-interested in the output of the aforesaid (PHP ...) code. If this is indeed the case, then there is in fact no actual requirement to “translate the following PHP code to” ... (anything!)
If you are only concerned with the (HTML) output of a computer program, then you do not care in the slightest what programming-language was originally used to generate that output.
If the Perl program that you contemplate is destined to be a client of the program that (somehow ...) produces the “HTML table data,” this Perl program need only be concerned with “how to correctly parse this HTML data, regardless of its source.”
On the other hand, if the Perl program that you contemplate is destined to replace entirely the aforesaid program as “the root-source of the data being sought” ... then both PHP and the HTML that it now produces become irrelevant.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
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:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||