include/functionspdo.php -->  File name / section
/************************************* Compliance Status *************************************/
function complianceStatus($complianceId){
    $dbh = connect_db();
    $company_id = $_SESSION['company_id'];
    $role = $_SESSION['user_role'];
	$usrid = get_user_by_id( $_SESSION['user_id'])['email'];
    try{
        if($role == 'Fpr'){
		    $query = $dbh->prepare("SELECT * FROM `company_compliance` INNER JOIN `compliance` ON `compliance`.`id`=`company_compliance`.`compliance_id` WHERE `company_compliance`.`compliance_id`='$complianceId' AND `company_compliance`.`fpr_id` = '$usrid' AND `company_compliance`.`company_id`='$company_id' AND (`company_compliance`.`status`=1  OR `company_compliance`.`status`=4 OR (compliance.periodicity='one time' and (company_compliance.status=9 or company_compliance.status=7 or company_compliance.status=4))) ");
	    }elseif($role == 'Approver'){
			$query = $dbh->prepare("SELECT * FROM `company_compliance` INNER JOIN `compliance` ON `compliance`.`id`=`company_compliance`.`compliance_id` WHERE `company_compliance`.`compliance_id`='$complianceId' AND `company_compliance`.`appr_id` = '$usrid' AND `company_compliance`.`company_id`='$company_id' AND (`company_compliance`.`status`=1  OR `company_compliance`.`status`=4 OR (compliance.periodicity='one time' and (company_compliance.status=9 or company_compliance.status=7 or company_compliance.status=4))) ");
		}elseif($role == 'Hod'){
			$query = $dbh->prepare("SELECT * FROM `company_compliance` INNER JOIN `compliance` ON `compliance`.`id`=`company_compliance`.`compliance_id` WHERE `company_compliance`.`compliance_id`='$complianceId' AND `company_compliance`.`hod_id` = '$usrid' AND `company_compliance`.`company_id`='$company_id' AND (`company_compliance`.`status`=1  OR `company_compliance`.`status`=4 OR (compliance.periodicity='one time' and (company_compliance.status=9 or company_compliance.status=7 or company_compliance.status=4))) ");
		}else{
			$query = $dbh->prepare("SELECT * FROM `company_compliance` INNER JOIN `compliance` ON `compliance`.`id`=`company_compliance`.`compliance_id` WHERE `company_compliance`.`compliance_id`='$complianceId' AND `company_compliance`.`company_id`='$company_id' AND (`company_compliance`.`status`=1  OR `company_compliance`.`status`=4 OR (compliance.periodicity='one time' and (company_compliance.status=9 or company_compliance.status=7 or company_compliance.status=4))) ");
		}
        $query->execute();
        $result = $query->fetchAll();
        return $result;
    } catch(PDOException $e){
        return $e->getMessage();
    }
}

