项目中要实现一个通过浏览器导入excel数据到云端数据库的功能,利用PHPExcel 可以非常方便的实现对excel文档的读取。代码如下:
/*
* 读excel
*/
public function excelread($filename, $encode = 'utf-8')
{
/* 导入phpExcel核心类 注意 :你的路径跟我不一样就不能直接复制 */
require_once dirname(__FILE__) . '/../../Classes/PHPExcel.php';
// include_once('./Excel/PHPExcel.php');
/**
* 读取excel $filename 路径文件名 $encode 返回数据的编码 默认为utf8
* 以下基本都不要修改
*/
$objReader = PHPExcel_IOFactory::createReader('Excel5');
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($filename);
$objWorksheet = $objPHPExcel->getActiveSheet();
$highestRow = $objWorksheet->getHighestRow();
$highestColumn = $objWorksheet->getHighestColumn();
$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;
}