本方法使用PHPEXCEL插件读取excel文件转化为数组 插件下载地址:http://phpexcel.codeplex.com/
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
<?php
/**
* @desc PHPEXCEL导入
* return array();
*/
function
importExcel(
$file
)
{
require_once
'PHPExcel.php'
;
require_once
'PHPExcel/IOFactory.php'
;
require_once
'PHPExcel/Reader/Excel5.php'
;
$objReader
= PHPExcel_IOFactory::createReader(
'Excel5'
);
//use excel2007 for 2007 format
$objPHPExcel
=
$objReader
->load(
$file
);
$sheet
=
$objPHPExcel
->getSheet(0);
$highestRow
=
$sheet
->getHighestRow();
// 取得总行数
$highestColumn
=
$sheet
->getHighestColumn();
// 取得总列数
$objWorksheet
=
$objPHPExcel
->getActiveSheet();
$highestColumnIndex
= PHPExcel_Cell::columnIndexFromString(
$highestColumn
);
$excelData
=
array
();
for
(
$row
= 1;
$row
<=
$highestRow
;
$row
++) {
for
(
$col
= 0;
$col
<
$highestColumnIndex
;
$col
++) {
$excelData
[
$row
][] =(string)
$objWorksheet
->getCellByColumnAndRow(
$col
,
$row
)->getValue();
}
}
return
$excelData
;
}
//用法:
importExcel(
'test.xsl'
);
|