error_reporting( E_ALL&~E_NOTICE );
header('Content-Type: text/html;charset=utf-8');
//<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
//连接数据库文件
$connect=mysql_connect("localhost","root","") or die("链接数据库失败!");
//连接数据库(ashley)
mysql_select_db("ashley",$connect) or die (mysql_error());
require_once 'Classes/PHPExcel.php';
require_once 'Classes/PHPExcel/Reader/Excel2007.php';
require_once 'Classes/PHPExcel/Reader/Excel5.php';
include_once 'Classes/PHPExcel/IOFactory.php';
//$objReader = PHPExcel_IOFactory::createReader ('Excel2007');
$objReader=PHPExcel_IOFactory::createReader('Excel5');//use excel2007 for 2007 format
$objReader->setReadDataOnly ( true );
$file_url="aA.xls";
$objPHPExcel = $objReader->load ($file_url);
//ECHO 'FDFD';DIE;
//$objWorksheet = $objPHPExcel->getActiveSheet ();
$objWorksheet = $objPHPExcel->getSheet (0);
//取得excel的总行数
$highestRow = $objWorksheet->getHighestRow ();
//取得excel的总列数
$highestColumn = $objWorksheet->getHighestColumn ();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString ( $highestColumn );
//echo $highestColumnIndex;die;
$excelData = array ();
for($row = 3; $row <= $highestRow; $row++) {
for($col = 1; $col < $highestColumnIndex; $col++) {
$excelData[$row-2][] = $objWorksheet->getCellByColumnAndRow ( $col, $row )->getValue ();
}
}
//echo "<pre>";
//print_r($excelData);
//echo "</pre>";die;
foreach($excelData as $val)
{
//echo $val[1].'<br/>';
$sql="INSERT INTO bedding VALUES (
'',
'$val[0]',
'$val[1]',
'$val[2]',
'$val[3]',
'$val[4]',
'$val[5]',
'$val[6]',
'$val[7]',
'$val[8]',
'$val[9]',
'$val[10]',
'$val[11]',
'$val[12]',
'$val[13]',
'$val[14]',
'$val[15]',
'$val[16]',
'$val[17]',
'$val[18]',
'$val[19]',
'$val[20]',
'$val[21]',
'$val[22]',
'$val[23]',
'$val[24]',
'$val[25]',
'$val[26]')";
//echo $sql;die;
mysql_query("SET NAMES UTF8");
mysql_query($sql) or die (mysql_error());
if (!mysql_error());
{
echo " 成功导入数据!";
}
echo $string[4]."\n";
unset($string);
}
//unlink($file_url); //删除excel文件
EXCEL 写放MYSQL
最新推荐文章于 2024-03-15 14:46:08 发布