RE: [PHP] Excel sheet operations with PHP
| From: | Balaji Ankem | Date: | Wed, 23 Oct 2002 11:11:48 +0000 |
| Subject: | RE: [PHP] Excel sheet operations with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-121059@lists.php.net to get a copy of this message | ||
Hi Is it available now?
-----Original Message-----
From: Justin French [mailto:justin@indent.com.au]
Sent: Wednesday, October 23, 2002 4:02 PM
To: Balaji Ankem; php-general@lists.php.net
Subject: Re: [PHP] Excel sheet operations with PHP
I save excel sheets as CSV (Windows, not Mac), then use functions like
fget_csv() to read the CSV file one line at a time, inserting into MySQL
with standard insert queries.
Have a go, and let me know if you need more help. I'm pretty sure there
are decent samples of everything except the mysql stuff in the manual...
I'll make the assumption you know how to insert :)
Justin
on 23/10/02 8:19 PM, Balaji Ankem (balaji.ankem@wipro.com) wrote:
> Hi Friend,
> How to read from Excel file and to insert in to the database? Do we
> have any option to import excel sheet to Mysql database through php?
> Or any other mechanism?
>
> Any inputs will be greatly appreciable.
>
> Thanks and Regards
> Balaji
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
**************************Disclaimer************************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***************************************************************************************
**************************Disclaimer************************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***************************************************************************************