Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-xr-x
AttDateWiseReportexcel.php	4.39 KB	-rw-r--r--
Attdet.php	7.1 KB	-rw-rw-r--
AttdetPdf.php	8.74 KB	-rw-rw-r--
AttdetPdfUniclare.php	7.49 KB	-rw-rw-r--
AttdetexcelUniclare.php	5.48 KB	-rw-rw-r--
CIEAttendanceNotEligiblepdf.ph...	6.83 KB	-rw-rw-r--
CIEpendingListpdf.php	9.05 KB	-rw-rw-r--
DegreeWiseStudLstUSN.php	7.69 KB	-rw-rw-r--
DownloadExamAppFormApplication...	10.92 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	4.6 KB	-rwxr-xr-x
Generatecollegeiamarkspendingr...	7.49 KB	-rwxrwxrwx
PrintChallanEntryDetails.php	8.27 KB	-rwxr-xr-x
RVApplicationsReport.php	8.9 KB	-rwxr-xr-x
RvPcListDetailedReport.php	12.51 KB	-rwxrwxrwx
RvRtApplicationReport.php	8.86 KB	-rwxr-xr-x
absentAndMalReportPdf.php	11.5 KB	-rw-rw-r--
absentandmalpracticereport.php	10.16 KB	-rw-rw-r--
ack_exam_app_form_bulk.php	11.76 KB	-rwxr-xr-x
admlist.php	13.87 KB	-rwxrwxrwx
admregisterlist.php	7.39 KB	-rwxr-xr-x
affliation_detailed_report.php	12.56 KB	-rwxrwxrwx
appear_list_center_qp_wise.php	13.07 KB	-rwxr-xr-x
appear_list_qp_wise.php	6.32 KB	-rwxr-xr-x
appfeedetails.php	7.67 KB	-rwxr-xr-x
approval_report.php	19.63 KB	-rwxr-xr-x
attCisshortList.php	15.61 KB	-rw-r--r--
attCisshortList_sjbit.php	12.82 KB	-rw-r--r--
attDegwiseReport.php	14.2 KB	-rw-r--r--
attendanceReportForm.php	5.69 KB	-rw-rw-r--
attendanceform_pdf.php	12.35 KB	-rw-r--r--
attiacombined.php	9.52 KB	-rw-r--r--
attiacombinedReportnewexcel_sj...	12.94 KB	-rw-rw-r--
attiacombinednew.php	12.66 KB	-rw-r--r--
attiacombinednew_1.php	12.34 KB	-rw-r--r--
attiacombinednew_2.php	12.33 KB	-rw-r--r--
attiacombinednew_sjbit.php	8.7 KB	-rw-r--r--
attshortlist.php	10.72 KB	-rw-r--r--
basic_data_coll.php	6.79 KB	-rwxr-xr-x
basic_data_sum.php	6.98 KB	-rwxr-xr-x
batch_wise_details.php	4.45 KB	-rwxr-xr-x
board.php	3.86 KB	-rw-rw-r--
bundle_ack.php	13.58 KB	-rwxr-xr-x
candidatelist.php	10 KB	-rw-rw-r--
categorywisereport.php	13.27 KB	-rwxr-xr-x
categorywisereportpdf.php	7.57 KB	-rw-rw-r--
cntrtagcollstud.php	4.99 KB	-rw-rw-r--
code39.php	6.38 KB	-rwxr-xr-x
college_pending_markslist.php	6.78 KB	-rwxrwxrwx
college_pending_markslist19032...	6.48 KB	-rwxr-xr-x
convoreport.php	5.56 KB	-rw-rw-r--
copomarksexternalreportexcel.p...	7.02 KB	-rw-rw-r--
daterange.php	6.27 KB	-rw-rw-r--
degreeDetailsReport.php	7 KB	-rw-rw-r--
degreewiseMarksEntryStats.php	8.44 KB	-rw-rw-r--
elememntWiseReport.php	16.11 KB	-rw-rw-r--
empty_report_admission_det.php	8.91 KB	-rw-rw-r--
enterCOPOmarks.php	2.94 KB	-rw-rw-r--
exam_attendance_det.php	8.61 KB	-rwxr-xr-x
exam_attendance_summary.php	9.78 KB	-rwxr-xr-x
excelreport.php	27.36 KB	-rw-rw-r--
fpdf.php	147.08 KB	-rw-rw-r--
generate.php	7.32 KB	-rw-rw-r--
generateCorseRep.php	7.93 KB	-rw-r--r--
generateDaliyReportQpNitteExce...	16.34 KB	-rw-rw-r--
generatePostAdmissionTicket.ph...	51.8 KB	-rwxr-xr-x
generatePostAdmissionTicketJss...	58.53 KB	-rwxr-xr-x
generatePostAdmissionTicket_25...	47.13 KB	-rwxr-xr-x
generatePostAdmissionTicket_ol...	37.45 KB	-rwxr-xr-x
generatePrintIaMarks.php	16.19 KB	-rw-rw-r--
generatePrintIaMarksnew.php	16.28 KB	-rw-r--r--
generatePrintIaMarksnewXl.php	13.22 KB	-rw-rw-r--
generateQuestionWiseIAReportPD...	18.73 KB	-rw-rw-r--
generateThValReport.php	7.4 KB	-rw-r--r--
generateXlGraph.php	3.87 KB	-rw-rw-r--
generateadmissionreg.php	11.81 KB	-rw-r--r--
generatecoporeport_xl.php	21.08 KB	-rw-rw-r--
gerderwiseresultsheet.php	12.08 KB	-rwxr-xr-x
getDegree.php	2.27 KB	-rw-rw-r--
getDegreeAndSem.php	4.32 KB	-rw-r--r--
getIaSubjWiseReport.php	0 B	-rw-rw-r--
getNitteAdmXlreport.php	14.74 KB	-rw-rw-r--
getReportClassStud.php	6.03 KB	-rw-rw-r--
getTestTotalMarksReport.php	9.49 KB	-rw-rw-r--
getiaabsentreport.php	6.8 KB	-rw-r--r--
gradewisesubjectanalysisreport...	24.66 KB	-rw-r--r--
gradewisesubjectanalysisreport...	20.73 KB	-rw-r--r--
headerNfooter.php	4.89 KB	-rw-rw-r--
iaDegwiseIAReport.php	12.58 KB	-rw-rw-r--
iaMarksQnWiseReportExcel.php	25.41 KB	-rw-rw-r--
iaMarksReportPDF.php	10.84 KB	-rw-r--r--
iaSubjectWiseReport.php	10.74 KB	-rw-rw-r--
ia_room_allotment_datewise.php	9.08 KB	-rwxr-xr-x
iaemptyformat.php	9.63 KB	-rwxr-xr-x
iaroomallotmantsummary.php	5.28 KB	-rwxr-xr-x
iasectionwisenew.php	36.02 KB	-rw-rw-r--
invig_report.php	10.18 KB	-rw-rw-r--
invig_report_summary.php	7.74 KB	-rw-rw-r--
latEntryRprt.php	6.4 KB	-rwxr-xr-x
markListReportPdf.php	21.32 KB	-rw-rw-r--
markListReportPdfnew.php	49.6 KB	-rw-r--r--
markListReportPdfnew_24112023....	42.93 KB	-rw-r--r--
marksEntryQnWiseNewReport.php	13.13 KB	-rw-rw-r--
marksentryquestionwise.php	23.83 KB	-rw-rw-r--
mregistry.php	152.75 KB	-rw-rw-r--
pdfacknowledgeAppNo.php	10.95 KB	-rw-rw-r--
pendingcie.php	0 B	-rw-rw-r--
photo_report.php	7.04 KB	-rw-rw-r--
pi_test.php	3.45 KB	-rw-r--r--
picharttesting.php	24.78 KB	-rw-rw-r--
prbillreports.php	16.32 KB	-rw-rw-r--
principalFreeze_report.php	7.23 KB	-rw-rw-r--
printIaMarks.php	12.74 KB	-rw-r--r--
printIaMarks_old.php	12.74 KB	-rw-rw-r--
printMarkListDetailsWisenew.ph...	10.1 KB	-rw-r--r--
printMarkListDetailsWisenewExc...	15.52 KB	-rw-rw-r--
printMarkListDetailsWisenew_CI...	3.98 KB	-rw-r--r--
printMarkListDetailsWisenew_sj...	15.69 KB	-rw-r--r--
printMarkListDetailsWisenew_sj...	14.54 KB	-rw-r--r--
printMarkListSubWiseJssstu.php	28.4 KB	-rw-rw-r--
print_applications_ru.php	26.59 KB	-rw-rw-r--
progDegwiseReportPdf.php	14.15 KB	-rw-rw-r--
provisionExcelReportSrun.php	12.73 KB	-rw-rw-r--
qp_issue.php	8.47 KB	-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...	56.9 KB	-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...	33.16 KB	-rwxr-xr-x
qrhallticket.php	56.1 KB	-rw-rw-r--
r	9.23 KB	-rwxr-xr-x
regNoAllot.php	35.56 KB	-rw-rw-r--
reg_stud_list.php	8.65 KB	-rwxr-xr-x
reportAttClassCreate.php	5.14 KB	-rw-rw-r--
reportAttCount.php	12.89 KB	-rw-r--r--
reportAttCount_old_08112022.ph...	11.11 KB	-rw-r--r--
report_Xl_getpendingstudentLis...	7.93 KB	-rw-rw-r--
report_adm_lat_studwise.php	10.13 KB	-rwxr-xr-x
report_admission_details.php	26.8 KB	-rwxr-xr-x
report_admission_list.php	49.63 KB	-rwxr-xr-x
report_admission_list_bf_gcg.p...	26.39 KB	-rwxr-xr-x
report_admission_list_kswu.php	15.12 KB	-rwxr-xr-x
report_admission_list_rur.php	28 KB	-rw-rw-r--
report_admission_list_wop.php	10.31 KB	-rwxr-xr-x
report_admission_ticket.php	77.87 KB	-rw-rw-r--
report_admission_ticket_bf_uuc...	37.63 KB	-rwxr-xr-x
report_admission_ticket_jsstu....	70.16 KB	-rw-r--r--
report_admission_ticket_new.ph...	65.79 KB	-rw-rw-r--
report_attendance_sheet.php	23.77 KB	-rwxr-xr-x
report_attendance_shortage.php	9.23 KB	-rw-rw-r--
report_attendance_summary.php	11.48 KB	-rwxr-xr-x
report_attendance_summary_old....	7.19 KB	-rwxr-xr-x
report_bacth_preparation_dairy...	7 KB	-rwxr-xr-x
report_batch_practical_dairy.p...	15.35 KB	-rwxr-xr-x
report_batch_wise_details.php	8.86 KB	-rwxr-xr-x
report_batch_worksheet_details...	20.02 KB	-rwxr-xr-x
report_bulk_applications.php	26.15 KB	-rwxr-xr-x
report_bulk_applications_nitte...	26 KB	-rw-rw-r--
report_bundle_dispatch.php	15.36 KB	-rwxr-xr-x
report_candidate_list.php	31.41 KB	-rwxr-xr-x
report_candidate_list_old.php	29.91 KB	-rwxr-xr-x
report_copoMarksList.php	23.88 KB	-rw-rw-r--
report_daliy_report.php	10.47 KB	-rwxr-xr-x
report_daliy_report_qp.php	10.21 KB	-rwxr-xr-x
report_daliy_report_qp_nitte.p...	20.31 KB	-rwxr-xr-x
report_daliy_report_qp_sjbit.p...	17.49 KB	-rwxr-xr-x
report_data_sent.php	8.41 KB	-rwxr-xr-x
report_degree_list.php	4.71 KB	-rwxr-xr-x
report_deviation_report.php	7.67 KB	-rwxr-xr-x
report_evaluation_report.php	9.31 KB	-rwxr-xr-x
report_ia_ra_invigilator_dairy...	20.87 KB	-rwxr-xr-x
report_ia_ra_roomwise_register...	27.06 KB	-rw-r--r--
report_iamarks_pending.php	8.19 KB	-rwxr-xr-x
report_invigilatorDairy.php	46.77 KB	-rw-rw-r--
report_marks_deviation_report....	5.38 KB	-rwxr-xr-x
report_marks_elementwise.php	3.13 KB	-rwxr-xr-x
report_marks_entry_student_lis...	6.55 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	21.94 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.43 KB	-rwxr-xr-x
report_marks_pending.php	12.02 KB	-rwxr-xr-x
report_online_eam.php	11.59 KB	-rwxr-xr-x
report_practical_marks_details...	13.35 KB	-rwxr-xr-x
report_practical_marks_details...	23.65 KB	-rwxr-xr-x
report_practical_marks_details...	13.33 KB	-rwxr-xr-x
report_practical_marks_details...	13.32 KB	-rwxr-xr-x
report_practical_misc.php	8.24 KB	-rwxr-xr-x
report_qpcount_univ.php	5.17 KB	-rwxr-xr-x
report_ra_exl_report.php	6.89 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	46.94 KB	-rwxr-xr-x
report_ra_invigilator_dairy_bf...	22.69 KB	-rwxr-xr-x
report_ra_invigilator_dairy_gu...	19.86 KB	-rwxr-xr-x
report_ra_invigilator_dairy_ne...	49.39 KB	-rwxr-xr-x
report_ra_invigilator_dairy_sj...	32.35 KB	-rwxr-xr-x
report_ra_invigilator_dairy_st...	19.82 KB	-rw-rw-r--
report_ra_invigilators_dairy.p...	9.27 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	10.97 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.74 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	11.21 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	10.67 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	26.44 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	27.15 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	17.6 KB	-rwxr-xr-x
report_reg_list.php	33.33 KB	-rw-rw-r--
report_reg_list_gcg.php	33.55 KB	-rw-rw-r--
report_reg_list_gcg_new_040120...	33.12 KB	-rw-rw-r--
report_registerNoListNoticeBoa...	25.84 KB	-rw-rw-r--
report_registerNoListRoomBoard...	22.08 KB	-rw-rw-r--
report_revaluation.php	6.42 KB	-rwxr-xr-x
report_roomallotmentExcel.php	8.31 KB	-rw-rw-r--
report_subject_admcl_list.php	3.68 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.89 KB	-rwxr-xr-x
resultsheet.php	12.82 KB	-rwxr-xr-x
resultsheetExcel.php	6.37 KB	-rw-r--r--
resultsheet_x.php	9.15 KB	-rwxr-xr-x
resultsheetsubwise.php	11.24 KB	-rwxr-xr-x
revaluation.php	15.65 KB	-rwxr-xr-x
roomAllotment.php	37.45 KB	-rw-rw-r--
room_allotment_datewise_stph.p...	21.46 KB	-rwxr-xr-x
roomallotmantsummary.php	6.66 KB	-rwxr-xr-x
roomallotmantsummarynew.php	7.09 KB	-rwxr-xr-x
roomallotmantsummarysubjwise.p...	9.26 KB	-rw-rw-r--
roomallotmantsummarysubjwisene...	9.89 KB	-rw-r--r--
roomallotmentqpwise.php	10.22 KB	-rw-rw-r--
roomwise_register_nos_list.php	27.87 KB	-rwxr-xr-x
roomwise_register_nos_list_new...	29.38 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
semesterWiseResultReportpdf.ph...	11.03 KB	-rw-rw-r--
shortageReport.php	11.05 KB	-rw-rw-r--
std_regstr_det_reprt_xl.php	7.6 KB	-rw-rw-r--
stringspliter.php	718 B	-rwxr-xr-x
stud_wise_report.php	8.97 KB	-rw-rw-r--
studentHisResult.php	8.34 KB	-rw-r--r--
student_count.php	4.16 KB	-rwxr-xr-x
studentwiseresult.php	18.02 KB	-rw-rw-r--
studentwiseresultExcelReport.p...	10.29 KB	-rw-rw-r--
subWiseFailedStudExcelReport.p...	9.02 KB	-rw-rw-r--
subWiseFailedStudSummary.php	7.78 KB	-rw-rw-r--
subjRegReport.php	8.42 KB	-rw-r--r--
subjectDetailsReport.php	13.93 KB	-rw-rw-r--
subject_wise_student_list.php	6.2 KB	-rwxr-xr-x
subjwisepasspercentage.php	10.99 KB	-rw-rw-r--
subjwisepasspercentagePie.php	10.92 KB	-rw-r--r--
subjwiseressheet.php	12.92 KB	-rwxr-xr-x
subwiseGrafAnalysis.php	20.04 KB	-rw-r--r--
subwiseGrafAnalysis1.php	22.44 KB	-rw-r--r--
subwiseResultReport.php	12.75 KB	-rw-rw-r--
tatkal.php	4.84 KB	-rwxr-xr-x
teachFreeze_report.php	8.96 KB	-rw-r--r--
teacher_report.php	11.26 KB	-rwxr-xr-x
teacher_val_report.php	10.59 KB	-rwxr-xr-x
timetabledegreewiserpt.php	6.73 KB	-rwxrwxrwx
topsheet.php	8.59 KB	-rwxr-xr-x
verifystud.php	8.38 KB	-rwxr-xr-x
viewexamcentrenew.php	20.7 KB	-rw-rw-r--
xl_AckAppReport.php	10.02 KB	-rw-rw-r--