function getComplianceDetails($compid){
        $company_id = $_SESSION['company_id'];
        $role = $_SESSION['user_role'];
	    $usrid = get_user_by_id( $_SESSION['user_id'])['email'];
        $dbh = connect_db();
        try{
            if($role == 'Fpr'){
    		    $query = $dbh->prepare("SELECT `company_compliance`.`fpr_id`, `company_compliance`.`appr_id`, `company_compliance`.`hod_id`, `company_compliance`.`location`, `company_compliance`.`department`,  `company_compliance`.`live_date`, `company_compliance`.`auditor_status` FROM `company_compliance` INNER JOIN `compliance` ON `compliance`.`id`=`company_compliance`.`compliance_id` WHERE `company_compliance`.`compliance_id`='$compid' AND `company_compliance`.`fpr_id` = '$usrid' AND `company_compliance`.`company_id`='$company_id' AND (`company_compliance`.`status`=1  OR `company_compliance`.`status`=4 OR (compliance.periodicity='one time' and (company_compliance.status=9 or company_compliance.status=7 or company_compliance.status=4))) GROUP BY `company_compliance`.`fpr_id`, `company_compliance`.`appr_id`, `company_compliance`.`hod_id`, `company_compliance`.`location`, `company_compliance`.`department`");
    	    }elseif($role == 'Approver'){
    			$query = $dbh->prepare("SELECT `company_compliance`.`fpr_id`, `company_compliance`.`appr_id`, `company_compliance`.`hod_id`, `company_compliance`.`location`, `company_compliance`.`department`,  `company_compliance`.`live_date`, `company_compliance`.`auditor_status` FROM `company_compliance` INNER JOIN `compliance` ON `compliance`.`id`=`company_compliance`.`compliance_id` WHERE `company_compliance`.`compliance_id`='$compid' AND `company_compliance`.`appr_id` = '$usrid' AND `company_compliance`.`company_id`='$company_id' AND (`company_compliance`.`status`=1  OR `company_compliance`.`status`=4 OR (compliance.periodicity='one time' and (company_compliance.status=9 or company_compliance.status=7 or company_compliance.status=4))) GROUP BY `company_compliance`.`fpr_id`, `company_compliance`.`appr_id`, `company_compliance`.`hod_id`, `company_compliance`.`location`, `company_compliance`.`department` ");
    		}elseif($role == 'Hod'){
    			$query = $dbh->prepare("SELECT `company_compliance`.`fpr_id`, `company_compliance`.`appr_id`, `company_compliance`.`hod_id`, `company_compliance`.`location`, `company_compliance`.`department`,  `company_compliance`.`live_date`, `company_compliance`.`auditor_status` FROM `company_compliance` INNER JOIN `compliance` ON `compliance`.`id`=`company_compliance`.`compliance_id` WHERE `company_compliance`.`compliance_id`='$compid' AND `company_compliance`.`hod_id` = '$usrid' AND `company_compliance`.`company_id`='$company_id' AND (`company_compliance`.`status`=1  OR `company_compliance`.`status`=4 OR (compliance.periodicity='one time' and (company_compliance.status=9 or company_compliance.status=7 or company_compliance.status=4))) GROUP BY `company_compliance`.`fpr_id`, `company_compliance`.`appr_id`, `company_compliance`.`hod_id`, `company_compliance`.`location`, `company_compliance`.`department`");
    		}else{
    			$query = $dbh->prepare("SELECT `company_compliance`.`fpr_id`, `company_compliance`.`appr_id`, `company_compliance`.`hod_id`, `company_compliance`.`location`, `company_compliance`.`department`,  `company_compliance`.`live_date`, `company_compliance`.`auditor_status` FROM `company_compliance` INNER JOIN `compliance` ON `compliance`.`id`=`company_compliance`.`compliance_id` WHERE `company_compliance`.`compliance_id`='$compid' AND `company_compliance`.`company_id`='$company_id' AND (`company_compliance`.`status`=1  OR `company_compliance`.`status`=4 OR (compliance.periodicity='one time' and (company_compliance.status=9 or company_compliance.status=7 or company_compliance.status=4))) GROUP BY `company_compliance`.`fpr_id`, `company_compliance`.`appr_id`, `company_compliance`.`hod_id`, `company_compliance`.`location`, `company_compliance`.`department`");
    		}
            $query->execute();
            $result = $query->fetchAll();
            return $result;
        } catch (PDOException $e){
            return $e->getMessage();
        }
    }

/************************************* Compliance Status *************************************/



popupshow.php?comp_of_act_id   -> File name / section

<th>Status</th> --> add column as last column
 
add function in foreach Loop : -
 
$complianceidx = complianceStatus($compliance['id']);
 
column data :-

<?php
if(!is_bool($complianceidx) && count($complianceidx)>=1){
?>
    <td><a><span onclick="loadpopup2('popupshow.php?status_compliance_id=<?php echo $compliance['id'];?>&popup=3')" data-toggle="modal" data-target="#modalpopup2" style="color:green;">Active</span></a></td>
<?php
} else {
?>
    <td><span style="color:red;">Inactive</span></td>
<?php
}
?>


Add a section to export: - <div class="modal-body" id="popupbody<?=$popupno;?>" tabindex="-1"> ----> Below it

