读取EXCEL

/**
 * 读取excel
 * @param $filename
 * @param int $sheet
 * @return array
 */
function readExcel($filename,$sheet=0)
{
    //导入PHPExcel
    vendor("PHPExcel.PHPExcel");
    //$cacheMethod = \PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
    //$cacheSettings = array('memoryCacheSize'=>'100MB');
    //\PHPExcel_Settings::setCacheStorageMethod($cacheMethod);
    $filePath = $filename;
    $data = array();
    if (strpos($filename, '.csv')) {
        $objReader = \PHPExcel_IOFactory::createReader('CSV')
            ->setDelimiter(',')
            ->setInputEncoding('gb2312') //不设置将导致中文列内容返回boolean(false)或乱码
            ->setEnclosure('"');
        $PHPExcel = $objReader->load($filename);
    } else {
        $PHPExcel = \PHPExcel_IOFactory::load($filename);
    }

    if ($sheet) {
        $currentSheet = $PHPExcel->getSheet($sheet);
    } else {
        $currentSheet = $PHPExcel->getActiveSheet();//当前工作表
    }

    $columns = $currentSheet->getHighestColumn(); // 总列数
    $columns++;
    $rows = $currentSheet->getHighestRow(); // 总行数

    //\PHPExcel_Cell::columnIndexFromString($highestColumn); //字母列转换为数字列 如:AA变为26
    //$cell = $currentSheet->getCellByColumnAndRow(数字列, 数字行)->getValue();
    //$columnName = \PHPExcel_Cell::stringFromColumnIndex(27);
    $data = array();
    //循环读取每个单元格的内容。注意行从1开始，列从A开始
    for($row=1;$row<=$rows;$row++){
        for($column='A';$column!=$columns;$column++){
            //$cell = \PHPExcel_Shared_Date::ExcelToPHP($currentSheet->getCell($column.$row)->getValue())-8*3600;//把中国时间当做格林威治时间来转时间戳,所以+8时区
            $cell = $currentSheet->getCell($column.$row)->getValue();
            if($cell instanceof \PHPExcel_RichText) {//富文本转换字符串
                $cell = $cell->__toString();
            }
            $data[$row][]=$cell;
            if($column == $columns) {
                break;
            }
        }
    }
    return $data;
}