import ( "Org.Util.PHPExcel" );
import ( "Org.Util.PHPExcel.Writer.Excel2007" );
import ( "Org.Util.PHPExcel.IOFactory.php" );
$date = date ( "Y_m_d", time () );
$fileName = "水果批发系统-".xls";
// 创建PHPExcel对象，注意，不能少了\
$objPHPExcel = new \PHPExcel ();
$objProps = $objPHPExcel->getProperties ();
// 设置表头
$key = ord ( "A" );
// print_r($headArr);exit;
$objPHPExcel->setActiveSheetIndex ( 0 )->setCellValue ( 'A1', '水果批发系统-导出数据时间：' . date ( 'Y-m-d H:i:s', time () ) );
$objPHPExcel->setActiveSheetIndex ( 0 )->mergeCells ( 'A1:R1' );
$objPHPExcel->setActiveSheetIndex(0)->getStyle('A1:R1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet ()->getColumnDimension ( 'E' )->setWidth ( 22 );
$objPHPExcel->getActiveSheet ()->getColumnDimension ( 'J' )->setWidth ( 31 );
$objPHPExcel->getActiveSheet ()->getColumnDimension ( 'L' )->setWidth ( 31 );
$objPHPExcel->getActiveSheet ()->getColumnDimension ( 'N' )->setWidth ( 31 );
$objPHPExcel->getActiveSheet ()->getColumnDimension ( 'P' )->setWidth ( 31 );我使用 $objPHPExcel->setActiveSheetIndex(0)->getst让标题居中，但是报错
:(
Class 'Home\Controller\PHPExcel_st
QQ截图20151230001328.png
( 64.83 KB 下载：28 次 )
最佳答案