<form target="_blank" method="post" action="export_excel_compliance_status.php">
                    <input type="text" value="<?php foreach($compliances as $rs1){ 
                        $cid = $rs1['id'];
                        echo ','.$cid; 
                        }
                    ?>" id="sr" name="sr" hidden>
                    <input type="submit" value="Export To Excel" class="btn btn-success" formtarget="_blank"/>
                </form>



/************************************* Section Ended *************************************/

Add a new section in popshow.php -->  File name / section

add this above last else block(just above catch block)


else if($_GET['status_compliance_id']){
    error_reporting(0);
    $compid = $_GET['status_compliance_id'];
    
    ?>
    <div class="modal-dialog modal-lg text-default" style="width:95%;">
        <div class="modal-content" id="popupcontent<?=$popupno;?>">
            <div class="modal-body" id="popupbody<?=$popupno;?>">
				<div class="tile-body" tabindex="-1">
                    <div class="panel-group"  role="tablist" aria-multiselectable="true">
                        <div class="panel panel-default">
                            <div class="panel-heading bg-greensea" role="tab" id="headingfive">
                                <h4 class="panel-title">
                                    <a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapseFive<?=$popupno;?>" aria-expanded="false" aria-controls="collapseFive<?=$popupno;?>">
                                        Compliance Details
                                    </a>
                                </h4>
                            </div>
                            <div role="tabpanel" aria-labelledby="f">
                                <div class="panel-body">
                                    <input type="button" class="btn btn-success" onclick="tableToExcelDetails('editable-usage-details')" value="Export to Excel">
                                    <?php  
                                    $val = getComplianceDetails($compid);
									?>
									<div id="doublescroll">
										<table class="table-responsive p-0 m-0 full-width text-sm table-striped text-default bg-white" id="editable-usage-details" style="width:100%">
    										<thead>
        										<tr class="bg-cyan text-md center-text">
        										<th>Sr. No.</th>
        										<th>Location</th>
        										<th>Department</th> 
        										<th>FPR</th>
        										<th>Approver</th>
        										<th>HoD</th>
        										<th>Live Date</th>
        										</tr>
    										</thead>
										<tbody>
										<?php 
										$srno = 1;
										foreach($val as $i){ ?>
										<tr>
										    <td><?php echo $srno; ?></td>
										<td><?=cleandb($i['location']);?></td>
										<td><?=cleandb($i['department']);?></td>
										<td><?=cleandb($i['fpr_id']);?></td>
										<td><?=cleandb($i['appr_id']);?></td>
										<td><?=cleandb($i['hod_id']);?></td>
										<td><?php
										
										$ddn= date('d-M-Y', strtotime($i['live_date']));
										if($ddn=="01-Jan-1970")
										{
											echo "";
										}
										
										else
										{
										echo $ddn;
										}
										?>
										</td>
										
										</tr>
										<?php
										$srno++;
										}
										?>
									</tbody>
								</table>
							</div>
						</div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="modal-footer">
        <button class="btn btn-danger" data-dismiss="modal">Close</button>
    </div>
	</div>
</div>
<?php
}



/************************************* Section Ended *************************************/

add function to script.js -->  File name / section
var tableToExcelDetails = (function() {
    var today = new Date();
    var date = today.getFullYear()+'-'+(today.getMonth()+1)+'-'+today.getDate();
    var time = today.getHours() + "-" + today.getMinutes() + "-" + today.getSeconds();
    var dateTime = date+'_'+time;
    var filename = 'Lexcomply-Compliance-Details'+dateTime;
  var uri = 'data:application/vnd.ms-excel;base64,'
    , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="https://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'
    , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
    , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
  return function(table, name) {
    if (!table.nodeType) table = document.getElementById(table)
    var ctx = {worksheet: name || 'Lexcomply-report<?=date("Y-m-d_H:i:s");?>', table: table.innerHTML}
    // window.location.href = uri + base64(format(template, ctx))
    var a = document.createElement('a');
    a.href = uri + base64(format(template, ctx))
    a.download = filename + '.xls';
    //triggering the function
    a.click();
  }
})()

/************************************* Section Ended *************************************/

new-compliance-add-filter.php -->  File name / section

<th>Status</th> --> add column before view column
 
add function in foreach Loop : -
 
