Re: 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 (Parson) on Jan 28, 2014 at 13:31 UTC
++ for the idea. The disadvantages of CVS are, as far as I can see: the user needs to specify the column formats when importing/opening the file columns are most times misinterpreted if you choose "standard" 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	[reply] [d/l] [select]

Replies are listed 'Best First'.

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

++ for the idea.

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

the user needs to specify the column formats when importing/opening the file
columns are most times misinterpreted if you choose "standard"
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

[reply]
[d/l]
[select]