php excel 样式设置,PHPExcel格式设置

/** Excel2007文件读取和生成 **/

require_once 'PHPExcel/PHPExcel.php';

$title = '测试';

$file_name = $title.'.xlsx';

$file_name = iconv('utf-8', 'gb2312', $file_name);

$type = 'Excel2007';

/**********生成Excel**********/

// 新建一个Excel

$objPHPExcel = new PHPExcel();

// 获取活动工作表

$objSheet = $objPHPExcel->getActiveSheet();

/**********格式**********/

// 设置表格标题

$objSheet->setTitle($title);

// 合并单元格

$objSheet->mergeCells('A1:C1');

// 水平居中

$objSheet->getStyle('A1')->getAlignment()

->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

// 边框

$objSheet->getStyle('A1:C4')->getBorders()->getAllBorders()

->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

// 垂直居中

$objSheet->getStyle('A2')->getAlignment()

->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);

// 第一行的默认高度

$objSheet->getRowDimension(2)->setRowHeight(30);

// 行的默认宽度

$objSheet->getColumnDimension('A')->setWidth(25);

/**********内容**********/

$objSheet->setCellValue("A1","标题");

$objSheet->setCellValue("A2","姓名")->setCellValue("B2","分数")->setCellValue("C2","班级");

// 生成Excel

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $type);

// 直接保存到服务器

$objWriter->save($file_name);

// 输出的文件名

header('Content-Disposition: attachment; filename='.$file_name);

// 禁止文件缓存

header('Cache-Control: no-cache, no-store, max-age=0, must-revalidate');

// 文件格式Excel2007

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

// 输出到浏览器下载

$objWriter->save("php://output");