php excel讀取，phpexcel

php excel讀取，phpexcel

當然首先要判斷是否有文件和文件類型，接著把文件保存到某個路徑中

/**
 * 讀取excel數據
 * @author Red
 * @date
 * @param $filename 文件所在路徑+文件名
 * @param string $encode
 * @param $file_type
 * @return array
 */
function readExcel($filename, $encode = 'utf-8', $file_type)
{
    include './plugins/excel/PHPExcel.php';
    include './plugins/excel/PHPExcel/Reader/Excel2007.php';
    include './plugins/excel/PHPExcel/Writer/Excel5.php';
    include './plugins/excel/PHPExcel/Writer/Excel2007.php';

    if ($file_type == 'xlsx') {
        $objReader = PHPExcel_IOFactory::createReader('Excel2007');
    } else {
        $objReader = PHPExcel_IOFactory::createReader('Excel5');
    }

    $objReader->setReadDataOnly(true);

    $objPHPExcel        = $objReader->load($filename);
    $objWorksheet       = $objPHPExcel->getActiveSheet();
    $hightestrow        = $objWorksheet->getHighestRow();
    $highestColumn      = $objWorksheet->getHighestColumn();
    $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
    $excelData          = array();
　　 //從第二行開始
    for ($row = 2; $row <= $hightestrow; $row++) {
        for ($col = 0; $col < $highestColumnIndex; $col++) {
            $excelData[$row][] = (string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
        }
    }

    return $excelData;
}