Short answer: you can't.
The problem is that HTTP and web browsers don't work that way. You (server) can't "send a file" to a browser, it is the browser that must request the file to you.
This said, I see at least two options to do something that works like you expect:
-
Send a HTML page with the informations and generate server side the file. In the page, there will be a link to download the file.
-
Same thing but a bit more automagic: instead of a link on the page you can have a short javascript doing the same thing. When the page is loaded in the browser, the script will start a second HTTP request to download the xls file.
In both approaches you have to consider two caveats: first that the file is created and saved server side, and should not be deleted until the browser downloads it, but consider also that the browser could never start the download. So you should implement some server side mechanism to delete all files older than X minutes/hours/days (depending on your context) or soon or later you'll have the server disk full.
The second point to remember is that the files generated in this way are exposed on the internet. If the files can contain sensitive data, you should at least generate them with random names, to reduce the chance of a guess on a sequential naming scheme.
Rule One: "Do not act incautiously when confronting a little bald wrinkly smiling man."
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: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.