phpexcel 读取excel文件在将数据插入数据库

qq_57657160

于 2022-08-09 10:15:15 发布

阅读量475

点赞数

文章标签：数据库 servlet java

本文链接：https://blog.csdn.net/qq_57657160/article/details/126242072

版权

public function acIndex()
    {
        $fileName = "C:\Users\**\Desktop\省市区编码 .xlsx";
        if (!file_exists($fileName)) {
            exit("文件" . $fileName . "不存在");
        }
        $objPHPExcel = PHPExcel_IOFactory::load($fileName);
        $sheetCount = $objPHPExcel->getSheetCount();
        $sheetSelected = 0;
        $objPHPExcel->setActiveSheetIndex($sheetSelected);
        $rowCount = $objPHPExcel->getActiveSheet()->getHighestRow();
        $columnCount = $objPHPExcel->getActiveSheet()->getHighestColumn();
        $dataArr = array();
        for ($row = 1; $row <= $rowCount; $row++) {
//列数循环 , 列数是以A列开始
            for ($column = 'A'; $column <= $columnCount; $column++) {
                $dataArr[] = $objPHPExcel->getActiveSheet()->getCell($column . $row)->getValue();
            }
        }
        $sqlData = [[]];
//根据自己的列表情况处理数据