PHPExcel将Excel数据导入数据库
时间：2021-07-01 10:21:17
帮助过：13人阅读
<?
php
2 //PHPExcel读取导入Excel数据到数据库(2003,2007通用)使用方法:
3 //先用excel2array（）方法将excel表中的数据存储到数组，在从遍历二维数组将数据保存进数据库
4 require_once "./PHPExcel.class.php"
;
5 require_once "./PHPExcel/Cell/DataType.php"
;
6 require_once "./PHPExcel/IOFactory.php"
;
7 /**
8 * 将excel表中的数据存储到数组
9 * @param string $filename 文件名
10 * @return array
11 */
12 function excel2array(
$filename){
13 $ext =
pathinfo(
$filename, PATHINFO_EXTENSION);
//获取文件后缀名
14 if(
$ext == "xls"
){
15 $objReader = PHPExcel_IOFactory::createReader(‘Excel5‘
);
16 }
17 if(
$ext == "xlsx"
){
18 $objReader = PHPExcel_IOFactory::createReader(‘Excel2007‘
);
19 }
20
21 $objReader->setReadDataOnly(
true);
22 $objPHPExcel =
$objReader->load(
$filename);
23 $objWorksheet =
$objPHPExcel->
getActiveSheet();
24 $highestRow =
$objWorksheet->getHighestRow();
//取得行数
25 $highestColumn =
$objWorksheet->
getHighestColumn();
26 $highestColumnIndex = PHPExcel_Cell::columnIndexFromString(
$highestColumn);
//取得列数
27 $excelData =
array();
28 for (
$row = 2;
$row <=
$highestRow;
$row++
) {
29 for (
$col = 0;
$col <
$highestColumnIndex;
$col++
) {
30 $excelData[
$row][] =
$objWorksheet->getCellByColumnAndRow(
$col,
$row)->
getValue();
31 }
32 }
33 return $excelData;
34 }
PHPExcel将Excel数据导入数据库
标签：cti blog pre reader func array span cell nan
