Maybe this is a mod_perl issue, but I need to have a user download a dynamically created spreadsheet. (created using Spreadsheet::WriteExcel)

Basically, here is how it should go..
Click link to download sheet
mod_perl module pulls q's from the DataBase,
Prints "Content-type: application/excel(or some needed varient)"
Prints "Content-Disposition: inline; filename=$name"
Then the spreadsheet is opened like so...
my $workbook = Spreadsheet::WriteExcel->new("-");


Only, the data isnt sent to the browser. Now, maybe I'm quite young with this stuff but I'd think since I set the Content-type headers that it would prompt the user to save the file.

It works outside of mod_perl

I have been reading about 'headers_out()' and 'send_httpd_header'(I believe thats what it was...) and have gotten just about nowhere. I've got the Eagle book, on mod_perl, and cant seem to find anything on Disposition. There is a discussion here on the mod_perl archives that is similar, but doesnt seem to offer me a solution.

In httpd.conf I have:
PerlSendHeader On
but is that needed? I read that in a discussion somewhere. Has anybody done this before? I mean, I'm sure somebody has, but umm, how did they do it?
Regardless, thanks for pointing me in the right direction if its at all possible.

_14k4 - webmaster@860.org (www.poorheart.com)

In reply to Using Spreadsheet::WriteExcel with mod_perl and Content-Disposition? by one4k4

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.