Elep

<?php
require_once 'Classes/PHPExcel.php';

//Create a PHPExcel object
$objPHPExcel = new PHPExcel();

//Set document properties
$objPHPExcel->getProperties()	->setCreator("Rizwan")
								->setLastModifiedBy("M.Rizwan")
								->setTitle("User's Information")
								->setSubject("User's Personal Data")
								->setDescription("Description of User's")
								->setKeywords("")
								->setCategory("");

// Set default font
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial')->setSize(10);

//Set the first row as the header row
$objPHPExcel->getActiveSheet()	->setCellValue('A1', 'Booking ID')
								->setCellValue('B1', 'Booking Name')
								->setCellValue('C1', 'Tour')
								->setCellValue('D1', 'Tour_Company')
								->setCellValue('E1', 'Date')
								->setCellValue('F1', 'Day')
								->setCellValue('G1', 'Port Sched')
								->setCellValue('H1', 'Ship')
								->setCellValue('I1', 'Departure_Time')
								->setCellValue('J1', 'Arrival_Time')
								->setCellValue('K1', 'ADULT')
								->setCellValue('L1', 'Child');
							  
//Rename the worksheet
$objPHPExcel->getActiveSheet()->setTitle('USER INFO');

//Set active worksheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
//-------------------------------------------------------------------------------------------
$count=1;

for($n=0;$n<count($data_d["up_ids"]);$n++)
{

$booking_id  = $data_d["up_ids"][$n];
	$BookingName = $data_d["Booking Name"][$n];
	$Date        = $data_d["Date"][$n];
	$Dep_Time 	 = $data_d["Departure Time"][$n];
	$Arr_Time 	 = $data_d["Arrival Time"][$n];
	$Child       = $data_d["CHILD"][$n];
	$ADULT       = $data_d["ADULT"][$n];
	$Day       	 = $data_d["Day"][$n];
	$Tour        = $data_d["Tour"][$n];
	$TourCompany = $data_d["Tour Company"][$n];
	$VocherNo    = $data_d["VOUCHER No"][$n];
	$Ship        = $data_d["Ship"][$n];
	$portSched   = $data_d["PORT SCHED"][$n];
	
    if(empty($Date) || $Date == "null")
	{
        $Date = " ";
    }
    if(empty($Dep_Time) || $Dep_Time == "null")
	{
        $Dep_Time = " ";
    }
    if(empty($Arr_Time) || $Arr_Time == "null")
	{
        $Arr_Time = " ";
    }
	if(empty($Child) || $Child == "null")
	{
        $Child = " ";
    }
    if(empty($ADULT) || $ADULT == "null")
	{
        $ADULT = " ";
    }
    if(empty($Day) || $Day == "null")
	{
        $ADULT = " ";
    }
    if(empty($Tour) || $Tour == "null")
	{
        $Tour = " ";
    }
    if(empty($TourCompany) || $TourCompany == "null")
	{
        $TourCompany = " ";
    }
    if(empty($VocherNo) || $VocherNo == "null")
	{
        $VocherNo = " ";
    }
    if(empty($Ship) || $Ship == "null")
	{
        $Ship = " ";
    }
    if(empty($portSched) || $portSched == "null")
	{
        $portSched = " ";
    }
    
	$objPHPExcel->getActiveSheet()  ->setCellValue('A'.($count+1), "ID_".$booking_id)
									->setCellValue('B'.($count+1), $BookingName)
									->setCellValue('C'.($count+1), $Tour)
									->setCellValue('D'.($count+1), $TourCompany)
									->setCellValue('E'.($count+1), $Date)
									->setCellValue('F'.($count+1), $Day)
									->setCellValue('G'.($count+1), $portSched)
									->setCellValue('H'.($count+1), $Ship)
//									->setCellValue('I'.($count+1), $Departure_Time)
									->setCellValue('I'.($count+1), $Dep_Time)
//									->setCellValue('J'.($count+1), $Arrival_Time)
									->setCellValue('J'.($count+1), $Arr_Time)
									->setCellValue('K'.($count+1), $ADULT)
									->setCellValue('L'.($count+1), $Child);	
	$count++;
}

$filename = $subj.".xlsx";
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save($filename);
//exit;