import('phpexcel.Classes.PHPExcel');
$objPHPExcel = new \PHPExcel();
$PHPReader = new \PHPExcel_Reader_Excel2007(); //默认是excel2007
$filePath="".$list[0]['url']."";
if(!$PHPReader->canRead($filePath)){
$PHPReader = new \PHPExcel_Reader_Excel5(); //如果不成功的时候用以前的版本来读取
if(!$PHPReader->canRead($filePath)){
echo 'no Excel';
return ;
}
}
$PHPExcel = $PHPReader->load($filePath);
$currentSheet = $PHPExcel->getSheet(0);
//取得一共有多少列
$allColumn = $currentSheet->getHighestColumn();
//取得一共有多少行
$allRow = $currentSheet->getHighestRow();
//循环读取数据,默认是utf-8输出
$str = '';
for($currentRow = 1;$currentRow<=$allRow;$currentRow++)
{
for($currentColumn='A';$currentColumn<=$allColumn;$currentColumn++)
{
$address = $currentColumn.$currentRow;
$str = $str.$currentSheet->getCell($address)->getValue()."~";
}
$str = $str.'*';
}
$arr = explode('*',rtrim($str,'*'));
for($i=0;$i<count($arr);$i++)
{
$arr[$i] = explode('~',rtrim($arr[$i],'~'));
}
//$arr 二维数组
PHP读取excel文档
最新推荐文章于 2024-09-15 23:43:07 发布