phpexcel

类下载地址：

http://www.codeplex.com/PHPExcel


读取excel第一张表并打印内容


<?php
set_include_path(get_include_path() . PATH_SEPARATOR . '../Classes/');
include 'PHPExcel.php';
include 'PHPExcel/IOFactory.php';
$objPHPExcel = new PHPExcel();
$PHPReader = PHPExcel_IOFactory::createReader('Excel5');　// 非2007excel; 2007:Excel2007
$PHPReader->setReadDataOnly(true);
$PHPExcel = $PHPReader->load('../aaa.xls');
echo '<xmp>';
$arr = $PHPExcel->getSheet(0)-> toArray();
foreach($arr as $val){
foreach($val as $v){
   echo $v.'\t';
}
echo '\n'; 
}
echo '</xmp>';


// 输出


<?php
set_include_path(get_include_path() . PATH_SEPARATOR . '../Classes/');
include 'PHPExcel.php';
include 'PHPExcel/IOFactory.php';
$objPHPExcel->setActiveSheetIndex(0);
$cols = 1;
foreach($arr as $val){
$au = $st = 65;
$en = 90;
$mo = 0;
foreach($val as $v){
   if($mo>0){
    $grid = chr($st+($mo-1)).chr($au).$cols;
   }else{
    $grid = chr($au).$cols;
   }
   $au++;
   if($au > $en){
    $mo++;
    $au = $st;
   }
   $objPHPExcel->getActiveSheet()->setCellValue($grid, $v);
}
$cols++;
}
$outputFileName = str_replace('.php', '.xls', __FILE__); 
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
//到文件   
//$objWriter->save($outputFileName);   
//or   
//到浏览器 
header('Pragma: public');
header('Expires: 0');
header('Cache-Control:must-revalidate, post-check=0, pre-check=0');
header('Content-Type:application/force-download');
header('Content-Type:application/vnd.ms-execl');
header('Content-Type:application/octet-stream');
header('Content-Type:application/download');
header('Content-Disposition: attachment; filename='.$outputFileName.'');
header('Content-Type: application/vnd.ms-excel; name="'.$outputFileName.'"');
header("Content-Transfer-Encoding: binary"); 
$objWriter->save('php://output');


?>