<?php
require_once 'PHPExcel.php';
require_once 'PHPExcel/IOFactory.php';
require_once 'PHPExcel/Reader/Excel5.php';
/* 以上三步加载phpExcel的类
下载地址:https://github.com/PHPOffice/PHPExcel/tree/1.8/Classes */
$filename='F:\PhpStudy\PHPTutorial\WWW\exc\test.xlsx';//指定excel文件
$file = iconv("utf-8","gb2312",$filename); //转码
if(empty($file) OR !file_exists($file)) {
die('file not exists!');
}
$extension = strtolower( pathinfo($filename, PATHINFO_EXTENSION) );
if ($extension =='xlsx') {
$objReader = PHPExcel_IOFactory::createReader('excel2007');
$objReader->setReadDataOnly(true);
$objReader->setLoadSheetsOnly(true);
$objExcel = $objReader ->load($filename);
} elseif ($extension =='xls') {
$objReader = PHPExcel_IOFactory::createReader('excel5');
$objReader->setReadDataOnly(true);
$objReader->setLoadSheetsOnly(true);
$objExcel = $objReader ->load($filename);
}
$sheet = $objExcel->getSheet(0)->toArray();
print_r($sheet);
PHP读取Excel文档
发表评论？
//长日序转标准日期格式
date(‘Y-m-d’,PHPExcel_Shared_Date::ExcelToPHP($sheet[$key][1]));
//拼sql插入数据库中
$sql = “INSERT INTO fa_students VALUES (‘”;
foreach($sheet as $key=>$val){
if(is_numeric($val[1])){
$val[1] = date(‘Y-m-d’,PHPExcel_Shared_Date::ExcelToPHP($sheet[$key][1]));
}
foreach($val as $k=>$v){
$sql .= $k==count($val)-1?$v.”‘)”:$v.”‘,'”;
}
$sql .= $key==count($sheet)-1?””:”,(‘”;
}
print_r($sql);
$dbh = new PDO(‘mysql:host=localhost;dbname=fastadmin’,’root’,’123456′);
$r = $dbh->query($sql);
$dbh = null;
print_r($r);
exit;