Code Editor : report_copoMarksList.php

<?php
$main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7);
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('GMT+5:30');
ini_set('max_execution_time', 300);
ini_set('memory_limit', '2G');

if (PHP_SAPI == 'cli')
    die('This example should only be run from a Web Browser');

/** Include PHPExcel */
$pdf_writer_class = $main_src . '/PHPExcel/Classes/PHPExcel.php';
require_once($pdf_writer_class);

function getheaders($objPHPExcel, $fileName)
{
    // To Fit To Page while printing
    ini_set('max_execution_time', '300');
    $objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToWidth(1);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToHeight(0);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setHorizontalCentered(true);
    $objPHPExcel->getActiveSheet()->getPageSetup()->setVerticalCentered(false);

// Redirect output to a client’s web browser (Excel5)
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename=' . $fileName);
    header('Cache-Control: max-age=0');
    // If you're serving to IE 9, then the following may be needed
    header('Cache-Control: max-age=1');
    // If you're serving to IE over SSL, then the following may be needed
    header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
    header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
    header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
    header('Pragma: public'); // HTTP/1.0
    ob_clean();
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    $objWriter->save('php://output');
}

function reportCOPOMarksList($aobj_context)
{
	$collcode=$_SESSION['collcode'];
	// var_dump($collcode);die();
	$funivcode=$_SESSION['univcode'];
	$degree=$aobj_context->mobj_data['degree'];
	$examno=$aobj_context->mobj_data['examno'];
	$subcode=$aobj_context->mobj_data['subject'];
	$database=$aobj_context->mobj_data['db'];

$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
    $main_src=$main_src_obj[1];
    $pdf_writer_class=$aobj_context->main_src."/maya-pdf/fpdf.php";
    $root_pdf_file_download=$aobj_context->main_src."/Report_details/output/report_me_student_list.pdf";
	
	include($pdf_writer_class);	
    $objPHPExcel = new PHPExcel();
    $fileName ="CoPo MarksList.xls";
  
    $objPHPExcel->getProperties()->setCreator("Uniclare")
    ->setLastModifiedBy("Me")->setTitle("My Excel Sheet")
    ->setSubject("My Excel Sheet")->setDescription("Excel Sheet")
    ->setKeywords("Excel Sheet")->setCategory("Me");
    
    $objPHPExcel->setActiveSheetIndex(0);
    $styleArray = array(
        'borders' => array(
            'allborders' => array(
                'style' => PHPExcel_Style_Border::BORDER_THIN,
                'color' => array('argb' => '000000'),
            ),
        ),
    );
	$headerStyle = [
		'font' => [
			'bold' => true,
			'size' => 12, 
		],
		'alignment' => [
			'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
			'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER,
		],
	];

$beta = ['A','B','C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z',
			 'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ',
			 'BA', 'BB', 'BC', 'BD', 'BE', 'BF', 'BG', 'BH', 'BI', 'BJ', 'BK', 'BL', 'BM', 'BN', 'BO', 'BP', 'BQ', 'BR', 'BS', 'BT', 'BU', 'BV', 'BW', 'BX', 'BY', 'BZ',
			 'CA', 'CB', 'CC', 'CD', 'CE', 'CF', 'CG', 'CH', 'CI', 'CJ', 'CK', 'CL', 'CM', 'CN', 'CO', 'CP', 'CQ', 'CR', 'CS', 'CT', 'CU', 'CV', 'CW', 'CX', 'CY', 'CZ'];

$query1="SELECT DISTINCT fiasubname,fcsubcode FROM markscopo 
	         WHERE fdegree = '{$degree}' AND fexamno = '{$examno}' AND left(fsubcode,4) = '{$subcode}' AND fcollcode='{$collcode}'";

$res1 = $aobj_context->mobj_db->GetAll($query1);
	$sheetIndex = 0;
    foreach ($res1 as $sheet) {
        $fiasubname = $sheet['fiasubname'];
        $fcsubcode = $sheet['fcsubcode'];
        if ($sheetIndex > 0) {
            $objPHPExcel->createSheet();
        }
        $objPHPExcel->setActiveSheetIndex($sheetIndex);
        $objPHPExcel->getActiveSheet()->setTitle(substr($fiasubname, 0, 31));

$page_header_university = "select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
		FUNIVADD1 as 'state', pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";
		$lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university);
		$get_coll_name = "select fcollname as FCOLLNAME, ftown as FTOWN from college 
		where fcollcode = '{$collcode}'";
		$res_coll_name = $aobj_context->mobj_db->GetRow($get_coll_name);

$FUNIVNAME = $lobj_page_header_university['FUNIVNAME'];
		$STATE = $lobj_page_header_university['state'];
		$objPHPExcel->getActiveSheet()->getStyle('1:10')->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(18);
		$objPHPExcel->getActiveSheet()->getStyle('2:2')->getFont()->setSize(18);
		$objPHPExcel->getActiveSheet()->getStyle('3:3')->getFont()->setSize(14);
		$objPHPExcel->getActiveSheet()->getStyle('4:4')->getFont()->setSize(13);
		$objPHPExcel->getActiveSheet()->getStyle('7:10')->getFont()->setSize(13);

$que="SELECT distinct fsubname FROM subject WHERE CONCAT(fsubcode)='{$subcode}' AND fdegree='{$degree}'";
		$result = $aobj_context->mobj_db->GetRow($que);
		
		$query2="SELECT DISTINCT ftest FROM markscopo
		         WHERE fdegree = '{$degree}' AND fexamno = '{$examno}' AND left(fsubcode,4) = '{$subcode}' AND fcsubcode = '{$fcsubcode}'";
			
        $res2 = $aobj_context->mobj_db->GetAll($query2);
		$objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
		$objPHPExcel->getActiveSheet()->mergeCells('A8:B8');
		$objPHPExcel->getActiveSheet()->mergeCells('A9:B9');
		$objPHPExcel->getActiveSheet()->setCellValue('A7', 'Internal Assessment Type');
		$objPHPExcel->getActiveSheet()->setCellValue('A8', 'Question No');
		$objPHPExcel->getActiveSheet()->setCellValue('A9', 'Question-CO No');
		$objPHPExcel->getActiveSheet()->setCellValue('A10', 'Sl.No');
		$objPHPExcel->getActiveSheet()->setCellValue('B10', 'USN/Q.Marks');
		$objPHPExcel->getActiveSheet()->getStyle('B10')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		for($a=7;$a<11;$a++){
			$objPHPExcel->getActiveSheet()->getStyle('A'.$a)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		}
		$i=0;
		$j=0;
		$k=2;
	    foreach ($res2 as $test) {
		$query3 = "SELECT DISTINCT fqncode, fqnco, fqnmaxmarks FROM markscopo 
				   WHERE fdegree = '{$degree}' AND fexamno = '{$examno}' AND left(fsubcode,4) = '{$subcode}' 
				   AND fcsubcode = '{$fcsubcode}' AND ftest='{$test['ftest']}'";
				   
		$res3 = $aobj_context->mobj_db->GetAll($query3);
		$count = count($res3); 
		$startCell = $beta[$k] . '7';
		$endCell = $beta[$k + ($count - 1)] . '7';
		$objPHPExcel->getActiveSheet()->mergeCells("$startCell:$endCell");
		$objPHPExcel->getActiveSheet()->setCellValue($beta[$k] . '7', $test['ftest']);
	    $objPHPExcel->getActiveSheet()->getStyle($startCell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle("$startCell:$endCell")->applyFromArray($headerStyle);

for($b=1;$b<5;$b++){
			$topRowStart = $beta[$k] . $b;
			$topRowEnd = $beta[$k + ($count-1)] . $b;
			$objPHPExcel->getActiveSheet()->mergeCells("$topRowStart:$topRowEnd");
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$k].'1',"         ". $lobj_page_header_university['FUNIVNAME']);
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$k].'2',"         College -".$res_coll_name['FCOLLNAME']." - ". $lobj_page_header_university['state']);
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$k].'3',"            Degree -".$degree. "      Semester -".$examno );
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$k].'4',"            Subject -".$result['fsubname']);
		 }
		foreach ($res3 as $value) {
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$k] . '8', $value['fqncode']);
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$k] . '9', $value['fqnco']);
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$k] . '10', $value['fqnmaxmarks']);
			for($a=8;$a<11;$a++){
				$objPHPExcel->getActiveSheet()->getStyle($beta[$k].$a)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			}
			$k++; 
		}
		$query4 = "SELECT fregno, GROUP_CONCAT(fqncode, '-', fqnco, '-', fqnmaxmarks, '-', fqnsecmarks ORDER BY fqncode SEPARATOR '|') AS marks
				   FROM markscopo WHERE fdegree = '{$degree}' AND fexamno = '{$examno}' AND left(fsubcode,4) = '{$subcode}' 
				   AND fcsubcode = '{$fcsubcode}' AND ftest='{$test['ftest']}' GROUP BY fregno";
				   	
		$res4 = $aobj_context->mobj_db->GetAll($query4);
	
		$slno = 1;
		$rowIndex = 11;
		foreach ($res4 as $val) {
			$objPHPExcel->getActiveSheet()->setCellValue("A$rowIndex", $slno);
			$objPHPExcel->getActiveSheet()->setCellValue("B$rowIndex", $val['fregno']);
			$objPHPExcel->getActiveSheet()->getStyle("A$rowIndex")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle("B$rowIndex")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$split = explode("|", $val['marks']);
			foreach ($split as $v) {
				$splitagain = explode("-", $v);
				foreach ($res3 as $qn) {
					if ($qn['fqncode'] == $splitagain[0]) {
						$columnIndex = array_search($qn['fqncode'], array_column($res3, 'fqncode')) + ($k - $count);
						$objPHPExcel->getActiveSheet()->setCellValue($beta[$columnIndex] . $rowIndex, $splitagain[3]);
						$objPHPExcel->getActiveSheet()->getStyle($beta[$columnIndex] . $rowIndex, $splitagain[3])->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
					}
				}
			}
			$rowIndex++;
			$slno++;
		}
	}
	$sheetIndex++;
	$objPHPExcel->getActiveSheet()->getStyle('A1:'.$beta[$k-1] . ($rowIndex-1))->applyFromArray($styleArray);
	
}
		$objPHPExcel->createSheet();
		$objPHPExcel->setActiveSheetIndex($sheetIndex)->setTitle("CES");
		$objPHPExcel->getActiveSheet()->getStyle('1:6')->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(18);
		$objPHPExcel->getActiveSheet()->getStyle('2:2')->getFont()->setSize(18);
		$objPHPExcel->getActiveSheet()->getStyle('3:3')->getFont()->setSize(14);
		$objPHPExcel->getActiveSheet()->getStyle('4:4')->getFont()->setSize(13);
		// $objPHPExcel->getActiveSheet()->getStyle('7:10')->getFont()->setSize(13);
		$objPHPExcel->getActiveSheet()->mergeCells('A5:B5');
	
		$objPHPExcel->getActiveSheet()->setCellValue('A1',"         ". $lobj_page_header_university['FUNIVNAME']);
		$objPHPExcel->getActiveSheet()->setCellValue('A2', "            College -".$res_coll_name['FCOLLNAME']." - ". $lobj_page_header_university['state']);
		$objPHPExcel->getActiveSheet()->setCellValue('A3', "            Degree -".$degree. "      Semester -".$examno );
		$objPHPExcel->getActiveSheet()->setCellValue('A4', "            Subject -".$result['fsubname']);
		 
		$querys1="SELECT *FROM studcopo WHERE LEFT(fsubcode,4)='{$subcode}' AND fdegree='{$degree}' AND fcollcode='{$collcode}' AND fexamno='{$examno}'";
		$resCES1 = $aobj_context->mobj_db->GetAll($querys1);
        $objPHPExcel->getActiveSheet()->setCellValue('A5',"CO Mapping");
		$objPHPExcel->getActiveSheet()->setCellValue('A6',"Sl.No");
		$objPHPExcel->getActiveSheet()->setCellValue('B6',"Reg.No");

