关于表格导入

A   use PHPExcel_IOFactory;  use PHPEXCEL; 

以表单形式传递到后台,后台通过$_FILES函数接收,获取地址

C  BM('')->read($file);//读取表格内容

D

public function read($filename,$encode='utf-8')
{
$result = array();
$objReader = PHPExcel_IOFactory::createReader('Excel5');
if(!$objReader->canRead($filename)){
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
if(!$objReader->canRead($filename)){
echo 'no Excel';
return;
}
}
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($filename);
$AllSheets = $objReader->load($filename);
$AllSheet = $AllSheets->getAllSheets();
foreach ($AllSheet as $sheet) {
$result[$sheet->getTitle()] = $sheet->toArray();
}
return $result;
}

 


原文地址:https://www.cnblogs.com/mlls/p/7598044.html