<?php
header("Content-Type:text/html; charset=utf-8");
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
require_once(ROOT_PATH . '/includes/lib_order.php');
require_once './jdexcel/uploadexcel.php';
require_once './jdexcel/page.php';
require_once './jdexcel/Classes/PHPExcel.php';
require_once './jdexcel/Classes/PHPExcel/IOFactory.php';
require_once './jdexcel/Classes/PHPExcel/Reader/Excel5.php';
require_once './jdexcel/Classes/PHPExcel/Reader/Excel2007.php';
//上传
$action = isset($_REQUEST['act']) ? trim($_REQUEST['act']) : '';
if($action=='upload')
{
$images = upload( 'upload_file', 'jdexcel/upload/' );//上传图片的方法
if ($images != '文件为空' && $images != "文件太大" && $images != '上传excel文件失败') //表示页面图片更改过
{
$uploadexcel = $images;
$extend = strrchr($uploadexcel,'.');
if($extend == ".xlsx"){
$reader_type = "Excel2007";
}else if($extend == ".xls"){
$reader_type="Excel5";
}else{
unlink($uploadexcel);//导入文件格式不正确
}
$objReader = PHPExcel_IOFactory::createReader($reader_type);//use excel2007 for 2007 format
$PHPExcel = $objReader->load($uploadexcel); //$filename可以是上传的文件,或者是指定的文件
$sheet = $PHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数*/
if($highestColumn == "B"){
for($j=2;$j<=$highestRow;$j++)
{
$a = $PHPExcel->getActiveSheet()->getCell("A".$j)->getValue();//获取A列的值
$b = $PHPExcel->getActiveSheet()->getCell("B".$j)->getValue();//获取B列的值
$sql = "insert into wdcoupon values('',".$a.",".$b);";
$db->query($sql);
}
}
}
?>
header("Content-Type:text/html; charset=utf-8");
define('IN_ECS', true);
require(dirname(__FILE__) . '/includes/init.php');
require_once(ROOT_PATH . '/includes/lib_order.php');
require_once './jdexcel/uploadexcel.php';
require_once './jdexcel/page.php';
require_once './jdexcel/Classes/PHPExcel.php';
require_once './jdexcel/Classes/PHPExcel/IOFactory.php';
require_once './jdexcel/Classes/PHPExcel/Reader/Excel5.php';
require_once './jdexcel/Classes/PHPExcel/Reader/Excel2007.php';
//上传
$action = isset($_REQUEST['act']) ? trim($_REQUEST['act']) : '';
if($action=='upload')
{
$images = upload( 'upload_file', 'jdexcel/upload/' );//上传图片的方法
if ($images != '文件为空' && $images != "文件太大" && $images != '上传excel文件失败') //表示页面图片更改过
{
$uploadexcel = $images;
$extend = strrchr($uploadexcel,'.');
if($extend == ".xlsx"){
$reader_type = "Excel2007";
}else if($extend == ".xls"){
$reader_type="Excel5";
}else{
unlink($uploadexcel);//导入文件格式不正确
}
$objReader = PHPExcel_IOFactory::createReader($reader_type);//use excel2007 for 2007 format
$PHPExcel = $objReader->load($uploadexcel); //$filename可以是上传的文件,或者是指定的文件
$sheet = $PHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数*/
if($highestColumn == "B"){
for($j=2;$j<=$highestRow;$j++)
{
$a = $PHPExcel->getActiveSheet()->getCell("A".$j)->getValue();//获取A列的值
$b = $PHPExcel->getActiveSheet()->getCell("B".$j)->getValue();//获取B列的值
$sql = "insert into wdcoupon values('',".$a.",".$b);";
$db->query($sql);
}
}
}
?>