$querys2 = "SELECT COUNT(*) AS ColumnCount
				    FROM INFORMATION_SCHEMA.COLUMNS
					WHERE TABLE_NAME = 'studcopo' AND TABLE_SCHEMA = 'logisys3_$database'";
		$resCES2 = $aobj_context->mobj_db->GetRow($querys2);
		for($i=0; $i<($resCES2['ColumnCount']-9);$i++){
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$i+2]."6","CO".($i+1));
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$i+2]."5",($i+1));
			$objPHPExcel->getActiveSheet()->getStyle($beta[$i+2]."6","CO".($i+1))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle($beta[$i+2]."5","CO".($i+1))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

}
	
		$sl=1;
		$index=7;
		
		foreach ($resCES1 as $key => $val) {
			$objPHPExcel->getActiveSheet()->setCellValue("A$index", $sl);
			$objPHPExcel->getActiveSheet()->setCellValue("B$index", $val['fregno']);
			
			$objPHPExcel->getActiveSheet()->setCellValue("C$index", $val['fco1']);
			$objPHPExcel->getActiveSheet()->setCellValue("D$index", $val['fco2']);
			$objPHPExcel->getActiveSheet()->setCellValue("E$index", $val['fco3']);
			$objPHPExcel->getActiveSheet()->setCellValue("F$index", $val['fco4']);
			$objPHPExcel->getActiveSheet()->setCellValue("G$index", $val['fco5']);
			$objPHPExcel->getActiveSheet()->setCellValue("H$index", $val['fco6']);
		
			$objPHPExcel->getActiveSheet()->getStyle("A$index")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		    $objPHPExcel->getActiveSheet()->getStyle("B$index")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle("C$index")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle("D$index")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle("E$index")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle("F$index")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle("G$index")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$objPHPExcel->getActiveSheet()->getStyle("H$index")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$sl++;
			$index++;
		}

