yêu cầu("//www.zzvips.com/PHPExcel/Classes/PHPExcel.php"); 
$file = "D:\\datas.xlsx"; 
nếu(!file_exists($file)){ 
die("không tìm thấy tập tin nào trong {$file}"); 
} 
$datasReader = PHPExcel_IOFactory::load($file); 
$sheets = $datasReader->getAllSheets(); 
//Nếu có nhiều sổ làm việc 
$countSheets = đếm($sheets); 
$sheetsinfo = mảng(); 
$sheetData = mảng(); 
nếu($countSheets==1){ 
$sheet = $sheets[0]; 
$sheetsinfo["hàng"] = $sheet->getHighestRow(); 
$sheetsinfo["column"] = PHPExcel_Cell::columnIndexFromString($sheet->getHighestColumn()); 
đối với ($row=1;$row<=$sheetsinfo["hàng"];$row++){ 
đối với ($column=0;$column<$sheetsinfo["column"];$column++){ 
$sheetData[$column][$row] = $sheet->getCellByColumnAndRow($column, $row)->getValue(); 
} 
} 
}khác{ 
foreach ($sheets như $key => $sheet) 
{ 
$sheetsinfo[$key]["rows"] = $sheet->getHighestRow(); 
$sheetsinfo[$key]["column"] = PHPExcel_Cell::columnIndexFromString($sheet->getHighestColumn()); 
đối với($row=1;$row<=$sheetsinfo[$key]["rows"];$row++){ 
đối với ($column=0;$column<$sheetsinfo[$key]["column"];$column++){ 
$sheetData[$key][$column][$row] = $sheet->getCellByColumnAndRow($column, $row)->getValue(); 
} 
} 
} 
} 
echo ""; 
in_r($sheetData); 
tiếng vang ""; 

$sql = sprintf("chọn * từ bảng nơi op_id=%d", intval($this->params['id'])); 
$query = $this->_db->query($sql); 
yêu cầu_một_lần './PHPExcel_1.7.4/Classes/PHPExcel.php'; 
$objPHPExcel = PHPExcel mới(); 
$objPHPExcel->setActiveSheetIndex(0); 
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10); 
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15); 
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15); 
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); 
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15); 
$objPHPExcel->getActiveSheet()->setCellValue('A1', "{$this->_packInfos['o_id']}"); 
$objPHPExcel->getActiveSheet()->setCellValue('B1', "Trọng lượng thể tích (kg)"); 
$objPHPExcel->getActiveSheet()->setCellValue('D1', "Trọng lượng thực tế (kg)"); 


$objPHPExcel->getActiveSheet()->setCellValue('A2', "Hộp số."); 
$objPHPExcel->getActiveSheet()->setCellValue('B2', "Sản phẩm"); 
$objPHPExcel->getActiveSheet()->setCellValue('C2', "Hộp vận chuyển"); 
$objPHPExcel->getActiveSheet()->setCellValue('D2', "Hệ thống"); 
$objPHPExcel->getActiveSheet()->setCellValue('E2', "Đầu vào"); 
$objActSheet = $objPHPExcel->getActiveSheet(); 
$objActSheet->mergeCells("B1:C1"); 
$objActSheet->mergeCells("D1:E1"); 

$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); 
$objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); 
$objPHPExcel->getActiveSheet()->getStyle('D1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); 

$objPHPExcel->getActiveSheet()->getStyle('A2'.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); 
$objPHPExcel->getActiveSheet()->getStyle('B2'.($i))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); 
$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); 

nếu($this->_db->num_rows($query)>0) 
{ 
$i=3; 
trong khi ($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/".$têntệp; 
$objWriter = PHPExcel_Writer_Excel2007 mới($objPHPExcel); 
nếu(tệp_tồn_tại($đường_dẫn)){ 
chmod($đường dẫn, 0777); 
hủy liên kết($path); 
$objWriter->save($đường dẫn); 
header('ứng dụng/vnd.ms-excel'); 
header('Bố trí nội dung: tệp đính kèm; tên tệp = trọng lượng-'.$this->_packInfos["o_id"].xlsx"); 
đọc tệp ($đường dẫn tệp); 
cái(); 
} 
khác 
{ 
$objWriter->save($đường dẫn); 
header('ứng dụng/vnd.ms-excel'); 
header('Bố trí nội dung: tệp đính kèm; tên tệp = trọng lượng-'.$this->_packInfos["o_id"].xlsx"); 
đọc tệp ($đường dẫn tệp); 
cái(); 
}