phpexcel合并单元格导出_phpexcel读取合并单元格的值

phpexcel读取合并单元格的值0

qq738002013.09.05浏览259次分享举报

include_once 'phpExcel/Classes/PHPExcel/IOFactory.php';

$loadfile=$uploadfile_xls;

if (!file_exists($loadfile)) {

exit("Please run 05featuredemo.php first.\n");

}

$objReader = PHPExcel_IOFactory::createReader('Excel5');

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

$sheet = $objPHPExcel->getSheet(0); // 读取第一个工作表(编号从 0 开始)

$highestRow = $sheet->getHighestRow(); // 取得总列数

for ($row = 2; $row <= $highestRow; $row++) {

$xx=$sheet->getCell("A$row")->getValue();

if(empty($xx)){

$xx="无";

}else{

$xx=iconv('utf-8','gbk',$xx);

}

echo $xx;

echo "
============
";

$num = $sheet->getCellByColumnAndRow(5, $row)->getValue();

$content = $sheet->getCellByColumnAndRow(6, $row)->getValue();

//

$theme = $sheet->getCellByColumnAndRow(0, $row)->getValue();

$num=iconv('utf-8','gbk',$num);

$content=iconv('utf-8','gbk',$content);

//

$theme=iconv('utf-8','gbk',$theme);

if($num && $content){

$arr=array("pid"=>$pid,"content"=>$content,"num"=>$num,"theme"=>$theme);

//insertxintable("requirement_detail",$arr);

}

$show_arr[]=$arr;

}

unset($objPHPExcel);

}

输出:

大年初二的春节祝福

============

无

============

无

============

无

============

无

============

无

============

无

============

怎么让获取的都是 “大年初二的春节祝福”?

实在不行的话，程序控制，如果为空，值为向上最靠近的那个?怎么控制一下?