PHPでEXCEL作成

php EXCEL

phpでEXCELを作成する「PHPExcel」を試した。

基本的な使い方は簡単なので省略。

罫線をまとめて作成する方法

/** PHPExcel */
require_once './PHPExcel.php';
require_once './PHPExcel/Writer/Excel5.php';

$oExcel = new PHPExcel();

$oExcel->setActiveSheetIndex(0);

$cell_style = array(
    'borders' => array(
    'top'     => array('style' => PHPExcel_Style_Border::BORDER_THIN),
    'bottom'     => array('style' => PHPExcel_Style_Border::BORDER_THIN),
    'left'     => array('style' => PHPExcel_Style_Border::BORDER_THIN),
    'right'     => array('style' => PHPExcel_Style_Border::BORDER_THIN),
    'vertical'     => array('style' => PHPExcel_Style_Border::BORDER_THIN),
    'horizontal'     => array('style' => PHPExcel_Style_Border::BORDER_THIN),
    )
);

//第二引数は範囲指定
$oExcel->getActiveSheet()->duplicateStyleArray($cell_style,'a1:f1');

$writer = new PHPExcel_Writer_Excel5($objPHPExcel);
$writer->save("sample.xls");