phpexcel set border

phpexcel_style_and_data

// set border

$sheet->getStyle("A1:I{$offset}")->applyFromArray(array(
            'borders' => array(
                'allborders' => array(
                    'style' => PHPExcel_Style_Border::BORDER_THIN
                )
            )
        ));


// set array value
$rows = 2;
foreach ($ret as $row) {
    
    $cols = 0;
    foreach ($row as $cell) {
	$sheet->getCellByColumnAndRow($cols, $rows)
	      ->setValueExplicit($cell, PHPExcel_Cell_DataType::TYPE_STRING);
	$cols ++;
    }
    $rows ++;
}