$content->set_align('top');
$content->set_size(8);
$content->set_color('black');
$content->set_border(1);
$worksheet =& $workbook->add_worksheet();
$worksheet->set_landscape();
$worksheet->set_paper(5);
$worksheet->hide_gridlines();
$worksheet->set_margin_left(2.5);
$worksheet->set_margin_top(0.5);
$worksheet->set_margin_right(0);
$worksheet->set_margin_bottom(0);
$view = new rekap_siswa;
$view->get_kelas_detil($idKelas);
$namaKelas = $view->get_array();
$worksheet->merge_cells(1, 0, 2, 8);
$worksheet->write_string(1, 0, 'SMK N 2 TEMANGGUNG', $h3);
$worksheet->merge_cells(3, 0, 3, 8);
$worksheet->write_string(3, 0, 'Rekapitulasi Dana Iuran Siswa', $h3);
$worksheet->set_column(0, 0, 3);
$worksheet->set_column(1, 1, 10);
$worksheet->set_column(2, 2, 20);
$worksheet->set_column(3, 3, 15);
$worksheet->set_column(4, 4, 15);
$worksheet->set_column(5, 5, 15);
$worksheet->set_column(6, 6, 15);
<?
require_once("business/rekap_siswa.class.php");
$tmpl->setBasedir("module/rekap_siswa/templates");
$tmpl->readTemplatesFromFile("detil_kelas_view.html");
//print_r($_POST);
$klsJenjang = $_POST['jenjang'];
$klsId = $_POST['kelas'];
$view = new rekap_siswa;
$view->connect();
$view->get_kelas_detil($klsId);
$namaKelas = $view->get_array();
$tmpl->addVar("article", "HEADLINE", "Rekap Iuran Siswa Kelas ".$klsJenjang." - ".$namaKelas['NAMA']);
$tmpl->addVar("article", "URL_XLS", "module/rekap_siswa/cetak_excel_siswa.php?j=".$klsJenjang."&i=".$klsId."");
$view->get_list_siswa($klsJenjang, $klsId);
$row=0;
while($result=$view->get_array()){
$number=$row+1;
if ($number % 2 ==0){
$class_name='table-common-even';
}else{
$class_name='';
}
$disp[$row]=array('NO'=>$number,
'NIS'=>$result['NIS'],
'NAMA'=>$result['NAMA'],