$F->setCellValue('D' . $Line, getSession($r['session']));
$F->setCellValue('E' . $Line, getSemester($r['sem_year']));
$F->setCellValue('F' . $Line, $r['admission_fee']);
$F->setCellValue('G' . $Line, $r['course_fee_year_sem']);
$F->setCellValue('H' . $Line, $r['course_fee_parameter']);
$F->setCellValue('I' . $Line, $r['library_fee']);
$F->setCellValue('J' . $Line, $r['union_magazine']);
$F->setCellValue('K' . $Line, $r['saf_fee']);
$F->setCellValue('L' . $Line, $r['development_fee']);
$F->setCellValue('M' . $Line, $r['interent_fee']);
$F->setCellValue('N' . $Line, $r['laboratory_fee']);
$F->setCellValue('O' . $Line, $r['student_safety']);
$F->setCellValue('P' . $Line, $r['sports_fee']);
$F->setCellValue('Q' . $Line, $r['hostel_fee']);
$F->setCellValue('R' . $Line, $r['total_fee']);
$F->setCellValue('S' . $Line, getFeeCategory($r['fee_category_id']));
if ($r['status'] == 1) {
$F->setCellValue('T' . $Line, "Active");
} else {
$F->setCellValue('T' . $Line, "Inactive");
}
$F->setCellValue('U' . $Line, getCreator($r['created_by_id']));
$Line = $Line + 1;
}
header('Content-Type: application/vnd.ms-excel');
//$resolve=getDepartmentCenter($deptidcenterid,$bt);
$filename = "DU | Fee Structure Master Report-" . time() . ".xls";
header("Content-Disposition: attachment;filename=" . $filename);
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
//$objWriter->save(str_replace('.php', '.xls', __FILE__));
}
$F->setCellValue('A' . $Line, $r['student_id']);
$F->setCellValue('B' . $Line, $r['student_name']);
$F->setCellValue('C' . $Line, getDepartmentCenter($r['dept_center_code'], 'dept'));
$F->setCellValue('D' . $Line, getDepartmentCenterCourse($r['dept_center_course_code'], 'dept'));
$F->setCellValue('E' . $Line, getSemester($r['semester_code']));
$F->setCellValue('F' . $Line, $r['year_of_admission']);
$F->setCellValue('G' . $Line, $r['registration_no']);
$F->setCellValue('H' . $Line, $r['roll_no']);
$F->setCellValue('I' . $Line, $r['fathers_name']);
$F->setCellValue('J' . $Line, $r['mothers_name']);
$F->setCellValue('K' . $Line, $r['dob']);
$F->setCellValue('L' . $Line, $r['sex']);
$F->setCellValue('M' . $Line, $r['community']);
$F->setCellValue('N' . $Line, $r['region']);
$F->setCellValue('O' . $Line, getFeeCategory($r['fee_category']));
$F->setCellValue('P' . $Line, $r['mb_no']);
$F->setCellValue('Q' . $Line, $r['email_id']);
$F->setCellValue('R' . $Line, getSemester($r['fee_paid_upto_semester_code']));
$F->setCellValue('S' . $Line, $reside);
$F->setCellValue('T' . $Line, $r['student_id']);
$F->setCellValue('U' . $Line, $r['password']);
$F->setCellValue('V' . $Line, getCreator($r['created_by_id']));
$Line = $Line + 1;
}
header('Content-Type: application/vnd.ms-excel');
$resolve = getDepartmentCenter($deptidcenterid, 'dept');
$resolvecourse = getDepartmentCenterCourse($courseid, 'dept');
$filename = 'DU Student Data- ' . $resolve . "-" . $resolvecourse . "-" . time() . ".xls";
header("Content-Disposition: attachment;filename=" . $filename);
header('Cache-Control: max-age=0');
</tr>
</thead>
<tbody class="no-border-x no-border-y">
<tr>
<td style="width:10%;"><?php
echo $year_of_admission;
?>
</td>
<td><?php
echo getSemester($fee_paid_upto_semester_code);
?>
</td>
<td><?php
echo getFeeCategory($fee_category);
?>
</td>
<td><?php
if ($reside == 1) {
echo "HOSTEL";
} else {
echo "OUTSIDE";
}
?>
</td>
<td ><?php
if ($rowdd111['fee_paid'] != '') {
?>
<span class="label label-success"><?php