Re: Excel sheet operations with PHP
| From: | Justin French | Date: | Wed, 23 Oct 2002 11:17:34 +0000 |
| Subject: | Re: Excel sheet operations with PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-121060@lists.php.net to get a copy of this message | ||
Is what available now??
Justin
on 23/10/02 9:11 PM, Balaji Ankem (balaji.ankem@wipro.com) wrote:
> 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
>>
>