Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Modules for creating EXCEL compatible files on webserver

by dasgar (Curate)
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
Replies are listed 'Best First'.
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 examining the Monastery: (9)
As of 2015-07-08 08:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (98 votes), past polls