$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setWidth('10');
$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setWrapText(true);
$activeSheet->getStyle('A')->getFill()->setFillType('solid')->getStartColor()->setARGB('00FF0000');
$activeSheet->getStyle('A')->getAlignment()->setHorizontal('right');
$activeSheet->getStyle("E")
->getAlignment()
->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
setVERTICAL(PHPExcel_Style_Alignment::PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->mergeCells('A1:B1');
$styleArray = array(
'borders' => array(
'allborders' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN
)
)
);
$sheet->getStyle('A1:P3')->applyFromArray($styleArray);
unset($styleArray);
0 comments:
Post a Comment