csv和excel php 解析_PHP 使用 phpoffice/phpexcel 读取 / 导出 xls/xlsx 或 CSV 表格文件数据...

use PHPExcel_IOFactory;

use PHPExcel_Cell;

$file = "test.xlsx";

$type = strtolower(pathinfo($file, PATHINFO_EXTENSION));

$file_dir = str_replace(substr($_SERVER['DOCUMENT_ROOT'], -6), '', $_SERVER['DOCUMENT_ROOT']);

$path = $file_dir . 'public/uploads/excel/' . $file;

if (!file_exists($path)) {

die('no file!');

}

//根据不同类型分别操作

if ($type == 'xlsx' || $type == 'xls') {

$objPHPExcel = PHPExcel_IOFactory::load($path);

} else if ($type == 'csv') {

$objReader = PHPExcel_IOFactory::createReader('CSV')

->setDelimiter(',')

->setInputEncoding('GBK')//不设置将导致中文列内容返回boolean(false)或乱码

->setEnclosure('"')

->setLineEnding("\r\n")

->setSheetIndex(0);

$objPHPExcel = $objReader->load($path);

} else {

die('Not supported file types!');

}

//选择标签页

$sheet = $objPHPExcel->getSheet(0);

//获取行数与列数,注意列数需要转换

$highestRowNum = $sheet->getHighestRow();

$highestColumn = $sheet->getHighestColumn();

$highestColumnNum = PHPExcel_Cell::columnIndexFromString($highestColumn);

//取得字段，这里测试表格中的第一行为数据的字段，因此先取出用来作后面数组的键名

$filed = array();

for ($i = 0; $i < $highestColumnNum; $i++) {

$cellName = PHPExcel_Cell::stringFromColumnIndex($i) . '1';

$cellVal = $sheet->getCell($cellName)->getValue();//取得列内容

$filed [] = $cellVal;

}

//开始取出数据并存入数组

$data = array();

for ($i = 2; $i <= $highestRowNum; $i++) {//ignore row 1

$row = array();

for ($j = 0; $j < $highestColumnNum; $j++) {

$cellName = PHPExcel_Cell::stringFromColumnIndex($j) . $i;

$cellVal = $sheet->getCell($cellName)->getValue();

$row[$filed[$j]] = $cellVal;

}

$data [] = $row;

}

var_dump($data);

//完成，可以存入数据库了

die;

gaodevops