PHPExcel一些常用方法01

1. <?php  
2.  require_once 'PHPExcel.class.php';   
3. $str = "title";  
4.     $filename = mb_convert_encoding("表格主题/题目","gb2312","utf-8");      
5.     //实例化类  
6.     $objExcel = new PHPExcel();  
7.     $objWriter = new PHPExcel_Writer_Excel5($objExcel);  
8.     $objExcel->setActiveSheetIndex(0);  //当前sheet  
9.     $objActSheet = $objExcel->getActiveSheet();  
10.     $objActSheet->setTitle($str);   //Sheet标题  
11.   
12.     $objActSheet->mergeCells('A1:AL2'); //合并单元格   
13.     $objStyleA1 = $objActSheet->getStyle('A1');  
14.     $objAlignA1 = $objStyleA1->getAlignment();  
15. //    $objAlignA1->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);    //左右居中  
16.     $objAlignA1->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);  //上下居中  
17.     //字体及颜色  
18.     $objFontA1 = $objStyleA1->getFont();  
19.     $objFontA1->setName('黑体');  
20.     $objFontA1->setSize(12);  
21.     $objFontA1->getColor()->setARGB('FFFF0000');  
22.     //设置宽度  
23.     $objActSheet->getColumnDimension('A')->setWidth(25);  
24.     $objActSheet->getColumnDimension('B')->setWidth(25);  
25.     $objActSheet->getColumnDimension('C')->setWidth(25);  
26.   
27.     //設定背景色  
28.     $objExcel->getActiveSheet()->getStyle(3)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);  
29.     $objExcel->getActiveSheet()->getStyle(3)->getFill()->getStartColor()->setARGB($title_back);  
30.     //设定A1的值  
31.     $objActSheet->setCellValue('A1', $str);  
32.    //设置A5边框  
33.         $objStyleS = $objExcel->getActiveSheet()->getStyle('A5');  
34.         $objBorderA5 = $objStyleS->getBorders();  
35.         $objBorderA5->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);  
36. //设置上边框的颜色  
37.         $objBorderA5 ->getTop()->getColor()->setARGB('FFFF0000' );   
38.         $objBorderA5->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);  
39.         $objBorderA5->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);  
40.         $objBorderA5->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);