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

加分点:您可以在其讨论论坛中寻求帮助和你会在一天之内得到作者本人的回复，真是令人印象深刻.

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屋！