## html
```
<form enctype="multipart/form-data" action="/web/merchant.php?c=site&a=entry&m=ewei_shopv2&do=web&r=goods.daoru" method="post">
<div style="display: flex;">
<input type="file" name="myfile" />
<input type="submit" class='btn btn-sm btn-primary' value="導入商品" />
</div>
</form>
```
## php
```
public function daoru()
{
global $_W;
global $_GPC;
require_once IA_ROOT . '/framework/library/phpexcel/PHPExcel.php';
require_once IA_ROOT . '/framework/library/phpexcel/PHPExcel/IOFactory.php';
require_once IA_ROOT . '/framework/library/phpexcel/PHPExcel/Reader/Excel5.php';
$objReader = PHPExcel_IOFactory::createReader('Excel5');
//接收存在緩存中的excel表格
$filename = $_FILES['myfile']['tmp_name'];
$objPHPExcel = $objReader->load($filename); //$filename可以是上傳的表格，或者是指定的表格
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得總行數
$highestColumn = $sheet->getHighestColumn(); // 取得總列數
//循環讀取excel表格,讀取一條,插入一條
//j表示從哪一行開始讀取 從第二行開始讀取，因為第一行是標題不保存
//$a表示列號
for($j=2;$j<=$highestRow;$j++)
{
$h1 = $objPHPExcel->getActiveSheet()->getCell("B".$j)->getValue();//獲取B(密碼)列的值
$h2 = $objPHPExcel->getActiveSheet()->getCell("C".$j)->getValue();//獲取B(密碼)列的值
$h3 = $objPHPExcel->getActiveSheet()->getCell("D".$j)->getValue();//獲取B(密碼)列的值
$h4 = $objPHPExcel->getActiveSheet()->getCell("E".$j)->getValue();//獲取B(密碼)列的值
$h5 = $objPHPExcel->getActiveSheet()->getCell("F".$j)->getValue();//獲取B(密碼)列的值
$h6 = $objPHPExcel->getActiveSheet()->getCell("G".$j)->getValue();//獲取B(密碼)列的值
$h7 = $objPHPExcel->getActiveSheet()->getCell("H".$j)->getValue();//獲取B(密碼)列的值
$h8 = $objPHPExcel->getActiveSheet()->getCell("I".$j)->getValue();//獲取B(密碼)列的值
$h9 = $objPHPExcel->getActiveSheet()->getCell("J".$j)->getValue();//獲取B(密碼)列的值
$h10 = $objPHPExcel->getActiveSheet()->getCell("K".$j)->getValue();//獲取B(密碼)列的值
$h11 = $objPHPExcel->getActiveSheet()->getCell("L".$j)->getValue();//獲取B(密碼)列的值
$h12 = $objPHPExcel->getActiveSheet()->getCell("M".$j)->getValue();//獲取B(密碼)列的值
$h13 = $objPHPExcel->getActiveSheet()->getCell("N".$j)->getValue();//獲取B(密碼)列的值
$h14 = $objPHPExcel->getActiveSheet()->getCell("O".$j)->getValue();//獲取B(密碼)列的值
$h15 = $objPHPExcel->getActiveSheet()->getCell("P".$j)->getValue();//獲取B(密碼)列的值
$h16 = $objPHPExcel->getActiveSheet()->getCell("Q".$j)->getValue();//獲取B(密碼)列的值
$h17 = $objPHPExcel->getActiveSheet()->getCell("R".$j)->getValue();//獲取B(密碼)列的值
$h18 = $objPHPExcel->getActiveSheet()->getCell("S".$j)->getValue();//獲取B(密碼)列的值
$h19 = $objPHPExcel->getActiveSheet()->getCell("T".$j)->getValue();//獲取B(密碼)列的值
$h20 = $objPHPExcel->getActiveSheet()->getCell("U".$j)->getValue();//獲取B(密碼)列的值
$h21 = $objPHPExcel->getActiveSheet()->getCell("V".$j)->getValue();//獲取B(密碼)列的值
$h22 = $objPHPExcel->getActiveSheet()->getCell("W".$j)->getValue();//獲取B(密碼)列的值
$h23 = $objPHPExcel->getActiveSheet()->getCell("X".$j)->getValue();//獲取B(密碼)列的值
$h24 = $objPHPExcel->getActiveSheet()->getCell("Y".$j)->getValue();//獲取B(密碼)列的值
$h25 = $objPHPExcel->getActiveSheet()->getCell("Z".$j)->getValue();//獲取B(密碼)列的值
$user_data = array(
'uniacid' => $h1,
'pcate' => $h2,
'ccate' => $h3,
'type' => $h4,
'status' => $h5,
'title' => $h6,
'thumb' => $h7,
'content' => $h8,
'productprice' => $h9,
'marketprice' => $h10,
'costprice' => $h11,
'originalprice' => $h12,
'total' => $h13,
'createtime' => $h14,
'weight' => $h15,
'maxprice' => $h16,
'minprice' => $h17,
'cates' => $h18,
'hasoption' => $h19,
'thumb_url' => $h20,
'isverify' => $h21,
'tcate' => $h22,
'discounts' => $h23,
'tcates' => $h24,
'keywords' => $h25,
'merchid'=> $_W['merchid']
);
$result = pdo_insert('ewei_shop_goods', $user_data);
}
echo "<script>alert('導入完成！！！');</script>";
header('Location: /web/merchant.php?c=site&a=entry&m=ewei_shopv2&do=web&r=goods');
}
```
