This article mainly shares with you PHP reading Excel and shows the implementation code. I hope it can help everyone.
Use this tool. phpExcelReaderBecause it’s free
Writeindex.php
Introduce the resource fileexcel_reader2.php
.
dump(true,true);//输出结果,其中dump()函数的两个参数用于指定否需要显示excel文件中原有的行号和列号 ?>
Because this tool is from ancient times, there will be error prompts when setting it up directly in the php7 environment.
Modificationexcel_reader2.php
The following places are used to modify and block errors..
Line 98 logoutfunction OLERead() { }
This function
putssplit(
Replace withexplode(
## in
index.php
Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Spreadsheet_Excel_Reader has a deprecated constructor in D:\xampp\htdocs\pdfreader\excel_reader2.php on line 312Warning: gmdate() expects parameter 2 to be integer, float given in D:\xampp\htdocs\pdfreader\excel_reader2.php on line 79Warning: gmdate() expects parameter 2 to be integer, float given in D:\xampp\htdocs\pdfreader\excel_reader2.php on line 79
is as follows? Easy, come~
error_reporting(0);
Related recommendations:
##Detailed introduction Sample code for PHPExcel to read Excel time
php generates and reads excel files
The above is the detailed content of PHP reads Excel and displays the implementation code. For more information, please follow other related articles on the PHP Chinese website!