$objPHPExcel

->getActiveSheet()->getStyle('C2'.(

$i

))->getAlignment()-

>setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); 

$objPHPExcel

->getActiveSheet()->getStyle('D2'.(

$i

))->getAlignment()-

>setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); 

$objPHPExcel

->getActiveSheet()->getStyle('E2'.(

$i

))->getAlignment()-

>setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); 
 

if

(

$this

->_db->num_rows(

$query

)>0) 

{ 

$i

=3; 

while

 (

$row

 = 

$this

->_db->fetch_assoc(

$query

)) 

{ 

$objPHPExcel

->getActiveSheet()->setCellValue('A'.(

$i

),"BOX ".

$row

['box_num']); 

$objPHPExcel

->getActiveSheet()->setCellValue('B'.(

$i

),sprintf("%.2f",

$row

['volume_weight'])); 

$objPHPExcel

->getActiveSheet()->setCellValue('C'.(

$i

),sprintf("%.2f",

$row

['box_weight'])); 

$objPHPExcel

->getActiveSheet()->setCellValue('D'.(

$i

),sprintf("%.2f",

$row

['system_weight'])); 

$objPHPExcel

->getActiveSheet()->setCellValue('E'.(

$i

),sprintf("%.2f",

$row

['real_weight'])); 

 

$objPHPExcel

->getActiveSheet()->getStyle('A'.(

$i

))->getAlignment()-

>setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); 

$objPHPExcel

->getActiveSheet()->getStyle('B'.(

$i

))->getAlignment()-

>setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); 

$objPHPExcel

->getActiveSheet()->getStyle('C'.(

$i

))->getAlignment()-

>setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); 

$objPHPExcel

->getActiveSheet()->getStyle('D'.(

$i

))->getAlignment()-

>setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); 

$objPHPExcel

->getActiveSheet()->getStyle('E'.(

$i

))->getAlignment()-

>setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT); 

$i

++; 

} 
} 
 

$fileName

="exportBox.xls"; 

$filePath

 = dirname(dirname("__FILE__"))."/template/".

$fileName

; 

$path

 = "./template/".

$fileName

; 

$objWriter

 = 

new

 PHPExcel_Writer_Excel2007(

$objPHPExcel

); 

if

(

file_exists

(

$path

)){ 

chmod

(

$path

, 0777); 

unlink(

$path

); 

$objWriter

->save(

$path

); 

header('application/vnd.ms-excel'); 
header('Content-Disposition: attachment;filename=weight-'.

$this

->_packInfos["o_id"].".xlsx"); 

readfile(

$filePath

); 

die

();