print_r(

$sheetData

); 

echo

 "</pre>"; 

 
注：使用 PHP 读取 excel 文件内容，一般都是处理整理好格式的 csv 或者 excel，也可以读
取 xml

 

文件

 
PHPExcel 生成 Exceel 

 

复制代码 代码如下:
 

$sql

 = sprintf("select * from table where op_id=%d", 

intval

(

$this

->params['id'])); 

$query

 = 

$this

->_db->query(

$sql

); 

require_once

 './PHPExcel_1.7.4/Classes/PHPExcel.php'; 

$objPHPExcel

 = 

new

 PHPExcel(); 

$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', "Volume weight (kg)"); 

$objPHPExcel

->getActiveSheet()->setCellValue('D1', "Actual weight (kg)"); 

 
 

$objPHPExcel

->getActiveSheet()->setCellValue('A2', "Box No."); 

$objPHPExcel

->getActiveSheet()->setCellValue('B2', "Products"); 

$objPHPExcel

->getActiveSheet()->setCellValue('C2', "Shipping Box"); 

$objPHPExcel

->getActiveSheet()->setCellValue('D2', "System"); 

$objPHPExcel

->getActiveSheet()->setCellValue('E2', "Input"); 

$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);