<?php
require_once ABSPATH . "includes/excel-2.0/Writer.php";
require_once ABSPATH . "includes/xls.php";
$workbook = new xls();
$workbook->send('sample_report.xls');
$worksheet =& $workbook->addWorksheet("sample_report");
$format_title =& $workbook->addFormat(array('Align' => 'center', 'Bold' => '1', 'Size' => '10'));
$format_title_field =& $workbook->addFormat(array('Align' => 'center', 'Bold' => '1', 'Border' => '0', 'Size' => '8'));
$format_text =& $workbook->addFormat(array('Border' => '0', 'Size' => '8'));
$worksheet->setLandscape();
$worksheet->setPaper(1);
$workbook->writeMerge($worksheet, 1, 0, 5, 1, 'Sample Report', $format_title);
$col = 0;
$row = 2;
$cols = array(array('name' => 'Jenis', 'width' => 20), array('name' => 'Tanggal', 'width' => 20), array('name' => 'Perihal', 'width' => 70), array('name' => 'Kode', 'width' => 40), array('name' => 'Tahun', 'width' => 20));
foreach ($cols as $field) {
$worksheet->writeString($row, $col, $field['name'], $format_title_field);
//$worksheet->setColumn($row, $col,$field['width']+0);
//$format_title_field->setTextWrap();
$col++;
}
$row++;
$data = array();
while ($rowx = $rs->FetchNextObject()) {
$data[] = array($rowx->JENIS, formatDate2($rowx->TANGGAL), $rowx->PERIHAL, $rowx->KODE, $rowx->TAHUN);
}
foreach ($data as $r) {
$col = 0;
foreach ($r as $c) {
$worksheet->writeString($row, $col, $c, $format_text);
