Sets the width automatically, but does not work for Chinese ... (Chinese auto-length is still under study)
$objPHPExcel->getactivesheet ()->getcolumndimension (' A ')->setautosize (true);
$objPHPExcel->getactivesheet ()->getcolumndimension (' B ')->setautosize (true);
$objPHPExcel->getactivesheet ()->getcolumndimension (' C ')->setautosize (true);
$objPHPExcel->getactivesheet ()->getcolumndimension (' D ')->setautosize (true);
$objPHPExcel->getactivesheet ()->getcolumndimension (' E ')->setautosize (true);
$objPHPExcel->getactivesheet ()->getcolumndimension (' F ')->setautosize (true);
$objPHPExcel->getactivesheet ()->getcolumndimension (' G ')->setautosize (true);
Set left and right center
$objPHPExcel->getactivesheet ()->getstyle (' A1:k55 ')
->getalignment ()->sethorizontal (Phpexcel_style_alignment::horizontal_center);
Set Border lines
$objPHPExcel->getactivesheet ()->getstyle (
' A2:k100 '
)->getborders ()->getallborders ()->setborderstyle (Phpexcel_style_border::border_thin);
or a phpexcel problem.