abel/shopee-apps
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
shopee-apps/application/views/cetak/KU_Excel_Sub4_DataAnalisaTrialBalance.php
T
abel db327c0305 copy dari repo om Irfan
2026-06-13 16:02:07 +10:00

715 lines
40 KiB
PHP
Raw Permalink Blame History

<?php
require(APPPATH . 'PHPExcel-1.8/Classes/PHPExcel.php');
require(APPPATH . 'PHPExcel-1.8/Classes/PHPExcel/Writer/Excel2007.php');
use PHPExcel\Style\PHPExcel_Style_Alignment;
use PHPExcel\Style\PHPExcel_Style_Fill;
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("PC Master");
$objPHPExcel->getProperties()->setLastModifiedBy("PC Master");
$objPHPExcel->getProperties()->setTitle("Laporan");
$objPHPExcel->getProperties()->setSubject("");
$objPHPExcel->getProperties()->setDescription("");
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle("Kode Akun");
$objPHPExcel->getDefaultStyle()
->getFont()
->setName("Calibri")
->setSize(11);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'List Akun');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'Sampai (' . $ts . ')');
$sel = array(
'A', 'B', 'C', 'D', 'E'
);
$nt1 = [
'NO' => 'No',
'KODE' => 'KODE_AKUNTB',
'NAMA' => 'NAMA_AKUNTB',
];
$nt2 = [
'REKENING' => 'KODE_AKUNTB',
'KETERANGAN' => 'NAMA_AKUNTB',
];
//Modified Style
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(20);
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->mergeCells("A1:" . $sel[$jumlah_kolom1 - 1] . "1");
$objPHPExcel->getActiveSheet()->mergeCells("A2:" . $sel[$jumlah_kolom1 - 1] . "2");
$objPHPExcel->getActiveSheet()->getStyle("A1:A2")->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A1:A2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setRGB('A52A2A');
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->getColor()->setRGB('008080');
$objPHPExcel->getActiveSheet()->getStyle('A4:' . $sel[$jumlah_kolom1 - 1] . '4')->getFont()->setSize(13);
$objPHPExcel->getActiveSheet()->getStyle('A4:' . $sel[$jumlah_kolom1 - 1] . '4')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A4:' . $sel[$jumlah_kolom1 - 1] . '4')->getFill()->applyFromArray(
array(
'type' => 'FILL_SOLID',
'rotation' => 0,
'startcolor' => array(
'rgb' => 'DEB887'
),
'endcolor' => array(
'argb' => 'FFFFFFFF'
)
)
);
//Basic Style
$objPHPExcel->getActiveSheet()->getStyle('A:B')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
//Isi Name Tabel
$no = 0;
foreach ($nama_tabel1 as $tbl) {
$objPHPExcel->getActiveSheet()->setCellValue($sel[$no] . '4', $tbl);
$no++;
}
//Isi Laporan
$no = 0;
$nolpr = 1;
$nocell = 5;
foreach ($akuntb as $lprn) {
foreach ($nama_tabel1 as $tbl) {
if ($tbl == "NO") {
$objPHPExcel->getActiveSheet()->setCellValue($sel[$no] . '' . $nocell . '', $nolpr);
} else {
$objPHPExcel->getActiveSheet()->setCellValue($sel[$no] . '' . $nocell . '', $lprn[$nt1[$tbl]]);
}
$no++;
}
$no = 0;
$nocell++;
$nolpr++;
}
$limit = $nocell-1;
$objPHPExcel->getActiveSheet()->freezePane('A5');
$objPHPExcel->getActiveSheet()->getStyle('A4:C'.$limit)->applyFromArray(
array(
'borders' => array(
'allborders' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('rgb' => 'FF000000')
)
)
)
);
//Trial Balance
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setTitle("Trial Balance");
$objPHPExcel->getDefaultStyle()
->getFont()
->setName("Calibri")
->setSize(11);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'PT TRIPERWIRA MULTI PAMENANG');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'TRIAL BALANCE');
$objPHPExcel->getActiveSheet()->setCellValue('A3', '[' . $nama_pak . ']');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(20);
$objPHPExcel->getActiveSheet()->getStyle('A2:A3')->getFont()->setSize(16);
$objPHPExcel->getActiveSheet()->mergeCells("A1:" . $sel[$jumlah_kolom2 - 1] . "1");
$objPHPExcel->getActiveSheet()->mergeCells("A2:" . $sel[$jumlah_kolom2 - 1] . "2");
$objPHPExcel->getActiveSheet()->mergeCells("A3:" . $sel[$jumlah_kolom2 - 1] . "3");
$objPHPExcel->getActiveSheet()->getStyle("A1:A3")->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('A1:A3')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setRGB('A52A2A');
$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->getColor()->setRGB('008080');
$objPHPExcel->getActiveSheet()->getStyle('A3')->getFont()->getColor()->setRGB('8A2BE2');
$objPHPExcel->getActiveSheet()->getStyle('A5:AX6')->getFont()->setSize(13);
$objPHPExcel->getActiveSheet()->getStyle('A5:AX6')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A5:AX6')->getFill()->applyFromArray(
array(
'type' => 'FILL_SOLID',
'rotation' => 0,
'startcolor' => array(
'rgb' => 'DEB887'
),
'endcolor' => array(
'argb' => 'FFFFFFFF'
)
)
);
//Basic Style
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_LEFT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('C:AX')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT)->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AH')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AI')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AJ')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AK')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AL')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AM')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AN')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AO')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AP')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AQ')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AR')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AS')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AT')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AU')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AV')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AW')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('AX')->setWidth(20);
$objPHPExcel->getActiveSheet()->setCellValue('A5', "REKENING");
$objPHPExcel->getActiveSheet()->setCellValue('B5', "KETERANGAN");
$objPHPExcel->getActiveSheet()->setCellValue('C5', "SALDO AWAL");
$objPHPExcel->getActiveSheet()->setCellValue('C6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('D6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('E5', "KAS PCM");
$objPHPExcel->getActiveSheet()->setCellValue('E6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('F6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('G5', "KAS ITP");
$objPHPExcel->getActiveSheet()->setCellValue('G6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('H6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('I5', "BCADMT1077111999");
$objPHPExcel->getActiveSheet()->setCellValue('I6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('J6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('K5', "BCAHW1070408950");
$objPHPExcel->getActiveSheet()->setCellValue('K6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('L6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('M5', "BCATMP1070492233");
$objPHPExcel->getActiveSheet()->setCellValue('M6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('N6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('O5', "BCAYAP1072111111");
$objPHPExcel->getActiveSheet()->setCellValue('O6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('P6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('Q5', "JATIM0011234194");
$objPHPExcel->getActiveSheet()->setCellValue('Q6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('R6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('S5', "MANDIRI1400078978880");
$objPHPExcel->getActiveSheet()->setCellValue('S6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('T6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('U5', "MANDIRI1420080789000");
$objPHPExcel->getActiveSheet()->setCellValue('U6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('V6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('W5', "MANDTMP1420023789000");
$objPHPExcel->getActiveSheet()->setCellValue('W6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('X6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('Y5', "JATIMDMT1281015571");
$objPHPExcel->getActiveSheet()->setCellValue('Y6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('Z6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AA5', "BCAYSS1075022222");
$objPHPExcel->getActiveSheet()->setCellValue('AA6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AB6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AC5', "BCAYAS1070711199");
$objPHPExcel->getActiveSheet()->setCellValue('AC6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AD6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AE5', "BCAYSS1074666666");
$objPHPExcel->getActiveSheet()->setCellValue('AE6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AF6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AG5', "BNIYSS0251333704");
$objPHPExcel->getActiveSheet()->setCellValue('AG6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AH6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AI5', "MANDYSS1420008078908");
$objPHPExcel->getActiveSheet()->setCellValue('AI6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AJ6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AK5', "BCASFTR1070700111");
$objPHPExcel->getActiveSheet()->setCellValue('AK6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AL6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AM5', "BCALOUIS1070747576");
$objPHPExcel->getActiveSheet()->setCellValue('AM6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AN6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AO5', "BCAJASON1075302888");
$objPHPExcel->getActiveSheet()->setCellValue('AO6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AP6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AQ5', "JURNAL MEMO");
$objPHPExcel->getActiveSheet()->setCellValue('AQ6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AR6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AS5', "JURNAL SISTEM");
$objPHPExcel->getActiveSheet()->setCellValue('AS6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AT6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AU5', "MUTASI");
$objPHPExcel->getActiveSheet()->setCellValue('AU6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AV6', "KREDIT");
$objPHPExcel->getActiveSheet()->setCellValue('AW5', "TRIAL BALANCE");
$objPHPExcel->getActiveSheet()->setCellValue('AW6', "DEBET");
$objPHPExcel->getActiveSheet()->setCellValue('AX6', "KREDIT");
$objPHPExcel->getActiveSheet()->getStyle('A5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('B5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('C5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('C6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('D6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('E5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('E6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('F6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('G5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('G6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('H6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('I5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('I6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('J6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('K5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('K6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('L6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('M5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('M6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('N6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('O5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('O6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('P6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('Q5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('Q6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('R6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('S5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('S6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('T6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('U5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('U6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('V6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('W5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('W6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('X6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('Y5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('Y6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('Z6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AA5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AA6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AB6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AC5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AC6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AD6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AE5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AE6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AF6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AG5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AG6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AH6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AI5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AI6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AJ6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AK5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AK6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AL6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AM5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AM6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AN6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AO5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AO6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AP6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AQ5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AQ6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AR6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AS5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AS6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AT6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AU5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AU6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AV6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AW5')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AW6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
$objPHPExcel->getActiveSheet()->getStyle('AX6')->getAlignment()->setHorizontal('HORIZONTAL_CENTER')->setVertical('VERTICAL_CENTER');
//Isi Laporan
$no = 0;
$nolpr = 1;
$nocell = 7;
foreach ($akuntb as $lprn) {
$niau = 0;
$niav = 0;
if ($lprn['kolomC']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('C' . $nocell . '', $lprn['kolomC'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomC'][$no]['NILAI_HHTB'];
}
if ($lprn['kolomD']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('D' . $nocell . '', $lprn['kolomD'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomD'][$no]['NILAI_HHTB'];
}
if ($lprn['kolomE']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('E' . $nocell . '', $lprn['kolomE'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomE'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('E' . $nocell . '', '-');
}
if ($lprn['kolomF']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('F' . $nocell . '', $lprn['kolomF'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomF'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('F' . $nocell . '', '-');
}
if ($lprn['kolomG']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('G' . $nocell . '', $lprn['kolomG'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomG'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('G' . $nocell . '', '-');
}
if ($lprn['kolomH']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('H' . $nocell . '', $lprn['kolomH'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomH'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('H' . $nocell . '', '-');
}
if ($lprn['kolomI']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('I' . $nocell . '', $lprn['kolomI'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomI'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('I' . $nocell . '', '-');
}
if ($lprn['kolomJ']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('J' . $nocell . '', $lprn['kolomJ'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomJ'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('J' . $nocell . '', '-');
}
if ($lprn['kolomK']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('K' . $nocell . '', $lprn['kolomK'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomK'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('K' . $nocell . '', '-');
}
if ($lprn['kolomL']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('L' . $nocell . '', $lprn['kolomL'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomL'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('L' . $nocell . '', '-');
}
if ($lprn['kolomM']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('M' . $nocell . '', $lprn['kolomM'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomM'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('M' . $nocell . '', '-');
}
if ($lprn['kolomN']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('N' . $nocell . '', $lprn['kolomN'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomN'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('N' . $nocell . '', '-');
}
if ($lprn['kolomO']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('O' . $nocell . '', $lprn['kolomO'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomO'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('O' . $nocell . '', '-');
}
if ($lprn['kolomP']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('P' . $nocell . '', $lprn['kolomP'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomP'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('P' . $nocell . '', '-');
}
if ($lprn['kolomQ']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('Q' . $nocell . '', $lprn['kolomQ'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomQ'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $nocell . '', '-');
}
if ($lprn['kolomR']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('R' . $nocell . '', $lprn['kolomR'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomR'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('R' . $nocell . '', '-');
}
if ($lprn['kolomS']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('S' . $nocell . '', $lprn['kolomS'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomS'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('S' . $nocell . '', '-');
}
if ($lprn['kolomT']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('T' . $nocell . '', $lprn['kolomT'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomT'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('T' . $nocell . '', '-');
}
if ($lprn['kolomU']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('U' . $nocell . '', $lprn['kolomU'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomU'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('U' . $nocell . '', '-');
}
if ($lprn['kolomV']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('V' . $nocell . '', $lprn['kolomV'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomV'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('V' . $nocell . '', '-');
}
if ($lprn['kolomW']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('W' . $nocell . '', $lprn['kolomW'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomW'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('W' . $nocell . '', '-');
}
if ($lprn['kolomX']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('X' . $nocell . '', $lprn['kolomX'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomX'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('X' . $nocell . '', '-');
}
if ($lprn['kolomY']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('Y' . $nocell . '', $lprn['kolomY'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomY'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('Y' . $nocell . '', '-');
}
if ($lprn['kolomZ']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('Z' . $nocell . '', $lprn['kolomZ'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomZ'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('Z' . $nocell . '', '-');
}
if ($lprn['kolomAA']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AA' . $nocell . '', $lprn['kolomAA'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAA'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AA' . $nocell . '', '-');
}
if ($lprn['kolomAB']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AB' . $nocell . '', $lprn['kolomAB'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAB'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AB' . $nocell . '', '-');
}
if ($lprn['kolomAC']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AC' . $nocell . '', $lprn['kolomAC'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAC'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AC' . $nocell . '', '-');
}
if ($lprn['kolomAD']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AD' . $nocell . '', $lprn['kolomAD'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAD'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AD' . $nocell . '', '-');
}
if ($lprn['kolomAE']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AE' . $nocell . '', $lprn['kolomAE'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAE'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AE' . $nocell . '', '-');
}
if ($lprn['kolomAF']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AF' . $nocell . '', $lprn['kolomAF'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAF'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AF' . $nocell . '', '-');
}
if ($lprn['kolomAG']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AG' . $nocell . '', $lprn['kolomAG'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAG'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AG' . $nocell . '', '-');
}
if ($lprn['kolomAH']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AH' . $nocell . '', $lprn['kolomAH'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAH'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AH' . $nocell . '', '-');
}
if ($lprn['kolomAI']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AI' . $nocell . '', $lprn['kolomAI'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAI'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AI' . $nocell . '', '-');
}
if ($lprn['kolomAJ']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AJ' . $nocell . '', $lprn['kolomAJ'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAJ'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AJ' . $nocell . '', '-');
}
if ($lprn['kolomAK']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AK' . $nocell . '', $lprn['kolomAK'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAK'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AK' . $nocell . '', '-');
}
if ($lprn['kolomAL']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AL' . $nocell . '', $lprn['kolomAL'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAL'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AL' . $nocell . '', '-');
}
if ($lprn['kolomAM']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AM' . $nocell . '', $lprn['kolomAM'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAM'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AM' . $nocell . '', '-');
}
if ($lprn['kolomAN']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AN' . $nocell . '', $lprn['kolomAN'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAN'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AN' . $nocell . '', '-');
}
if ($lprn['kolomAO']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AO' . $nocell . '', $lprn['kolomAO'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAO'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AO' . $nocell . '', '-');
}
if ($lprn['kolomAP']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AP' . $nocell . '', $lprn['kolomAP'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAP'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AP' . $nocell . '', '-');
}
if ($lprn['kolomAQ']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AQ' . $nocell . '', $lprn['kolomAQ'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAQ'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AQ' . $nocell . '', '-');
}
if ($lprn['kolomAR']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AR' . $nocell . '', $lprn['kolomAR'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAR'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AR' . $nocell . '', '-');
}
if ($lprn['kolomAS']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AS' . $nocell . '', $lprn['kolomAS'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niau = $niau+$lprn['kolomAS'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AS' . $nocell . '', '-');
}
if ($lprn['kolomAT']!=NULL) {
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AT' . $nocell . '', $lprn['kolomAT'][$no]['NILAI'], PHPExcel_Cell_DataType::TYPE_STRING);
$niav = $niav+$lprn['kolomAT'][$no]['NILAI_HHTB'];
} else {
$objPHPExcel->getActiveSheet()->setCellValue('AT' . $nocell . '', '-');
}
if ($niau==0) {
$nilaiAu = "-";
} else {
$nilaiAu = number_format($niau, 2);
}
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AU' . $nocell . '', $nilaiAu, PHPExcel_Cell_DataType::TYPE_STRING);
if ($niav==0) {
$nilaiAv = "-";
} else {
$nilaiAv = number_format($niav, 2);
}
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AV' . $nocell . '', $nilaiAv, PHPExcel_Cell_DataType::TYPE_STRING);
if ($niau>$niav) {
$subtotal = $niau-$niav;
$nilaiAw = number_format($subtotal, 2);
$nilaiAx = "-";
} else if ($niau<$niav) {
$subtotal = $niav-$niau;
$nilaiAw = "-";
$nilaiAx = number_format($subtotal, 2);
} else {
$nilaiAw = "-";
$nilaiAx = "-";
}
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AW' . $nocell . '', $nilaiAw, PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->getActiveSheet()->setCellValueExplicit('AX' . $nocell . '', $nilaiAx, PHPExcel_Cell_DataType::TYPE_STRING);
foreach ($nama_tabel2 as $tbl) {
if ($tbl == "NO") {
$objPHPExcel->getActiveSheet()->setCellValue($sel[$no] . '' . $nocell . '', $nolpr);
} else {
$objPHPExcel->getActiveSheet()->setCellValue($sel[$no] . '' . $nocell . '', $lprn[$nt2[$tbl]]);
}
$no++;
}
$no = 0;
$nocell++;
$nolpr++;
}
$limit = $nocell-1;
$objPHPExcel->getActiveSheet()->freezePane('C7');
$objPHPExcel->getActiveSheet()->getStyle('A5:AX'.$limit)->applyFromArray(
array(
'borders' => array(
'allborders' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('rgb' => 'FF000000')
)
)
)
);
$objPHPExcel->getActiveSheet()->mergeCells("A5:A6");
$objPHPExcel->getActiveSheet()->mergeCells("B5:B6");
$objPHPExcel->getActiveSheet()->mergeCells("C5:D5");
$objPHPExcel->getActiveSheet()->mergeCells("E5:F5");
$objPHPExcel->getActiveSheet()->mergeCells("G5:H5");
$objPHPExcel->getActiveSheet()->mergeCells("I5:J5");
$objPHPExcel->getActiveSheet()->mergeCells("K5:L5");
$objPHPExcel->getActiveSheet()->mergeCells("M5:N5");
$objPHPExcel->getActiveSheet()->mergeCells("O5:P5");
$objPHPExcel->getActiveSheet()->mergeCells("Q5:R5");
$objPHPExcel->getActiveSheet()->mergeCells("S5:T5");
$objPHPExcel->getActiveSheet()->mergeCells("U5:V5");
$objPHPExcel->getActiveSheet()->mergeCells("W5:X5");
$objPHPExcel->getActiveSheet()->mergeCells("Y5:Z5");
$objPHPExcel->getActiveSheet()->mergeCells("AA5:AB5");
$objPHPExcel->getActiveSheet()->mergeCells("AC5:AD5");
$objPHPExcel->getActiveSheet()->mergeCells("AE5:AF5");
$objPHPExcel->getActiveSheet()->mergeCells("AG5:AH5");
$objPHPExcel->getActiveSheet()->mergeCells("AI5:AJ5");
$objPHPExcel->getActiveSheet()->mergeCells("AK5:AL5");
$objPHPExcel->getActiveSheet()->mergeCells("AM5:AN5");
$objPHPExcel->getActiveSheet()->mergeCells("AO5:AP5");
$objPHPExcel->getActiveSheet()->mergeCells("AQ5:AR5");
$objPHPExcel->getActiveSheet()->mergeCells("AS5:AT5");
$objPHPExcel->getActiveSheet()->mergeCells("AU5:AV5");
$objPHPExcel->getActiveSheet()->mergeCells("AW5:AX5");
$filename = "Laporan Trial Balance ".$nama_pak." Dibuat " . $ts .'.xlsx';
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $filename . '"');
header('Cache-Control: max-age=0');
$writer = PHPExcel_IOFactory::createwriter($objPHPExcel, 'Excel2007');
$writer->save('php://output');
exit();
Reference in New Issue View Git Blame Copy Permalink