perl CGI (65)
Perl script on web server sends Excel file to browser
159 comments. Current rating: (156 votes). Leave comments and/ or rate it.
Question:I need to have my web site generate an Excel worksheet on the fly (a database export) and send it to the user's webbrowser. How can I do that?
Answer:The following assumes that you export a simple sheet containing strings and numbers, no formulas.
In this case, you can generate a CSV file (comma separated values) and set the mime type to applicatioon/octet-stream.
If you perl script is called as /cgi-bin/exportcsv.pl then the downloaded file will by default be named
exportcsv.pl.xls (using alternative mime type application/vnd.ms-excel)
To suggest a specific file name (other than the script name, use the Content-Disposition header field. This field allows you to provide other information as well, e.g.
The size parameter indicates just an approximate size of the file in octets. It does not have to be the exact size. This information can be used by the client software (web browser) to pre-allocate space before attempting to store the file, or to determine whether enough space exists.
For the full syntax, see RFC 2183