dedecms导入excel数据

<?php
require_once 'include/common.inc.php';
require_once 'include/arc.partview.class.php';

// 加载Excel文件
$inputFileName = './excelsample.xlsx';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

// 获取第一个工作表
$worksheet = $objPHPExcel->getActiveSheet();

// 获取数据范围
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();

// 准备SQL语句
$sql = "INSERT INTO `dede_archives` (`typeid`, `title`, `sortrank`, `litpic`, `writer`, `source`, `keyword`, `description`, `click`, `dtime`) VALUES ";

$values = array();
for ($row = 2; $row <= $highestRow; $row++) {
    $typeid = $worksheet->getCell('A' . $row)->getValue();
    $title = $worksheet->getCell('B' . $row)->getValue();
    $sortrank = $worksheet->getCell('C' . $row)->getValue();
    $litpic = $worksheet->getCell('D' . $row)->getValue();
    $writer = $worksheet->getCell('E' . $row)->getValue();
    $source = $worksheet->getCell('F' . $row)->getValue();
    $keyword = $worksheet->getCell('G' . $row)->getValue();
    $description = $worksheet->getCell('H' . $row)->getValue();
    $click = $worksheet->getCell('I' . $row)->getValue();
    $dtime = $worksheet->getCell('J' . $row)->getValue();

    $values[] = "($typeid, '$title', $sortrank, '$litpic', '$writer', '$source', '$keyword', '$description', $click, $dtime)";
}

$sql .= implode(', ', $values);

// 执行SQL语句
$dm = new DedeSql(false);
$dm->ExecuteNoneQuery($sql);
?>