in reply to Re^4: capturing STDOUT
in thread capturing STDOUT

Here's your problem:

print "Content-type: application/vnd.ms-excel\n";
#print "Content-Disposition: attachment; filename=$filename\n\n";

[download]

HTTP headers need to end in a double line break. Your Content-Type header has only one. Your Content-Disposition header would do the trick, but it's commented out.

perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'

Replies are listed 'Best First'.
Re^6: capturing STDOUT
by Anonymous Monk on Oct 10, 2012 at 17:48 UTC

    I followed your suggestion but the file is getting download with prompt.

    How do I Print Xcel sheet in the browser

    Here My requirement is "User should able to copy the columns content from browser ouput". When I use html , we are able to copy the rows and not columns

    Why I'm preferring Xls , bcoz user should able to download the files as xls or csv with 'Sava as' Option

    Please help me on this

[reply]

      You could try setting Content-Disposition: inline, but be aware that the Content-Disposition header is just advisory. The browser is free to do what it likes with the file: open it in an external program, save it to disk, or stir some eggs and cream into it and make it into a lovely soufflé. The inline disposition indicates that you'd like it to open within the browser window, but I don't think very many browsers are capable of doing that.

      Personally I'd format it as an HTML table and use a little Javascript trickery to allow people to select columns and copy them to the clipboard.

      perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'
[reply]
[d/l]

        Content-Disposition: inline, didn't work

        Can you please provide the code for "format it as an HTML table and use a little Javascript trickery to allow people to select columns and copy them to the clipboard"

        Thanks in advance

[reply]

In Section Seekers of Perl Wisdom