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

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

Replies are listed 'Best First'.
Re^7: capturing STDOUT
by tobyink (Canon) on Oct 10, 2012 at 21:34 UTC

    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]

        Such code would need to be written in Javascript and not in Perl. This is outside the focus of this site.

        What Javscript code to use would depend on what Javascript framework you use. I think there are numerous methods to display spreadsheets in a browser, for example handsontable.

        You will have to learn about HTML and Javascript if you choose to go down that route.

[reply]

In Section Seekers of Perl Wisdom