<?php
require_once '../../../assets/excel/PHPExcel.php';


$objPHPExcel = new PHPExcel();
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(10);
$objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);
//$objPHPExcel->getDefaultStyle()->getNumberFormat()->setFormatCode('@');
$objPHPExcel->getSheet(0)->getColumnDimension('A')->setWidth(5);
$objPHPExcel->getSheet(0)->getColumnDimension('B')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('C')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('D')->setWidth(8);
$objPHPExcel->getSheet(0)->getColumnDimension('E')->setWidth(19);
$objPHPExcel->getSheet(0)->getColumnDimension('F')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('G')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('H')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('I')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('J')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('K')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('L')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('M')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('N')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('O')->setWidth(6);
$objPHPExcel->getSheet(0)->getColumnDimension('P')->setWidth(60);
$objPHPExcel->getSheet(0)->getColumnDimension('Q')->setWidth(60);
$objPHPExcel->getSheet(0)->getColumnDimension('R')->setWidth(20);

$styleBold = array('font'  => array('bold'  => true));
$objPHPExcel->getSheet(0)->getStyle('A1:S1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getSheet(0)->getStyle('A1:S1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getSheet(0)->getStyle('A1:S1')->applyFromArray($styleBold);
$objPHPExcel->getSheet(0)->getRowDimension('1')->setRowHeight(25);
$objPHPExcel->getSheet(0)->setTitle('IMPORT_DPA');
$objPHPExcel->getSheet(0)
->setCellValue('A1', 'thn')
->setCellValue('B1', 'kpa')
->setCellValue('C1', 'pptk')
->setCellValue('D1', 'ppkom')
->setCellValue('E1', 'pejabat_pengadaan')
->setCellValue('F1', 'rek1')
->setCellValue('G1', 'rek2')
->setCellValue('H1', 'rek3')
->setCellValue('I1', 'rek4')
->setCellValue('J1', 'rek5')
->setCellValue('K1', 'rek6')
->setCellValue('L1', 'rek7')
->setCellValue('M1', 'rek8')
->setCellValue('N1', 'rek9')
->setCellValue('O1', 'rek10')
->setCellValue('P1', 'sub_kegiatan')
->setCellValue('Q1', 'belanja')
->setCellValue('R1', 'anggaran');

$objPHPExcel->setActiveSheetIndex(0);

header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="import_dpa.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;

?>