View Single Post
Old 01-01-08, 03:52 PM   #3
technoid
Registered User
 
Join Date: Jul 2004
Location: Denton, Texas
Posts: 505
Default Re: MySQL Export to XLS using Classic ASP

Quote:
Originally Posted by fivefeet8
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.
Very Cool... I'm off to get it now, Thanks
__________________
Antec-SOLO | ASUS-P5Q-SE | C2D-E8600 | AC-Freezer-7-Pro | Seasonic-S12-550W | 3GB-KVR-PC2-6400 | GTX-560Ti | SB-XtremeGamer | Pioneer-BDR-205 | Samsung-S223B | Dell-U2412M
technoid is offline   Reply With Quote