$objPHPExcel->createSheet();
    $objPHPExcel->setActiveSheetIndex($sheetIndex+1)->setTitle("IA CO");
	$objPHPExcel->getActiveSheet()->getStyle('1:10')->getFont()->setBold(true);
	$objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(18);
	$objPHPExcel->getActiveSheet()->getStyle('2:2')->getFont()->setSize(18);
	$objPHPExcel->getActiveSheet()->getStyle('3:3')->getFont()->setSize(14);
	$objPHPExcel->getActiveSheet()->getStyle('4:4')->getFont()->setSize(13);
	$objPHPExcel->getActiveSheet()->getStyle('7:10')->getFont()->setSize(13);
	$objPHPExcel->getActiveSheet()->mergeCells('A9:B9');
	$objPHPExcel->getActiveSheet()->mergeCells('A10:B10');
	$objPHPExcel->getActiveSheet()->mergeCells('A11:B11');
	$objPHPExcel->getActiveSheet()->mergeCells('A12:B12');
	$objPHPExcel->getActiveSheet()->mergeCells('A13:B13');
	$objPHPExcel->getActiveSheet()->setCellValue('A1',"         ". $lobj_page_header_university['FUNIVNAME']);
	$objPHPExcel->getActiveSheet()->setCellValue('A2', "            College -".$res_coll_name['FCOLLNAME']." - ". $lobj_page_header_university['state']);
	$objPHPExcel->getActiveSheet()->setCellValue('A3', "            Degree -".$degree. "      Semester -".$examno );
	$objPHPExcel->getActiveSheet()->setCellValue('A4', "            Subject -".$result['fsubname']);
	$objPHPExcel->getActiveSheet()->setCellValue('A9', 'Course Outcomes');
	$objPHPExcel->getActiveSheet()->setCellValue('A10', 'Component No.');
	$objPHPExcel->getActiveSheet()->setCellValue('A11', 'Max. Marks In Each Componenet');
	$objPHPExcel->getActiveSheet()->setCellValue('A12', 'Target Marks');
	$objPHPExcel->getActiveSheet()->setCellValue('A13', 'Percentage Of Students Meeting The Target');

