PHP将Excel导入数据库（xls& xlsx） [英] PHP import Excel into database (xls & xlsx)

问题描述

我试图搜索一些插件将Excel文件导入MySQL数据库，其中之一是 http://code.google.com/p/php-excel-reader/

I tried to search for some plugins to import Excel file into MySQL database, one of them is http://code.google.com/p/php-excel-reader/

该工具非常强大，可以显示整个excel内容到html。

The tool is so powerful that it displays the entire excel content into html.

但是，我想只需要读取Excel文件并将内容解压缩到数组中，然后写入一个SQL语句进入数据库。

However, I think I just need to read the Excel file and extract the contents, for example, into an array, and then write a SQL statement for entering into the database.

有没有什么好的代码和包？谢谢！

Would there be any good codes and packages? Thanks!

推荐答案

这是最适合的文档和示例插件。

This is best plugin with proper documentation and examples

加点：，您可以在其讨论论坛中寻求帮助， a>，您将在作者本人的一天内获得回应，非常令人印象深刻。

Plus point: you can ask for help in its discussion forum and you will get response within a day from the author itself, really impressive.

这篇关于PHP将Excel导入数据库（xls& xlsx）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！