thinkphp导入 xls

use think\facade\Lang;
use think\facade\Log;
use think\facade\Filesystem;

// 设置文件编码
$excel = new \PHPExcel();
$excel->setActiveSheetIndex(0);
$excel->getActiveSheet()->setTitle('Sheet1');

// 读取文件
$inputFileName = './excels/example.xls';
try {
    $reader = \PHPExcel_IOFactory::createReaderForFile($inputFileName);
    $reader->setReadDataOnly(true);
    $excel = $reader->load($inputFileName);
} catch (\Exception $e) {
    Log::error('读取Excel文件失败: ' . $e->getMessage());
    Lang::throwException('读取Excel文件失败');
}

// 处理数据
foreach ($excel->getActiveSheet()->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false);
    foreach ($cellIterator as $cell) {
        echo $cell->getValue() . "\t";
    }
    echo "\n";
}

use think\facade\Log;
use think\facade\Filesystem;

// 分批导入数据
$batchSize = 1000;
$rowCount = 0;
foreach ($excel->getActiveSheet()->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false);
    $rowData = [];
    foreach ($cellIterator as $cell) {
        $rowData[] = $cell->getValue();
    }
    // 插入数据库
    Db::name('table_name')->insert($rowData);
    $rowCount++;
    if ($rowCount % $batchSize === 0) {
        Db::name('table_name')->commit();
        Db::name('table_name')->startTrans();
    }
}
Db::name('table_name')->commit();