RE: [PHP] Is there any Possible Way to get data from Excel File?
How about using COM? http://www.php.net/manual/en/ref.com.php I haven't used this personally but perhaps it could be a useful solution. However there may be issues like running a copy of EXCEL on the server. Best Regards Feroze Jar Jar Binks will be Jedi!! -Original Message- From: Justin French [mailto:[EMAIL PROTECTED]] Sent: 20 March, 2002 2:11 PM To: php Subject: Re: [PHP] Is there any Possible Way to get data from Excel File? Anything is possible :) I'd recommend that the Excell file be exported as a CSV, which will be a LOT easier to munch through, because it won't contain formatting, or anything else. Justin French indent.com.au soundpimps.com Jack wrote: Dear all What i'm planning to do is to use php to grep the data from a Excel file and then insert it to the MySQL Database, so is there any possible way that the php can grep the data from an Excel File? Thx all Jack [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Is there any Possible Way to get data from Excel File?
I think that the smartest way to insert data from Excel to mySQL is saving Excel file as CSV and then inserting the whole file. This is ofcourse only if you wan't to insert the whole file. Niklas -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: 20. maaliskuuta 2002 8:01 To: [EMAIL PROTECTED] Subject: [PHP] Is there any Possible Way to get data from Excel File? Dear all What i'm planning to do is to use php to grep the data from a Excel file and then insert it to the MySQL Database, so is there any possible way that the php can grep the data from an Excel File? Thx all Jack [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Is there any Possible Way to get data from Excel File?
Anything is possible :) I'd recommend that the Excell file be exported as a CSV, which will be a LOT easier to munch through, because it won't contain formatting, or anything else. Justin French indent.com.au soundpimps.com Jack wrote: Dear all What i'm planning to do is to use php to grep the data from a Excel file and then insert it to the MySQL Database, so is there any possible way that the php can grep the data from an Excel File? Thx all Jack [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php