$complianceid = complianceStatus($stw['id']);
 
column data :-
<?php
if(!is_bool($complianceid) && count($complianceid)>=1){
?>
    <td><a><span onclick="loadpopup2('popupshow.php?status_compliance_id=<?php echo $compliance['id'];?>&popup=3')" data-toggle="modal" data-target="#modalpopup2" style="color:green;">Active</span></a></td>
<?php
} else {
?>
    <td><span style="color:red;">Inactive</span></td>
<?php
}
?>

Change export File : -

export_excel_new_compliance_status.php

/************************************* Section Ended *************************************/

new-compliance-add.php -->  File name / section

<th>Status</th> --> add column
 
add function in foreach Loop : -
 
$complianceid = complianceStatus($stw['id']);
 
column data :-

<?php
if(!is_bool($complianceid) && count($complianceid)>=1){
?>
    <td><a><span onclick="loadpopup2('popupshow.php?status_compliance_id=<?php echo $compliance['id'];?>&popup=3')" data-toggle="modal" data-target="#modalpopup2" style="color:green;">Active</span></a></td>
<?php
} else {
?>
    <td><span style="color:red;">Inactive</span></td>
<?php
}
?>

Change export File : - hint(search by <form target="_blank" method="post" action="export_excel_new_compliance_status.php">)

export_excel_new_compliance_status.php


/************************************* Section Ended *************************************/

export_excel_new_compliance_status.php --> Create New File

<?php 
require 'include/header.php';
require_once 'rsjadmin/Classes/PHPExcel.php';
$company_id=$_SESSION['company_id'];
error_reporting(0);
$usrid = get_user_by_id( $_SESSION['user_id'])['email'];
$sr =  $_POST['sr'];
$qt = explode(",",$sr);
$full_count =  count($qt)-1;
$src = '';
function convertString ($date) 
  { 
      $sec = strtotime($date); 
      $date = date("Y-m-d", $sec); 
      return $date; 
  }
if($full_count == 1 )
{
	for($i=1;$i<=$full_count;$i++)
		{
			$src .= '( compliance.`id` = '.$qt[$i].' )';
		}
}else 
{
for($i=1;$i<=$full_count;$i++)
{
	if($i == 1){
		$src .= '( compliance.`id` = '.$qt[$i];
	}elseif($i == $full_count){
			$src .= " or compliance.`id` = ".$qt[$i]." ) ";	
	}else
	{
		$src .= ' or compliance.`id` = '.$qt[$i];
	}	
}
}


	$dbh = connect_db();
	$query = $dbh->prepare( "select compliance.due_date,compliance.timestampp,compliance.id as idd, compliance.sub_head, compliance.description,compliance.periodicity, compliance.criticality, compliance.legal_date,act.name as actname, act.date as actdate,act.id as actid,act_fields.country as country from compliance inner join act on act.id=compliance.act_id inner join company_act on company_act.act_id = compliance.act_id inner join act_fields on act_fields.act_id = compliance.act_id where $src group by compliance.id" );
    $query->execute();
	$result = $query->fetchAll();
	
	
$objPHPExcel = new PHPExcel();
$styleArray = array(
'fill' => array(
            'type' => PHPExcel_Style_Fill::FILL_SOLID,
            'color' => array('rgb' => '7030A0')
        ),
		'borders' => array(
    'allborders'    => array('style' => PHPExcel_Style_Border::BORDER_THIN)
    ),
    'font'  => array(
        'bold'  => true,
        'color' => array('rgb' => 'FFFFFF'),
        'size'  => 11,
        //'name'  => 'Verdana'
    ));
	
$styleArray1 = array(
		'borders' => array(
    'allborders'    => array('style' => PHPExcel_Style_Border::BORDER_THIN)
    ));
	
