-
$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);设置A4纸张大小
-
$objPHPExcel->getActiveSheet()->getStyle('A'.$NOW_row)->getFont()->setSize(15);//字体大小 $objPHPExcel->getActiveSheet()->mergeCells('A'.$NOW_row.':L'.$NOW_row);//合并标题
-
$objPHPExcel->getActiveSheet()->getRowDimension($NOW_row)->setRowHeight(20); //设置行高
- $objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);//自动高度
- $objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(-1);//默认行高自动高度
-
$objPHPExcel->getActiveSheet()->getStyle('A'.$NOW_row.':L'.$NOW_row)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//水平居中 $objPHPExcel->getActiveSheet()->getStyle('A'.$NOW_row.':L'.$NOW_row)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);//垂直居中
-
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(6);//列宽
-
//设置背景颜色 $objPHPExcel->getActiveSheet()->getStyle('A3')->applyFromArray( array( 'fill' => array( 'type' => \PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'eeeeee') ) ) );
-
$objPHPExcel->getActiveSheet()->getStyle('A3')->applyFromArray( array( 'borders' => array( 'allborders' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('argb' => 'FF000000'), ), ), ));//设置边框
-
$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//设置默认水平居中
- $objPHPExcel->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);//设置默认垂直居中 $obSheet->getDefaultStyle()->getFont()->setSize(11);//设置默认字体大小
-
//设置页面边距为0.5厘米 (1英寸 = 2.54厘米) $margin = 1.78 / 2.54;//phpexcel 中是按英寸来计算的,所以这里换算了一下 $marginright = 1 / 2.54;//phpexcel 中是按英寸来计算的,所以这里换算了一下 //$pageMargins->setTop($margin);//上边距 //$pageMargins->setBottom($margin);//下 $objPHPExcel->getActiveSheet()->getPageMargins()->setLeft($margin);//左 $objPHPExcel->getActiveSheet()->getPageMargins()->setRight(marginright);//右 //$objPHPExcel->getActiveSheet()->getPageSetup()->setFitToWidth('1');//自动填充到页面的宽度 //$objPHPExcel->getActiveSheet()->getPageSetup()->setFitToHeight('1');//自动填充到页面的高度
- //设置标题索引 (点击 标题 跳转到对应的工作簿中) $objPHPExcel->getActiveSheet()->getCell('B4')->getHyperlink()->setUrl("sheet://'"计算机软件技术"'!A1");
-
//冻结标题 //第一种方式 $objPHPExcel->getActiveSheet()->freezePane('A1'); $objPHPExcel->getActiveSheet()->freezePane('A2'); //第二种方式 $objPHPExcel->getActiveSheet()->freezePaneByColumnAndRow(8,4);//(列,行)冻结的行数比你设置的要多一行(例 我需要设置的是3行 那么参数就要写4)
-
//设置打印 页面 方向与大小(此为横向) $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(\PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE); $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(\PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
- /*设置G金额字段格式为2位小数点*/
$objPHPExcel->getActiveSheet()->getStyle ('G')->getNumberFormat()->setFormatCode ("0.00"); -
字体颜色设置 $objPHPExcel->getActiveSheet()->getStyle('D' . $tmp)->getFont()->getColor()->setRGB('FF0000');
-
$objPHPExcel->getActiveSheet()->freezePane('D4');//冻结1-3行A-C列 表头
php excel
于 2023-05-06 01:03:46 首次发布