TP5使用phpexce上传导入csv文件

最新推荐文章于 2022-11-03 15:53:28 发布

韭零后程序猿

最新推荐文章于 2022-11-03 15:53:28 发布

阅读量1.2k

点赞数

分类专栏：服务器框架后台 php excel 文章标签： tp5 phpexcel csv 导入

本文链接：https://blog.csdn.net/qq_34627459/article/details/85615131

版权

服务器同时被 3 个专栏收录

30 篇文章 0 订阅

订阅专栏

php

15 篇文章 0 订阅

订阅专栏

后台

8 篇文章 0 订阅

订阅专栏

前端上传使用layui.upload组件,具体参考Layui手册

php:

//主逻辑
//限制上传表格类型
$file_type = $_FILES['excel_import']['type'];
if ($file_type!='application/vnd.ms-excel') {
   return [RESULT_ERROR,'上传失败，只能上传excel表格!'];
}
if (is_uploaded_file($_FILES['excel_import']['tmp_name'])) {//判断文件上传是否成功
   $data = get_excel_data($_FILES['excel_import']['tmp_name'],2,0,'csv');
   //TODO 执行导入后的逻辑
}else{
   return [RESULT_ERROR, '请选择文件后导入'];
}

//get_excel_data
/**
 * 读取excel返回数据
 */
function get_excel_data($file_url = '', $start_row = 1, $start_col = 0, $type = 'xls')
{
    vendor('phpoffice/phpexcel/Classes/PHPExcel');
    //此处逻辑为解决导入xls和csv的冲突
    if( $type=='xlsx'||$type=='xls' ){
        $objPHPExcel = PHPExcel_IOFactory::load($file_url);
    }else if( $type=='csv' ){
        $objReader = PHPExcel_IOFactory::createReader('CSV')
            ->setDelimiter(',')
            ->setInputEncoding('GBK') //不设置将导致中文列内容返回boolean(false)或乱码
            ->setEnclosure('"')
            ->setSheetIndex(0);
        $objPHPExcel = $objReader->load($file_url);
    }else{
        die('Not supported file types!');
    }
    $objWorksheet       = $objPHPExcel->getActiveSheet();
    $highestRow         = $objWorksheet->getHighestDataRow(); 
    $highestColumn      = $objWorksheet->getHighestDataColumn(); 
   $highestColumnIndex  = PHPExcel_Cell::columnIndexFromString($highestColumn); 
    
    $excel_data = [];
    
    for ($row = $start_row; $row <= $highestRow; $row++)
    {
        for ($col = $start_col; $col < $highestColumnIndex; $col++)
        {
            $excel_data[$row][] =(string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
        }
    }

    return $excel_data;
}