正文

php excel读取

IP云
IP云V管理员/6 阅读
08/17
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

当然首先要判断是否有文件和文件类型，接着把文件保存到某个路径中

/**
* 读取excel数据
* @author Red
* @date
* @param $filename 文件所在路径+文件名
* @param string $encode
* @param $file_type
* @return array
*/
function readExcel($filename, $encode = 'utf-8', $file_type)
{
include './plugins/excel/PHPExcel.php';
include './plugins/excel/PHPExcel/Reader/Excel2007.php';
include './plugins/excel/PHPExcel/Writer/Excel5.php';
include './plugins/excel/PHPExcel/Writer/Excel2007.php'; if ($file_type == 'xlsx') {
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
} else {
$objReader = PHPExcel_IOFactory::createReader('Excel5');
} $objReader->setReadDataOnly(true); $objPHPExcel = $objReader->load($filename);
$objWorksheet = $objPHPExcel->getActiveSheet();
$hightestrow = $objWorksheet->getHighestRow();
$highestColumn = $objWorksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$excelData = array();
//从第二行开始
for ($row = 2; $row <= $hightestrow; $row++) {
for ($col = 0; $col < $highestColumnIndex; $col++) {
$excelData[$row][] = (string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
}
} return $excelData;
}