Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 18.191.198.245
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
univadmin /
Reports /
[ HOME SHELL ]
Name
Size
Permission
Action
custom
[ DIR ]
drwxr-xr-x
AdmApprovalRpt.php
8.81
KB
-rwxr-xr-x
AdmFee_Course_Coll_Cast_Hd.php
10.83
KB
-rwxr-xr-x
AdmFee_Course_Coll_Cast_HdEx.p...
11.33
KB
-rwxr-xr-x
AdmSumCourseColl.php
10.21
KB
-rwxr-xr-x
AdmisionDegReport.php
8.61
KB
-rw-rw-r--
AdmissionReport.php
10.89
KB
-rwxr-xr-x
AuthoLetterReport.php
10.89
KB
-rw-rw-r--
Centerwise_Collegewise_Student...
13.69
KB
-rwxr-xr-x
Cntrwiseanswerindent.php
8.05
KB
-rwxr-xr-x
CollCateGenWiseReport_excel.ph...
9.58
KB
-rwxr-xr-x
CollCateGenWiseSumryReport.php
13.15
KB
-rwxr-xr-x
CollCateGenWiseSumryReport_vsk...
13.1
KB
-rwxr-xr-x
CollwiseMalPracticeReport.php
9
KB
-rwxr-xr-x
DYPIndent.php
6.77
KB
-rw-rw-r--
EGOV_generateBillReport.php
24.03
KB
-rw-rw-r--
ExamAppSumCourseWiseExcel.php
10.55
KB
-rwxr-xr-x
ExamApplicationSummaryCoursewi...
11.31
KB
-rwxr-xr-x
ExamFeeDetails.php
15.42
KB
-rwxr-xr-x
ExamFeeDetailsExcel.php
14.41
KB
-rwxr-xr-x
ExamRegistrationRprt.php
12.47
KB
-rwxr-xr-x
ExmRegstDetReport.php
12.22
KB
-rwxr-xr-x
GenerateMCQKeyAns.php
5.88
KB
-rw-r--r--
Generatecollegeiamarkspendingr...
6.75
KB
-rw-rw-r--
IAPendingRegNoWise.php
10.41
KB
-rwxr-xr-x
IAPendingRegWiseExcel.php
13.34
KB
-rwxr-xr-x
IAPendingRegWiseExcel_IA_tes.p...
11.63
KB
-rwxr-xr-x
LogReport.php
9.85
KB
-rwxr-xr-x
MPEXCEL.php
8.34
KB
-rw-rw-r--
MasboardReport.php
5.67
KB
-rw-rw-r--
MasboardReportPDF.php
6.77
KB
-rw-rw-r--
PC_RV_Report.php
7.19
KB
-rw-r--r--
PRPENDING_REG_NO_WISE_Excel.ph...
10.59
KB
-rwxr-xr-x
PRPENDING_REG_NO_WISE_Excel_ol...
11.3
KB
-rwxr-xr-x
PRPendingDetailed_Report.php
9.38
KB
-rwxr-xr-x
PRPendingDetailed_excelnew.php
10.89
KB
-rwxr-xr-x
PracticalIndent.php
5.79
KB
-rw-rw-r--
QPINDENT_SRN_WISE.php
7.02
KB
-rw-r--r--
QPINDENT_SRN_WISE_old.php
7.02
KB
-rw-r--r--
QpSummaryReport.php
14.87
KB
-rw-rw-r--
QpcodewiseMalPracticeReport.ph...
9.22
KB
-rwxr-xr-x
RVRTFeeSummary.php
12.61
KB
-rwxr-xr-x
RV_RT_PC_Sum.php
10.64
KB
-rwxr-xr-x
RV_RT_PC_Sum_1.php
10.3
KB
-rwxr-xr-x
RV_RT_PC_Sum_2.php
10.27
KB
-rwxr-xr-x
ResultStatsCategoryWise.php
37.55
KB
-rw-r--r--
ResultStatsCollegeWise.php
13.2
KB
-rw-rw-r--
ResultStatsDegreeWise.php
12.65
KB
-rw-rw-r--
ResultStatsGenderWise.php
13.29
KB
-rw-r--r--
RvPcCheckList.php
8.14
KB
-rwxr-xr-x
RvPcListReport.php
10.95
KB
-rwxr-xr-x
RvPcListSummReport.php
11.88
KB
-rwxr-xr-x
RvRtFeeReportPDF.php
11.63
KB
-rwxr-xr-x
Template.php
9.99
KB
-rwxr-xr-x
Template_EXCEL.php
8.11
KB
-rwxr-xr-x
Template_PFD.php
7.07
KB
-rwxr-xr-x
UUCMSReport.php
5.32
KB
-rw-r--r--
ViewExamCentreNewReportexcel.p...
12.64
KB
-rw-r--r--
admReportDet.php
11.92
KB
-rwxr-xr-x
admapprovereport.php
10.17
KB
-rw-r--r--
admapprovereport_detailedexcel...
15.04
KB
-rw-r--r--
admapprovereport_summaryexcel....
11.49
KB
-rw-r--r--
admissionFeesummary.php
8.45
KB
-rwxr-xr-x
admissioncombinationwiseintake...
11.61
KB
-rwxr-xr-x
admsummmaryexcel.php
11.74
KB
-rwxr-xr-x
admsummmaryreport.php
11.31
KB
-rwxr-xr-x
assignUserMenus_.php
4
KB
-rwxr-xr-x
attendance_block_report.php
7.06
KB
-rw-r--r--
attendance_report_det.php
12.98
KB
-rw-r--r--
attupd.html
3.46
KB
-rw-r--r--
bundledispatch_pdf.php
6.32
KB
-rw-r--r--
candidatelist.php
10.53
KB
-rw-rw-r--
catgoryWiseExamFeeReport.php
13.87
KB
-rwxr-xr-x
centerdegreesemister.php
15.99
KB
-rwxr-xr-x
centerwisedegreewiseqpwise.php
12.54
KB
-rwxr-xr-x
centerwiseqpwisestudentcount.p...
12.48
KB
-rwxr-xr-x
centerwisesemisterwise.php
19.21
KB
-rwxr-xr-x
centerwisestudentcount.php
12.51
KB
-rwxr-xr-x
centrewisedatewise_EXCEL.php
14.04
KB
-rw-r--r--
col_deg_sum_report.php
17.24
KB
-rw-rw-r--
colgwiseDegWiseReport.php
11.18
KB
-rwxr-xr-x
college_reports_xl.php
15.03
KB
-rw-rw-r--
college_wise_student_count.php
12.08
KB
-rw-rw-r--
collwisedeglist.php
8.45
KB
-rwxr-xr-x
combwiseStudCunt.php
8.86
KB
-rwxr-xr-x
convodetexl.php
10.16
KB
-rwxr-xr-x
convosummary.php
6.59
KB
-rwxr-xr-x
createboeReport.php
8.41
KB
-rwxr-xr-x
dailyFeeDetReportExcel.php
13.54
KB
-rw-r--r--
dailyFeeDetReportPDF.php
12.81
KB
-rw-r--r--
dailyvaluationsummary.php
9.17
KB
-rwxr-xr-x
datewWiseValDet.php
8.71
KB
-rwxr-xr-x
decodeMissDet.php
6.12
KB
-rw-r--r--
degGrpReport.php
7.4
KB
-rwxr-xr-x
degreeEntryDet.php
10.25
KB
-rwxr-xr-x
degreeGroupReport.php
5.46
KB
-rw-rw-r--
degreeListDetailed.php
8.92
KB
-rwxr-xr-x
degreeWiseCollegeList.pdf
8.16
KB
-rwxr-xr-x
degreeWiseCollegeList.php
8.83
KB
-rwxr-xr-x
degreeWiseCombinationList.php
6
KB
-rwxr-xr-x
degreeWiseStudentList.php
11.38
KB
-rwxr-xr-x
degreeWiseStudentlist_excel.ph...
9.57
KB
-rwxr-xr-x
degreeWiseSubjectList.php
13.58
KB
-rwxr-xr-x
degree_wise_student_list.php
12.06
KB
-rw-rw-r--
degreesemister.php
13.44
KB
-rw-r--r--
degreewiseqpwise.php
9.96
KB
-rwxr-xr-x
digivalrpt.php
14.73
KB
-rwxr-xr-x
dispmarksreport.php
11.98
KB
-rwxr-xr-x
dispmarksreportclg.php
12.12
KB
-rwxr-xr-x
dispmarksreportdetailed.php
12.17
KB
-rwxr-xr-x
dispmarksreportdetailedclg.php
12.18
KB
-rwxr-xr-x
dispmarksreportsearch.php
11.36
KB
-rwxr-xr-x
dudCovid19Cert.php
6.19
KB
-rwxr-xr-x
duplicatePaymentReport.php
13.71
KB
-rwxr-xr-x
dygeneratebill.php
14.03
KB
-rw-rw-r--
error_data_ssp.php
22.62
KB
-rwxr-xr-x
exaEeePaidCsv.php
7.68
KB
-rwxr-xr-x
exaEeePaidCsv1.php
7.46
KB
-rwxr-xr-x
examAppFeeDetReport.php
17.82
KB
-rwxr-xr-x
examApplicationFeeSummary.php
14.11
KB
-rwxr-xr-x
examCentrDetCSV.php
6.56
KB
-rwxr-xr-x
examCntrDetQPCSV.php
5.55
KB
-rwxr-xr-x
examTimeTableDegreeWiseExcel.p...
9.67
KB
-rwxr-xr-x
examTimeTableQPWiseExcel.php
8.74
KB
-rwxr-xr-x
exam_tot_student_count_semwise...
14.31
KB
-rwxr-xr-x
examapplicationdegwise.php
8.62
KB
-rw-r--r--
exmapp_reg_rep_count.php
11.07
KB
-rwxr-xr-x
exmapp_reg_rep_count_Report.ph...
15.69
KB
-rwxr-xr-x
exmfeedetnewexcel.php
19.38
KB
-rwxr-xr-x
export.php
1.29
KB
-rwxr-xr-x
feeCollection.php
16.96
KB
-rwxr-xr-x
feeReportHeadwise.php
11.18
KB
-rwxr-xr-x
feeReportHeadwisePDF.php
10.63
KB
-rwxr-xr-x
feeReportStudwise.php
12.78
KB
-rwxr-xr-x
feeReportStudwisePDF.php
9.41
KB
-rwxr-xr-x
feepaiddet.php
7.54
KB
-rwxr-xr-x
feepaiddet_1.php
8.52
KB
-rwxr-xr-x
gen_Upload_Report.php
6.73
KB
-rw-rw-r--
genbonf_EXCEL.php
32.47
KB
-rw-rw-r--
generateCollegeWiseStudListRep...
14.12
KB
-rwxr-xr-x
generateFeeSummaryReportLink.p...
42.89
KB
-rwxr-xr-x
genrteMailSentReportXL.php
8.64
KB
-rw-rw-r--
getAbstractForm.php
14.76
KB
-rw-r--r--
getIaMarksReport.php
16.86
KB
-rw-rw-r--
getRvPcDEGSummaryList.php
13.67
KB
-rwxr-xr-x
getStudCourseReport.php
7.47
KB
-rw-r--r--
getStudDeletedReport.php
6.5
KB
-rw-rw-r--
getStudGraduandsReport.php
7.38
KB
-rw-r--r--
getStudHistoryReport.php
7.95
KB
-rw-rw-r--
getStudentRegisteredReport.php
9.1
KB
-rw-rw-r--
getnumword.php
7.45
KB
-rw-rw-r--
getrvrtpcsum.php
12.57
KB
-rwxr-xr-x
iaMarksPendingReportStudentwis...
5.45
KB
-rw-rw-r--
iamarksPendingReportSummary.ph...
6.06
KB
-rw-rw-r--
iamarkssummry_pdf.php
8.87
KB
-rw-rw-r--
logreports.php
16.41
KB
-rw-rw-r--
mainSubjectLevelList.php
11.75
KB
-rwxr-xr-x
mark_list_studwise.php
11.75
KB
-rw-rw-r--
marks_list_subwise.php
21.63
KB
-rw-rw-r--
markspushexcel.php
9.1
KB
-rw-rw-r--
mcfpendingReport.php
8.24
KB
-rwxr-xr-x
multiplePaymetReport.php
13.06
KB
-rwxr-xr-x
omrQpReport.php
30.08
KB
-rw-r--r--
omrQpReport_18092024.php
30.05
KB
-rw-rw-r--
onlineservicereport.php
6.22
KB
-rw-r--r--
orderReportExcel.php
7.35
KB
-rw-rw-r--
pendpaymentrpt.php
5.17
KB
-rw-r--r--
pgetFeedetl.php
7.01
KB
-rwxr-xr-x
pgetStatus.php
6.8
KB
-rwxr-xr-x
pgetStudentList.php
7.13
KB
-rwxr-xr-x
pget_invigilator_dairy.php
8.84
KB
-rwxr-xr-x
photoCopyPendingList.php
9.89
KB
-rwxr-xr-x
profile.php
3.58
KB
-rwxr-xr-x
qpWiseSubjectList.php
10.09
KB
-rwxr-xr-x
qpWiseSubjectList_123.php
7.38
KB
-rwxr-xr-x
qpcodewisestudentcount.php
8.59
KB
-rwxr-xr-x
qpm_absent_report.php
7.84
KB
-rw-rw-r--
qpwiseactivestudcount.php
23.39
KB
-rwxr-xr-x
qpwisestdcountcsv.php
5.57
KB
-rwxr-xr-x
qpwisestdcountcsv_old.php
5.7
KB
-rwxr-xr-x
reconReport.php
9.47
KB
-rwxr-xr-x
reconReportExcel.php
9.41
KB
-rwxr-xr-x
reconReportSummaryExcel.php
9.3
KB
-rwxr-xr-x
refundApplications.php
9.62
KB
-rwxr-xr-x
remunerationReportPdf.php
17.19
KB
-rw-rw-r--
report.html
232
B
-rw-rw-r--
report_candidate_list.php
16.09
KB
-rwxr-xr-x
report_degree_list.php
4.81
KB
-rwxr-xr-x
report_merit_list.php
10.62
KB
-rw-rw-r--
report_merit_list_old.php
10.47
KB
-rwxr-xr-x
report_merit_list_test.php
10.99
KB
-rwxr-xr-x
report_ra_invigilators_dairy.p...
15.09
KB
-rwxr-xr-x
reports.html
9.1
KB
-rwxr-xr-x
reports.js
1.87
KB
-rwxr-xr-x
revaQpindentCsv.php
7.22
KB
-rw-r--r--
revaQpindentCsv_old.php
6.89
KB
-rw-rw-r--
reva_fee_sum.php
24.12
KB
-rwxr-xr-x
roomsummary.php
10.81
KB
-rwxr-xr-x
roomsummarydetail.php
12.23
KB
-rw-r--r--
roomwise_register_nos_list.php
8.46
KB
-rwxr-xr-x
rvpcreportpdf.php
15.1
KB
-rw-rw-r--
screen1.png
70.59
KB
-rwxr-xr-x
ssp_marks_status_report.php
8.04
KB
-rwxr-xr-x
studentWiseReport.php
8.48
KB
-rw-rw-r--
studwiseCollList.php
8.81
KB
-rwxr-xr-x
studwiseCollListExl.php
10.19
KB
-rwxr-xr-x
sublistexcel.php
9.58
KB
-rw-rw-r--
sublisting.php
2.22
KB
-rw-rw-r--
tatkal.php
5.87
KB
-rw-rw-r--
tdvs_report.php
10.61
KB
-rw-r--r--
tdvs_report_board.php
5.83
KB
-rw-r--r--
tdvs_report_script.php
6.31
KB
-rw-r--r--
teachCsv.php
5
KB
-rwxr-xr-x
teachWorkDone.php
16.75
KB
-rwxr-xr-x
teach_report.php
11.21
KB
-rw-r--r--
teacher_report.php
11.56
KB
-rw-rw-r--
teacher_val_report.php
10.16
KB
-rwxr-xr-x
teachersList.php
15.11
KB
-rwxr-xr-x
testkannda.php
10.36
KB
-rwxr-xr-x
testkannda_pra.php
877
B
-rwxr-xr-x
testrep.html
17.88
KB
-rwxr-xr-x
timeTableClashReport.php
17.66
KB
-rwxr-xr-x
univAdmDeg.php
6.04
KB
-rwxr-xr-x
uploaded_qp_details.php
7.61
KB
-rw-r--r--
userTypeList.php
8.09
KB
-rwxr-xr-x
valuationSummaryReport.php
16.18
KB
-rwxr-xr-x
valuationstatsReport.php
15.67
KB
-rwxr-xr-x
valuatorExcelReport.php
8.54
KB
-rw-rw-r--
valuatorReport.php
10.27
KB
-rwxr-xr-x
verifyappRpt.php
9.4
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : getStudGraduandsReport.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'); // PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT); 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 getStudGraduandsReport($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $fcurtype = $aobj_context->mobj_data['fcurtype']; $fcollcode = $aobj_context->mobj_data['fcollcode']; $cond = ""; if($fcollcode != ''|| $fcollcode != null){ $cond = "and s.fcollcode = '{$fcollcode}'"; } $query="select c.fcollname,s.fregno, s.fdegree,d.FDESCPN, s.fcollcode, s.fname from student s, degree d,college c where s.fdegree = d.fdegree and trim(s.ftotpass) = trim(d.fleastexam) and ifnull(d.fleastexam,'') <> '' and ifnull(d.fnextexam,'') = '' and ifnull(fpdcnumber,'') <> '' and ifnull(fdcnumber,'') = '' $cond and s.fcollcode = c.fcollcode and s.fregno not in(select fregno from studhist) union select c.fcollname,s.fregno, s.fdegree,d.FDESCPN, s.fcollcode, s.fname from studhist s, degree d,college c where s.fdegree = d.fdegree and trim(s.ftotpass) = trim(d.fleastexam) and ifnull(d.fleastexam,'') <> '' and ifnull(d.fnextexam,'') = '' and s.fcollcode = c.fcollcode and ifnull(fpdcnumber,'') <> '' and ifnull(fdcnumber,'') = '' $cond"; $result = $aobj_context->pobj_db->GetAll($query); $fileName = "StudnetGraduands.xls"; $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("Uniclare") ->setLastModifiedBy("Me")->setTitle("My Excel Sheet") ->setSubject("My Excel Sheet")->setDescription("Excel Sheet") ->setKeywords("Excel Sheet")->setCategory("Me"); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); // Add column headers and make them bold $styleArray = array( 'borders' => array( 'allborders' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('argb' => '000000'), ), ), ); $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12); $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getFill()->getStartColor()->setRGB('000000'); $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getFont()->setColor(new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_WHITE)); $objPHPExcel->getActiveSheet()->getColumnDimension('A1')->setwidth(30); $objPHPExcel->getActiveSheet()->freezePane('A2'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.') ->setCellValue('B1', 'Coll. Code') ->setCellValue('C1', 'College Name') ->setCellValue('D1', 'Degree') ->setCellValue('E1', 'Degree Name') ->setCellValue('F1', 'Register No.') ->setCellValue('G1', 'Student Name'); $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->applyFromArray($styleArray); // $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->applyFromArray($styleArray); $objPHPExcel->getActiveSheet()->getColumnDimension('1')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(30); //$objPHPExcel->getActiveSheet()->getStyle('A1:AI1')->getAlignment()->setWrapText(true); $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $count=rtrim($count,", "); foreach ($result as $key => $value) { $slNo = $key + 2; $objPHPExcel->getActiveSheet()->getRowDimension($slNo)->setRowHeight(25); $objPHPExcel->getActiveSheet()->setCellValue('A' . $slNo, $slNo - 1)->getColumnDimension('A')->setwidth(8); $objPHPExcel->getActiveSheet()->setCellValue('B' . $slNo, $value['fcollcode'])->getColumnDimension('B')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('C' . $slNo, $value['fcollname'])->getColumnDimension('C')->setwidth(35); $objPHPExcel->getActiveSheet()->setCellValue('D' . $slNo,$value['fdegree'])->getColumnDimension('D')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('E' . $slNo, $value['FDESCPN'])->getColumnDimension('E')->setwidth(40); $objPHPExcel->getActiveSheet()->setCellValue('F' . $slNo, $value['fregno'])->getColumnDimension('F')->setwidth(20); $objPHPExcel->getActiveSheet()->setCellValue('G' . $slNo, $value['fname'])->getColumnDimension('G')->setwidth(40); $objPHPExcel->getActiveSheet()->getStyle('A'.$slNo.':'.'B'.$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A'.$slNo.':'.'B'.$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('D'.$slNo.':'.'D'.$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('D'.$slNo.':'.'D'.$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('F'.$slNo.':'.'F'.$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('F'.$slNo.':'.'F'.$slNo)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A'.$slNo.':'.'G'.$slNo)->applyFromArray($styleArray); } getheaders($objPHPExcel, $fileName); } ?>
Close