Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: Modules for creating EXCEL compatible files on webserver

by dasgar (Deacon)
on Jan 27, 2014 at 15:54 UTC ( #1072243=note: print w/ replies, xml ) Need Help??


in reply to Modules for creating EXCEL compatible files on webserver

One option would be to create a CSV file, which Excel can read.

If the HTML output is a table, I've also seen one approach of saving the page via the browser and give it an .xls file extension. Excel seems to be able to open and read this. Not exactly a "pretty" solution, but it seems to work. (Not advocating this route. Just tossing out ideas.)

If the web server happens to be on a Windows system that has Excel installed, you could also use Win32::OLE to control Excel to create the Excel file for download. Otherwise, my guess is that Corion's suggestion maybe the best route to go.


Comment on Re: Modules for creating EXCEL compatible files on webserver
Re^2: Modules for creating EXCEL compatible files on webserver
by Skeeve (Vicar) on Jan 28, 2014 at 13:31 UTC

    ++ for the idea.

    The disadvantages of CVS are, as far as I can see:

    1. the user needs to specify the column formats when importing/opening the file
    2. columns are most times misinterpreted if you choose "standard"
    3. numbers get mixed up

    That's why I always used MMM::Sylk. I'm trying now out Excel::Writer::XLSX as it is the successor of the module Corion recommended.


    s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
    +.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1072243]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (15)
As of 2014-10-24 18:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (134 votes), past polls