$queryIA1 = "SELECT DISTINCT fqnco FROM markscopo 
	             WHERE fdegree='{$degree}' AND fcollcode='{$collcode}' AND left(fsubcode,4)='{$subcode}' AND fexamno='{$examno}'";
    $resIA1 = $aobj_context->mobj_db->GetAll($queryIA1);
	$a=2;
	function numberToRoman($num) {
		$map = array(
			'I'    => 1, 'IV'   => 4, 'V'    => 5, 'IX'   => 9,
			'X'    => 10, 'XL'  => 40, 'L'   => 50, 'XC'  => 90,
			'C'    => 100, 'CD' => 400, 'D'  => 500, 'CM' => 900,
			'M'    => 1000
		);
		$result = '';
		foreach (array_reverse($map) as $roman => $value) {
			while ($num >= $value) {
				$result .= $roman;
				$num -= $value;
			}
		}
		return $result;
	}
	function roundUp($number, $decimalPlaces) {
		$factor = pow(10, $decimalPlaces);
		return ceil($number * $factor) / $factor;
	}
	$e=0;
	$g=count($resIA1)*3+2;
	$multArr = [];
	$max=[];
	foreach($resIA1 as $cono){
		$queryIA2="SELECT DISTINCT fiasubname FROM markscopo 
		           WHERE fqnco='{$cono['fqnco']}' AND fdegree='{$degree}' AND fcollcode='{$collcode}' AND left(fsubcode,4)='{$subcode}' AND fexamno='{$examno}'";
		$resIA2 = $aobj_context->mobj_db->GetAll($queryIA2);
		$count = count($resIA2); 
		$startCell = $beta[$a] . '9';
		$endCell = $beta[$a + ($count - 1)] . '9';
		$objPHPExcel->getActiveSheet()->setCellValue($beta[$a] . '9', $cono['fqnco']);
		$objPHPExcel->getActiveSheet()->mergeCells("$startCell:$endCell");
		$objPHPExcel->getActiveSheet()->getStyle($startCell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle("$startCell:$endCell")->applyFromArray($headerStyle);

$counter = 1;
		$d=0;
		foreach($resIA2 as $component){
			$romanNumber = numberToRoman($counter);
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$a] . '10', $romanNumber);
			$objPHPExcel->getActiveSheet()->getStyle($beta[$a] . '10')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			
			$queryIA3 = "SELECT DISTINCT fregno,GROUP_CONCAT(fqnco,'*',fiasubname,'*',fqnsecmarks ORDER BY fregno SEPARATOR '|') AS marks 
						 FROM markscopo WHERE fqnco='{$cono['fqnco']}' AND fdegree='{$degree}' AND fcollcode='{$collcode}' 
						 AND left(fsubcode,4)='{$subcode}' AND fexamno='{$examno}' AND fiasubname='{$component['fiasubname']}'  GROUP BY fregno";
						//  var_dump($queryIA3);die();
			$resIA3 = $aobj_context->mobj_db->GetAll($queryIA3);
			$slno = 1;
		    $rowIndex1 = 14;
			$highestSum=0;	
			$highestSumArray = [];
			$arrSum=[];
			$arrhighest = [];
		    foreach($resIA3 as $value){
				$objPHPExcel->getActiveSheet()->setCellValue("A$rowIndex1", $slno);
				$objPHPExcel->getActiveSheet()->setCellValue("B$rowIndex1", $value['fregno']);
				$objPHPExcel->getActiveSheet()->getStyle("A$rowIndex1")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				$objPHPExcel->getActiveSheet()->getStyle("B$rowIndex1")->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$split = explode("|", $value['marks']);
				$sum=0;
				foreach ($split as $v) {
					$splitagain = explode("*", $v);
						if ($component['fiasubname'] == $splitagain[1]) {
							if (isset($splitagain[2])) {
								$sum += (int)$splitagain[2];
							}
						}
				}
				array_push($arrSum,$sum);
				if ($sum > $highestSum) {
					$highestSum = $sum;
				}
				// array_push($arrhighest,$highestSum);
				$objPHPExcel->getActiveSheet()->setCellValue($beta[$a] . $rowIndex1, $sum);
				$objPHPExcel->getActiveSheet()->getStyle($beta[$a] . $rowIndex1)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				$slno++;
				$rowIndex1++;
				$highestSumArray[] = $highestSum;
		};
			$objPHPExcel->getActiveSheet()->setCellValue($beta[$a] . '11', max($highestSumArray));
		
		/*Target Marks */
			$array=[60,60,60,60,60];
				preg_match_all('/\d+/', max($highestSumArray), $matches);
				$maxArray = $matches[0];
				
			for ($d = 0; $d < count($maxArray); $d++) {
				if (isset($array[$d])) {
					$calculatedValue = ($maxArray[$d] *60) / 100;
				}
			} 
		
			
			  $objPHPExcel->getActiveSheet()->setCellValue($beta[$a] . '12', $calculatedValue);
			  $countAboveCalculatedValue=0;
			  foreach($resIA3 as $value){
				$split = explode("|", $value['marks']);
				$sum=0;
				foreach ($split as $v) {
					$splitagain = explode("*", $v);
						if ($component['fiasubname'] == $splitagain[1]) {
							if (isset($splitagain[2])) {
								$sum += (int)$splitagain[2];
							}
						}
				}
			/*Percentage Of Students Meeting The Target */
				if($sum>$calculatedValue){
					$countAboveCalculatedValue++;
				}
				for ($d = 0; $d < count($array); $d++) {
                   $cal=($countAboveCalculatedValue*100)/60;
				}
				
				$roundedValue = roundUp($cal, 1);
			}
				
			$maxValue = max($highestSumArray);
			array_push($arrhighest, $maxValue);
			array_push($max,$arrhighest[0]);
			
				$arr=[60,20,20,60,20,20,60,20,20,60,20,20,60,20,20];//this format correct
				$count2=count($arrSum);
				$f=$rowIndex1-$count2;
				$groupSize = count($resIA3);
				$groupedTotals = [];
				array_push($multArr, $arrSum);
				// $t=0;
				//  for($d=$t;$d<$count2;$d++){
				// 	$total=$arrSum[$d]*$arr[$e]/10;//instead of 10 its divided by that highest marks like 25
				// 	var_dump($arrSum, 'arrSum,', $arr, '$arr', $d, $e, $f, $g);
				// 	$objPHPExcel->getActiveSheet()->setCellValue($beta[$g]. $f, $total);
				// 		if($d==($count2-1)){
				// 			$g++;
				// 			$e++;
				// 		}
				// 		$f++;
				
				// 	$t++;
				//  }
				//  die();
			  $objPHPExcel->getActiveSheet()->setCellValue($beta[$a] . '13', $roundedValue);
			$a++;
		$counter++;
		}
	}
