Re: PHP Working With Excel File ?
| From: | Ben Ramsey | Date: | Mon, 01 Nov 2004 19:13:53 +0000 |
| Subject: | Re: PHP Working With Excel File ? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-200859@lists.php.net to get a copy of this message | ||
Matt M. wrote:
You could also just use the MySQL database and have a PHP script that outputs the contents of your report to a CSV (comma-separated value) file with an extension of .csv. Excel will automatically open these files without problem. -- Ben Ramsey Zend Certified Engineer http://benramsey.com --------------------------------------------------- Atlanta PHP - http://www.atlphp.org/ The Southeast's premier PHP community. ---------------------------------------------------Can PHP work with Excel files as database ? If not, how can I conver it to MySQL format and reconvert it to Excel 'coz I need it to report it in Excel format,if you are on windows you could use a com object. if you have access to perl, you could use http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2603/ParseExcel.pm