类下载地址:
读取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');
?>