phpexcel

<?php


// membuat obyek dari class PHPExcel
$objPHPExcel = new PHPExcel();
// memberi nama sheet pertama dengan nama 'TRANSAKSI'
$objPHPExcel->getSheet(0)->setTitle('TRANSAKSI');
// Menambahkan kolom untuk data TRANSAKSI di sheet pertama
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'LAPORAN TRANSAKSI');
$objPHPExcel->getActiveSheet()->mergeCells('A1:I1');
//set aligment to center for that merged cell (A1 to D1)
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$objPHPExcel->getSheet(0)
            ->setCellValue('A3', 'NAMA MITRA')
            ->setCellValue('B3', 'BILLREFF')
            ->setCellValue('C3', 'DATE')
            ->setCellValue('D3', 'JENIS TRANSAKSI')
            ->setCellValue('E3', 'KODE TRANSAKSI')
            ->setCellValue('F3', 'CUSTID')
            ->setCellValue('G3', 'AMOUNT')
            ->setCellValue('H3', 'PREV BALANCE')
            ->setCellValue('I3', 'BALANCE');
$baris = 4;
foreach ($query as $r):
    $objPHPExcel->getSheet(0)
                    ->setCellValue('A'.$baris, $r->nameMitra)
                    ->setCellValue('B'.$baris, ' '.$r->BILLREFF.' ')
                    ->setCellValue('C'.$baris, ' '.$r->date_trx.' ')
                    ->setCellValue('D'.$baris, $r->jenis)
                    ->setCellValue('E'.$baris, ' '.$r->TRXID.' ')
                    ->setCellValue('F'.$baris, ' '.$r->CUSTID.' ')
                    ->setCellValue('G'.$baris, $r->trx_amount)
                    ->setCellValue('H'.$baris, $r->prev_balance)
                    ->setCellValue('I'.$baris, $r->balance);
        // nomor baris bertambah
    $baris++;
endforeach;
// mengeset sheet pertama yang aktif
$objPHPExcel->setActiveSheetIndex(0);

// output file dengan nama file 'contoh.xls'
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="contoh.xlsx"');
header('Cache-Control: max-age=0');

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