MySQL -> PHP -> MS Excel?

If you were Registered and logged in, you could reply and use other advanced thread options

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

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

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

me wrote:

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

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

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

me escribió:

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

me wrote:

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).

This Thread

get this group's latest topics as an RSS feed

add this group's latest topics to your My MSN content

add this group's latest topics to your My Yahoo content

add this group's latest topics to your Google content

Yahoo!

Google

Windows Live

del.icio.us digg

digg

Netscape