$objPHPExcel->setActiveSheetIndex(0); 
$rowCount1 = 1;  
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(40);
$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount1, 'Country');
$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount1, 'Act ID');
$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount1, 'Act Name');
$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount1, 'Compliance ID');
$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount1, 'Compliance Type');
$objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount1, 'Compliance description');
$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount1, 'Periodicity');
$objPHPExcel->getActiveSheet()->SetCellValue('H'.$rowCount1, 'Criticality');
$objPHPExcel->getActiveSheet()->SetCellValue('I'.$rowCount1, 'Legal Date');
$objPHPExcel->getActiveSheet()->SetCellValue('J'.$rowCount1, 'Remarks on Applicability');
$objPHPExcel->getActiveSheet()->SetCellValue('K'.$rowCount1, 'Department');
$objPHPExcel->getActiveSheet()->SetCellValue('L'.$rowCount1, 'Email id of FPR');
$objPHPExcel->getActiveSheet()->SetCellValue('M'.$rowCount1, 'Email id of Approver');
$objPHPExcel->getActiveSheet()->SetCellValue('N'.$rowCount1, 'Email id of HOD');
$objPHPExcel->getActiveSheet()->SetCellValue('O'.$rowCount1, 'Status');

$rowCount = 2; 
foreach($result as $rs )
	{
	    $complianceid = complianceStatus($rs['idd']);
	    if(!is_bool($complianceid) && count($complianceid)>=1){
			$actstatus = "Active";
		} else {
			$actstatus = "Inactive";
		}
		$legal_date = convertString ($rs['legal_date']);
		$objPHPExcel->getActiveSheet()->getStyle('A'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $rs['country']);
		$objPHPExcel->getActiveSheet()->getStyle('B'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $rs['actid']);
		$objPHPExcel->getActiveSheet()->getStyle('C'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->getStyle('C'.$rowCount)->getAlignment()->setWrapText(true);
		$objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, $rs['actname']);
		$objPHPExcel->getActiveSheet()->getStyle('D'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, $rs['idd']);
		$objPHPExcel->getActiveSheet()->getStyle('E'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->getStyle('E'.$rowCount)->getAlignment()->setWrapText(true);
		$objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $rs['sub_head']);
		$objPHPExcel->getActiveSheet()->getStyle('F'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->getStyle('F'.$rowCount)->getAlignment()->setWrapText(true);
		$objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, $rs['description']);
		$objPHPExcel->getActiveSheet()->getStyle('G'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount, $rs['periodicity']);
		$objPHPExcel->getActiveSheet()->getStyle('H'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->SetCellValue('H'.$rowCount, $rs['criticality']);
		$objPHPExcel->getActiveSheet()->getStyle('I'.$rowCount)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_TOP);
		$objPHPExcel->getActiveSheet()->SetCellValue('I'.$rowCount, $legal_date);
		$objPHPExcel->getActiveSheet()->SetCellValue('J'.$rowCount, '');
		$objPHPExcel->getActiveSheet()->SetCellValue('K'.$rowCount, '');
		$objPHPExcel->getActiveSheet()->SetCellValue('L'.$rowCount, '');
		$objPHPExcel->getActiveSheet()->SetCellValue('M'.$rowCount, '');
		$objPHPExcel->getActiveSheet()->SetCellValue('N'.$rowCount, '');
		$objPHPExcel->getActiveSheet()->SetCellValue('O'.$rowCount, $actstatus);
		
		$objPHPExcel->getActiveSheet()->getStyle('A'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('B'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('C'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('D'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('E'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('F'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('G'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('H'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('I'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('J'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('K'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('L'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('M'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('N'.$rowCount)->applyFromArray($styleArray1);
		$objPHPExcel->getActiveSheet()->getStyle('O'.$rowCount)->applyFromArray($styleArray1);
		
		
		$rowCount++; 
	}
$date = date('Y_m_d_i_s');
header('Content-Type: application/vnd.ms-excel'); 
header('Content-Disposition: attachment;filename="New_compliance_'.$date.'.xls"'); 
header('Cache-Control: max-age=0');
$objPHPExcel->getActiveSheet()->getStyle("A1:O1")->getFont()->setBold(true); 
$objPHPExcel->getActiveSheet()->getStyle('A1:O1')->applyFromArray($styleArray);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20); 
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(20);
$objPHPExcel->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');   
$objWriter->save('php://output');
echo "<script>window.close();</script>";	
	
?>



/************************************* Section Ended *************************************/