thinkphp利用phpExcelReader导入Excel表格到数据库
thinkphp利用phpExcelReader导入Excel表格到数据库
自己用的，用法就是这样大家可以根据自己的需求改改，
在写的过程中发现无法用tp自带的add() where()等函数所以写成了原生写法，如果哪位大神知道是怎么回事请不吝告知
phpExcelReader下载地址：http://sourceforge.net/projects/phpexcelreader/
//==============================
关于phpExcelReader有以下几点说明用之前请阅读
1. Excel/reader.php文件中已经用require_once包含了oleread.inc文件，所以在调用的时候不需要加载oleread.inc。
2. 官方提供的excel文件jxlwtest.xls已经损坏，无法读取与解析。
3. 原始Excel/reader.php文件的第31行（如下）会导致错误：
require_once ‘Spreadsheet/Excel/Reader/OLERead.php’;
原因是Spreadsheet/Excel/Reader/OLERead.php文件不存在。其实这里所需的文件就是Excel/oleread.inc，把require_once后的文件名改成 ’oleread.inc’即可。
4. 原始Excel/reader.php文件的第261行会导致如下警告：
Deprecated: Assigning thereturn value of new by reference is deprecated
其原因是此行的 =& 符号已经在PHP 5.3中被废弃。根据该符号在此处的作用，直接将其改为 = 即可。
5. PHP-ExcelReader不支持Excel 2007文档的解析，也就是说扩展名为xlsx的Excel文件不能使用本类库进行解析；它只针对扩展名为xls的Excel文件。
6. PHP-ExcelReader的设置编码方法基于iconv命 令，setOutputEncoding方法的参数就是需要设置的字符集的名称。要使这个方法生效需要给本地的PHP环境安装iconv扩展；若本地 PHP环境没有iconv扩展，那么PHP-ExcelReader的编码方法默认为Unicode。
7.PHP-ExceReader在解析整数的时候可能会出现精度上的误差，如58解析为57.5，原因不明。能做的就是解析完后检查下数据，然后四舍五入（如果有必要的话）。
8. PHP-ExcelReader对于excel文件中的空白单元格，要么直接跳过不存放到结果数组中，要么保存为0或者””（空字符串）。
源码见：http://www.jakehu.me/?p=109
AD：真正免费，域名+虚机+企业邮箱=0元
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1378
52
Learn about introductory code examples for Python programming
Jan 04, 2024 am 10:50 AM
Learn about Python programming with introductory code examples Python is an easy-to-learn, yet powerful programming language. For beginners, it is very important to understand the introductory code examples of Python programming. This article will provide you with some concrete code examples to help you get started quickly. Print HelloWorldprint("HelloWorld") This is the simplest code example in Python. The print() function is used to output the specified content
PHP variables in action: 10 real-life examples of use
Feb 19, 2024 pm 03:00 PM
PHP variables store values during program runtime and are crucial for building dynamic and interactive WEB applications. This article takes an in-depth look at PHP variables and shows them in action with 10 real-life examples. 1. Store user input $username=$_POST["username"];$passWord=$_POST["password"]; This example extracts the username and password from the form submission and stores them in variables for further processing. 2. Set the configuration value $database_host="localhost";$database_username="username";$database_pa
Go language programming examples: code examples in web development
Mar 04, 2024 pm 04:54 PM
"Go Language Programming Examples: Code Examples in Web Development" With the rapid development of the Internet, Web development has become an indispensable part of various industries. As a programming language with powerful functions and superior performance, Go language is increasingly favored by developers in web development. This article will introduce how to use Go language for Web development through specific code examples, so that readers can better understand and use Go language to build their own Web applications. 1. Simple HTTP Server First, let’s start with a
From beginner to proficient: Code implementation of commonly used data structures in Go language
Mar 04, 2024 pm 03:09 PM
Title: From Beginner to Mastery: Code Implementation of Commonly Used Data Structures in Go Language Data structures play a vital role in programming and are the basis of programming. In the Go language, there are many commonly used data structures, and mastering the implementation of these data structures is crucial to becoming a good programmer. This article will introduce the commonly used data structures in the Go language and give corresponding code examples to help readers from getting started to becoming proficient in these data structures. 1. Array Array is a basic data structure, a group of the same type
Java implements simple bubble sort code
Jan 30, 2024 am 09:34 AM
The simplest code example of Java bubble sort Bubble sort is a common sorting algorithm. Its basic idea is to gradually adjust the sequence to be sorted into an ordered sequence through the comparison and exchange of adjacent elements. Here is a simple Java code example that demonstrates how to implement bubble sort: publicclassBubbleSort{publicstaticvoidbubbleSort(int[]arr){int
Huawei Cloud Edge Computing Interconnection Guide: Java code examples to quickly implement interfaces
Jul 05, 2023 pm 09:57 PM
Huawei Cloud Edge Computing Interconnection Guide: Java Code Samples to Quickly Implement Interfaces With the rapid development of IoT technology and the rise of edge computing, more and more enterprises are beginning to pay attention to the application of edge computing. Huawei Cloud provides edge computing services, providing enterprises with highly reliable computing resources and a convenient development environment, making edge computing applications easier to implement. This article will introduce how to quickly implement the Huawei Cloud edge computing interface through Java code. First, we need to prepare the development environment. Make sure you have the Java Development Kit installed (
Guidance and Examples: Learn to implement the selection sort algorithm in Java
Feb 18, 2024 am 10:52 AM
Java Selection Sorting Method Code Writing Guide and Examples Selection sorting is a simple and intuitive sorting algorithm. The idea is to select the smallest (or largest) element from the unsorted elements each time and exchange it until all elements are sorted. This article will provide a code writing guide for selection sorting, and attach specific Java sample code. Algorithm Principle The basic principle of selection sort is to divide the array to be sorted into two parts, sorted and unsorted. Each time, the smallest (or largest) element is selected from the unsorted part and placed at the end of the sorted part. Repeat the above
How to use PHP to write inventory management function code in the inventory management system
Aug 06, 2023 pm 04:49 PM
How to use PHP to write the inventory management function code in the inventory management system. Inventory management is an indispensable part of many enterprises. For companies with multiple warehouses, the inventory management function is particularly important. By properly managing and tracking inventory, companies can allocate inventory between different warehouses, optimize operating costs, and improve collaboration efficiency. This article will introduce how to use PHP to write code for inventory warehouse management functions, and provide you with relevant code examples. 1. Establish the database before starting to write the code for the inventory warehouse management function.
