View Single Post
Old 12-31-07, 01:15 PM   #2
fivefeet8
Ngemu Mod
 
Join Date: Jul 2003
Location: Fresno, CA
Posts: 1,886
Default Re: MySQL Export to XLS using Classic ASP

The PEAR repository does have an Excel generation package for PHP.

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

It generates native Excel files and has numerous functions for formatting. It's programmed in PHP, it's free, and has good documentation. You'll need to program the exporting part yourself, but once you've gotten the data from the Mysql database, creating the excel sheet and formatting is pretty straightforward.

I've actually used it on a production site that the company I work for uses to generate quarterly reports in Excel.
__________________
[i7 2600k @4.4ghertz][2x4 GB DDR3 1600][EVGA GTX570 1.280GB SC][EVGA GTX460 physx][Asrock Extreme7 Gen3 Z68][2xSeagate 160 Gb SATA HD raid0][Seagate 250 GB SATA2 HD][Sony Bravia 40' 1080p LCD HDTV][NEC 3520a DVD+-DLw][Windows 7 Ultimate x64][Rosewill 1000w]
fivefeet8 is offline   Reply With Quote