// var_dump($max);die();
	
	$y=0;
	$x=14;
	$w=1;
	$v=14;
	$z=0;
    $p=0;
	// for ($z=0; $z < count($multArr[0]); $z++) { 
	for ($i=0; $i < count($multArr[0]); $i++) { 
		foreach ($multArr as $key => $value) {
			// var_dump($multArr[$i]);
				$total = ($multArr[$i][$key] * 60) / $max[$p] + ($multArr[$i+1][$key] * 20) /$max[$p+1] + ($multArr[$i+2][$key] * 20) /$max[$p+2] ;
			
				$grandtotal=roundUp($total, 1);
				
				$objPHPExcel->getActiveSheet()->setCellValue($beta[$g].$x, $grandtotal);
				$x++;
				$z++;
				$p+=count($resIA2);
		}
		$g++;
		$x = $v;
	}

$b=$a;
	$count1 = 1;
	foreach($resIA2 as $component){
		$romanNumber = numberToRoman($count1);
		$objPHPExcel->getActiveSheet()->setCellValue($beta[$b] . '10', $romanNumber);
		$objPHPExcel->getActiveSheet()->setCellValue('R11', '0.60');
		$objPHPExcel->getActiveSheet()->setCellValue('S11', '0.20');
		$objPHPExcel->getActiveSheet()->setCellValue('T11', '0.20');
		$b++;
		$count1++;
	}
	$c=$a;
	foreach($resIA1 as $cono){
		$count = count($resIA1);
		$objPHPExcel->getActiveSheet()->setCellValue($beta[$c] . '13', $cono['fqnco']);
		$objPHPExcel->getActiveSheet()->mergeCells($beta[$a].'8:'.$beta[$a+($count-1)].'8');
		$objPHPExcel->getActiveSheet()->mergeCells($beta[$a].'9:'.$beta[$a+($count-1)].'9');
		$objPHPExcel->getActiveSheet()->mergeCells('A1:'.$beta[$a+($count-1)].'1');
		$objPHPExcel->getActiveSheet()->mergeCells('A2:'.$beta[$a+($count-1)].'2');
		$objPHPExcel->getActiveSheet()->mergeCells('A3:'.$beta[$a+($count-1)].'3');
		$objPHPExcel->getActiveSheet()->mergeCells('A4:'.$beta[$a+($count-1)].'4');
		$c++;
	}
	$objPHPExcel->getActiveSheet()->mergeCells('C8:'.$beta[$a-1] . '8');
	$objPHPExcel->getActiveSheet()->setCellValue('C8','IA Marks Of Individual Components');
	$objPHPExcel->getActiveSheet()->setCellValue($beta[$a] . '8','Overall CO Computation');
	$objPHPExcel->getActiveSheet()->setCellValue($beta[$a] . '9','Weights Assigned To Each Components');
	
	$objPHPExcel->getActiveSheet()->getStyle('C8')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
	$objPHPExcel->getActiveSheet()->getStyle($beta[$a] . '8')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
   $objPHPExcel->getActiveSheet()->getStyle($beta[$a] . '9')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
   for($z=0;$z<5;$z++){
	$objPHPExcel->getActiveSheet()->getStyle('A'.$z)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
   }
   $objPHPExcel->getActiveSheet()->getStyle('A1:'.$beta[$a+count($resIA1)-1].($rowIndex1-1))->applyFromArray($styleArray);
   $objPHPExcel->getActiveSheet()->getStyle('A1:'.$beta[$a+count($resIA1)-1].'13')->applyFromArray($headerStyle);

getheaders($objPHPExcel, $fileName);

}

${this.title}

Code Editor : report_copoMarksList.php