MySQL -> PHP -> MS Excel?

Posted by me on November 25, 2008, 5:15 pm

Please log in for more thread options

On Tue, 25 Nov 2008 21:04:43 +0100, Iván Sánchez Ortega

show/hide quoted text

I can google too:_ ...but it doesn't really help me to know what's
good and what's not. That's why I am looking for recommendations here.

Posted by Iván Sánchez on November 25, 2008, 6:23 pm

Please log in for more thread options

me wrote:

show/hide quoted text

Don't take me bad, but you should read "How To Ask Questions The Smart Way"
by Eric Steven Raymond, here:

http://www.catb.org/~esr/faqs/smart-questions.html

In other words: if you seek personal recomendations, please say so. If your
client has special needs ("Excel! At one click!") Your first question was
very, very generic.

For the question at hand: Personally, I'd stick with .csv files. As I use
OpenOffice and I'm not tied to any macro-ridden excel-based workflow, they
perform quite well for my needs.

Cheers,
--
----------------------------------
IvÃ¡n SÃ¡nchez Ortega -ivan-algarroba-sanchezortega-punto-es-

"It is time I stepped aside for a less experienced and less able man."
- Professor Scott Elledge on his retirement from Cornell

Posted by me on November 25, 2008, 10:50 pm

Please log in for more thread options

On Wed, 26 Nov 2008 00:23:05 +0100, Iván Sánchez Ortega

show/hide quoted text

I understand. I already suggested that to the client. He wants pure
Excel format, so I need to find another solution.

Thanks,

Posted by =?ISO-8859-1?Q?=22=C1lvaro_G=2 on November 26, 2008, 3:15 am

Please log in for more thread options

me escribió:
show/hide quoted text

There's a Pear package:

http://pear.php.net/package/Spreadsheet_Excel_Writer

It's not finished and it's probably abandoned like many other Pear
packages; but it generates native Excel files (there're many libraries
out there that merely generate HTML and disguise it with an *.xls
extension) and it should be enough for basic usage.

--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--

Posted by sheldonlg on November 26, 2008, 7:09 am

Please log in for more thread options

me wrote:
show/hide quoted text

I have an excel class that I downloaded from somewhere and modified to
my own tastes. It is limited to being able to put up only one block of
data, with a header row and a title row. If you email me at

sheldon AT slgdev DOT com

I will send it to you. When run, it asks the user whether they want to
open or save the Excel file (so long as they don't have browser settings
set to open in html -- the IE default).