|
|
復(fù)制代碼 代碼如下:
<?php
error_reporting(E_ALL); //開啟錯(cuò)誤
set_time_limit(0); //腳本不超時(shí)
date_default_timezone_set('Europe/London'); //設(shè)置時(shí)間
/** Include path **/
set_include_path(get_include_path() . PATH_SEPARATOR . 'http://www.jb51.NET/../Classes/');//設(shè)置環(huán)境變量
/** phpExcel_IOFactory */
include 'phpExcel/IOFactory.php';
//$inputFileType = 'Excel5'; //這個(gè)是讀 xls的
$inputFileType = 'Excel2007';//這個(gè)是計(jì)xlsx的
//$inputFileName = './sampleData/example2.xls';
$inputFileName = './sampleData/book.xlsx';
echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
$objReader = phpExcel_IOFactory::createReader($inputFileType);
$objphpExcel = $objReader->load($inputFileName);
/*
$sheet = $objphpExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); //取得總行數(shù)
$highestColumn = $sheet->getHighestColumn(); //取得總列
*/
$objWorksheet = $objphpExcel->getActiveSheet();//取得總行數(shù)
$highestRow = $objWorksheet->getHighestRow();//取得總列數(shù)
echo 'highestRow='.$highestRow;
echo "<br>";
$highestColumn = $objWorksheet->getHighestColumn();
$highestColumnIndex = phpExcel_Cell::columnIndexFromString($highestColumn);//總列數(shù)
echo 'highestColumnIndex='.$highestColumnIndex;
echo "<br />";
$headtitle=array();
for ($row = 1;$row <= $highestRow;$row++)
{
$strs=array();
//注意highestColumnIndex的列數(shù)索引從0開始
for ($col = 0;$col < $highestColumnIndex;$col++)
{
$strs[$col] =$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
}
$info = array(
'word1'=>"$strs[0]",
'word2'=>"$strs[1]",
'word3'=>"$strs[2]",
'word4'=>"$strs[3]",
);
//在這兒，你可以連接，你的數(shù)據(jù)庫，寫入數(shù)據(jù)庫了
print_r($info);
echo '<br />';
}
?>
php技術(shù)：PHP 如何利用phpexcel導(dǎo)入數(shù)據(jù)庫，轉(zhuǎn)載需保留來源！
鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請第一時(shí)間聯(lián)系我們修改或刪除，多謝。
