先到PHPExcel官网下载程序
https://github.com/PHPOffice/PHPExcel
Classes目录下的内容放到程序目录并引入
Examples下是一些简单例子
下面是一个简单的读取内容程序,读起来很方便
require_once 'PHPExcel.php';
$filePath = 'test.xlsx';
$PHPExcel = new PHPExcel();
//默认用excel2007读取,否则将用旧版
$PHPReader = new PHPExcel_Reader_Excel2007();
if(!$PHPReader->canRead($filePath)){
$PHPReader = new PHPExcel_Reader_Excel5();
if(!$PHPReader->canRead($filePath)){
echo 'no Excel';
return ;
}
}
$PHPExcel = $PHPReader->load($filePath);
//默认读取第一个工作表
$currentSheet = $PHPExcel->getSheet(0);
//取得列数
$allColumn = $currentSheet->getHighestColumn();
//取得行数
$allRow = $currentSheet->getHighestRow();
//从第1行开始读取
for($currentRow = 1;$currentRow <= $allRow;$currentRow++){
//从第A列开始读取
for($currentColumn= 'A';$currentColumn<= $allColumn; $currentColumn++){
$val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue();
echo $val;
//echo iconv('utf-8','gb2312', $val);
}
echo "
";
}