Home > Backend Development > PHP Tutorial > Use php to read excel and insert into mysql

Use php to read excel and insert into mysql

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-07-06 13:52:28
Original
797 people have browsed it

How to read and then import more than 400,000 pieces of data in excel
I tried twice using phpexcel but failed.

Reply content:

How to read and then import more than 400,000 pieces of data in excel
I tried twice using phpexcel but failed.

Save excel as a csv file first, then read the csv and write it to mysql
It is too inefficient to directly process such a large excel.

fputcsv

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
php data acquisition?
From 1970-01-01 08:00:00
0
0
0
PHP extension intl
From 1970-01-01 08:00:00
0
0
0
How to learn php well
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template