PHPExcelのいくつかの一般的な方法

<?php
 require_once 'PHPExcel.class.php'; 
$str = "title";
    $filename = mb_convert_encoding("    /  ","gb2312","utf-8");    
    //    
    $objExcel = new PHPExcel();
    $objWriter = new PHPExcel_Writer_Excel5($objExcel);
    $objExcel->setActiveSheetIndex(0);  //  sheet
    $objActSheet = $objExcel->getActiveSheet();
    $objActSheet->setTitle($str);   //Sheet  

    $objActSheet->mergeCells('A1:AL2'); //      
    $objStyleA1 = $objActSheet->getStyle('A1');
    $objAlignA1 = $objStyleA1->getAlignment();
//    $objAlignA1->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);    //    
    $objAlignA1->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);  //    
    //     
    $objFontA1 = $objStyleA1->getFont();
    $objFontA1->setName('  ');
    $objFontA1->setSize(12);
    $objFontA1->getColor()->setARGB('FFFF0000');
    //    
    $objActSheet->getColumnDimension('A')->setWidth(25);
    $objActSheet->getColumnDimension('B')->setWidth(25);
    $objActSheet->getColumnDimension('C')->setWidth(25);

    //     
    $objExcel->getActiveSheet()->getStyle(3)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
    $objExcel->getActiveSheet()->getStyle(3)->getFill()->getStartColor()->setARGB($title_back);
    //  A1  
    $objActSheet->setCellValue('A1', $str);
   //  A5  
        $objStyleS = $objExcel->getActiveSheet()->getStyle('A5');
        $objBorderA5 = $objStyleS->getBorders();
        $objBorderA5->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//        
        $objBorderA5 ->getTop()->getColor()->setARGB('FFFF0000' ); 
        $objBorderA5->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
        $objBorderA5->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
        $objBorderA5->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

ob_end_clean();
    //    
    $outputFileName = $filename.".xls";
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");
    header('Content-Disposition:inline;filename="' . $outputFileName . '"');
    header("Content-Transfer-Encoding: binary");
    header("Expires: Mon, 27 Sep 2011 00:00:00 GMT");
    header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Pragma: no-cache");
    $objWriter->save('php://output');