PHPEXCEL 使用小记

;getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle(''D1'')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$objPHPExcel->getActiveSheet()->getStyle(''A2''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle(''B2''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle(''C2''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle(''D2''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle(''E2''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

if($this->_db->num_rows($query)>0)
{
$i=3;
while ($row = $this->_db->fetch_assoc($query))
{
$objPHPExcel->getActiveSheet()->setCellValue(''A''.($i),"BOX ".$row[''box_num'']);
$objPHPExcel->getActiveSheet()->setCellValue(''B''.($i),sprintf("%.2f",$row[''volume_weight'']));
$objPHPExcel->getActiveSheet()->setCellValue(''C''.($i),sprintf("%.2f",$row[''box_weight'']));
$objPHPExcel->getActiveSheet()->setCellValue(''D''.($i),sprintf("%.2f",$row[''system_weight'']));
$objPHPExcel->getActiveSheet()->setCellValue(''E''.($i),sprintf("%.2f",$row[''real_weight'']));

$objPHPExcel->getActiveSheet()->getStyle(''A''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle(''B''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle(''C''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle(''D''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle(''E''.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$i++;
}
}

$fileName="exportBox.xls";
$filePath = dirname(dirname("__FILE__"))."/template/".$fileName;
$path = "./template/".$fileName;
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
if(file_exists($path)){
chmod($path, 0777);
unlink($path);
$objWriter->save($path);
header(''application/vnd.ms-excel'');
header(''Content-Disposition: attachment;filename=weight-''.$this->_packInfos["o_id"].".xlsx");
readfile($filePath);
die();
}
else
{
$objWriter->save($path);
header(''application/vnd.ms-excel'');
header(''Content-Disposition: attachment;filename=weight-''.$this->_packInfos["o_id"].".xlsx");
readfile($filePath);
die();
}

注：上面的php生成excel的方式是直接使用A标签形式的，如果使用ajax，可以不使用header，直接echo $path,前台window