Re: Interfacing with Excel

Are you getting an Excel2000 file and don't have Excel to open it? Just have it sent to you as CSV (Comma Separated Values) rather than XLS; that would be easy to parse. If you have direct access to the MySQL box, copy the file there and do the import directly. Check the MySQL docs. A more elaborate way would be to have the Excel file sent with XML markup, but from the sounds of it you'd be using a sledgehammer to swat flies. Miles Thompson At 11:00 AM 6/28/01 +0530, Sharat Hegde wrote:

Hello, I have a web site on a Unix environment running PHP 3.0 and MySQL. I need to convert data in an Excel format to a MySQL database format periodically based on the input feed received in Excel format. the conversion to MySQL is not a problem at all. What I need help is to read data from an Excel 2000 format. How do I retrieve data from Excel 2000? The data is basically a 2 columnar data with currency names and conversion values. Thanks in advance. Regards, Sharat Hegde Phone: 6560360 Ext 4680 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net