68 lines
2.8 KiB
PHP
68 lines
2.8 KiB
PHP
<?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;
|
|
|
|
?>
|
|
|
|
|