下载PHPExcel插件
/**
* 把Excel内容转化成数组
* @param string $file_path 文件地址
* @param integer $sheet 工作表
* @author liuyupeng [chenyu9205@163.com]
* @version 2017-04-19T19:01:22+0800
*/
private function excelToArray($file_path, $sheet = 0){
Vendor("PHPExcel.Classes.PHPExcel.php");
Vendor("PHPExcel.Classes.PHPExcel.IOFactory");
$r = ["status" => 1, "info" => "文件检测成功"];
if(empty($file_path) || !file_exists($file_path)){
$r = ["status" => 0, "info" => "Excel 读取错误"];
}
if($r["status"]){
$PHPReader = new \PHPExcel_Reader_Excel2007();
if(!$PHPReader->canRead($file_path)){
$PHPReader = new \PHPExcel_Reader_Excel5();
if(!$PHPReader->canRead($file_path)){
$r = ["status" => 0, "info" => "Excel 读取错误"];
}
}
}
if($r["status"]){
$PHPExcel = $PHPReader->load($file_path);
$currentSheet = $PHPExcel->getSheet($sheet);
$allColumn = $currentSheet->getHighestColumn();
$allRow = $currentSheet->getHighestRow();
$dataExcel = array();
for($rowIndex = 1; $rowIndex <= $allRow; $rowIndex ++){
for($colIndex = "A"; $colIndex <= $allColumn; $colIndex ++){
$location = $colIndex.$rowIndex;
$cell = $currentSheet->getCell($location)->getValue();
if($cell instanceof PHPExcel_RichText){
$cell = $cell->__toString();
}
$dataExcel[$rowIndex][$colIndex] = $cell;
}
}
$r = ["status" => 1, "info" => "文件内容获取成功"];
$r["data"] = $dataExcel;
$r["allRow"] = $allRow;
$r["allColumn"] = $allColumn;
}
return $r;
}