PHPExcel使用实例

//加载类库
require_once 'PHPExcel.php';

//创建实例
$objExcel = new PHPExcel();

//设置文档基本属性
$objProps = $objExcel -> getProperties();
$objProps -> setCreator("章贡区医疗保险局");
$objProps -> setLastModifiedBy("章贡区医疗保险局");
$objProps -> setTitle("章贡区医疗保险局职工月增减变动报表");
$objProps -> setSubject("章贡区医疗保险局职工月增减变动报表");
$objProps -> setDescription("章贡区医疗保险局职工月增减变动报表");
$objProps -> setKeywords("章贡区医疗保险局职工月增减变动报表");
$objProps -> setCategory("变动报表");

//设置栏目宽度
$objActSheet -> getColumnDimension('A') -> setWidth(20);
$objActSheet -> getColumnDimension('B') -> setWidth(20);
$objActSheet -> getColumnDimension('C') -> setWidth(20);

//操作Sheet
$objActSheet = $objExcel -> getActiveSheet();
//当前活动的Sheet
$objExcel -> setActiveSheetIndex(0);
//设置sheet名字
$objActSheet -> setTitle('Active Sheet Demo');

//由PHPExcel根据传入内容自动判断单元格内容类型
$objActSheet -> setCellValue('A1', "name");
$objActSheet -> setCellValue('B1', 2);
$objActSheet -> setCellValue('C1', 3);

//设置单元格格式
$objActSheet() -> getCell('A2') -> setValueExplicit('861391327543258', PHPExcel_Cell_DataType::TYPE_NUMERIC);
$objActSheet() -> getCell('B2') -> setValueExplicit('010123213213321', PHPExcel_Cell_DataType::TYPE_STRING);
$objActSheet() -> getCell('C2') -> setValueExplicit('单元格', PHPExcel_Cell_DataType::TYPE_STRING);

//设置行高
$objActSheet -> getRowDimension('1')->setRowHeight(20);
$objStyle = $objActSheet -> getStyle('A1:C1');
//文字样式
$objStyle -> getFont() -> setName('宋体');
$objStyle -> getFont() -> setSize(18);
$objStyle -> getFont() -> setBold(true);

//垂直对齐
$objStyle -> getAlignment() -> setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//水平对齐
$objStyle -> getAlignment() -> setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
//背景色
$objStyle -> getFill() -> setFillType(PHPExcel_Style_Fill::FILL_SOLID) -> getStartColor() -> setRGB('9ab9fa');
//换行
$objActSheet -> getStyle('A1:A2') -> getAlignment() -> setWrapText(true);
//合并
$objActSheet -> mergeCells('A18:E22');
//隐藏列
$objActSheet() -> getColumnDimension('D') -> setVisible(false);

//创建新工作表
$objNewSheet = $objExcel -> createSheet();
$objNewSheet -> setTitle('sheetb');

//保存xls
$objWriter = PHPExcel_IOFactory::createWriter($objExcel, 'Excel5');
header('Content-Type: application/vnd.ms-excel;charset=utf8;');
header('Content-Disposition: attachment; filename='.mb_convert_encoding('NewExcel',"gb2312","utf-8").".xls");
header('Cache-Control: max-age=0');
$objWriter -> save('php://output');