include('conn.php');
require_once 'PHPExcel.php';
require_once 'PHPExcel/IOFactory.php';
$reader = PHPExcel_IOFactory::createReader('Excel5');
//$reader = PHPExcel_IOFactory::createReader('Excel2007'); // 查\Classes\PHPExcel\Reader
//$resource = 'upload/201405-cda.xlsx';
$resource = 'upload/201405-cda.xls';
if (!file_exists($resource)) {
  exit("$resource is not exists.\n");
}

$PHPExcel = $reader->load($resource); // 文件名称
$sheet = $PHPExcel->getSheet(0); // 读取第一个工作表从0读起
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数，不过是最大列的字母
$highestColumn = PHPExcel_Cell::columnIndexFromString($highestColumn); // 转换字母为对应的统计数字；
// getCellByColumnAndRow(0,1)，第一列为0，第一行为1；
echo $highestRow . "、" . $highestColumn . "、" . $sheet->getCellByColumnAndRow(0, 1)->getCalculatedValue() . "（数量统计结束，换行）<br />";
// 每次读取一行，再在行中循环每列的数值
$excelArray = array();
for ($row = 1; $row <= $highestRow; $row++) {
    $val = $sheet->getCellByColumnAndRow(0, $row)->getCalculatedValue();
    if ($val == "") return;

    for ($column = 0; $column < $highestColumn; $column++) {
        
        $isDate = 0;
        $isDate = PHPExcel_Shared_Date::isDateTime($sheet->getCellByColumnAndRow($column, $row));
        if ($isDate > 0)
        {
            $val = PHPExcel_Shared_Date::ExcelToPHPObject($sheet->getCellByColumnAndRow($column, $row)->getCalculatedValue())->format('Y/m/d');
        }else {
            $val = $sheet->getCellByColumnAndRow($column, $row)->getCalculatedValue();
        }
        $excelArray[$row][] = $val;
        echo "<strong>" . $column . "）" . $val . "</strong>";
        echo "<br />";
    }
    echo "<br />已读完第<strong>" . $row . "</strong>行数据：" . $excelArray[$row][3] . "<hr>";
    //在这儿使用SQL语句，取$excelArray[$row][3]、$excelArray[$row][4]、$excelArray[$row][5]存入数据库对应字段
    $tmpDepartment = $excelArray[$row][1];
    $tmpName = $excelArray[$row][2];
    $sql="insert into mywage (fdepartment,fname) values ('$tmpDepartment','$tmpName')";
    //mysql_query("set names 'UTF-8'");
    if (@mysql_query($sql))
    {
        echo "添加数据记录：" . $excelArray[$row][2] . "成功";
    }else {
        echo "tmpName - > ". $tmpName;
        echo "失败";
    }
}