Matt M. wrote:
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

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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to