废话不多说,直接上代码吧
<?php
error_reporting(e_all); //开启错误
set_time_limit(0); //脚本不超时
date_default_timezone_set('europe/london'); //设置时间
/** include path **/
set_include_path(get_include_path() . path_separator . '//www.jb51.net/../classes/');//设置环境变量
/** phpexcel_iofactory */
include 'phpexcel/iofactory.php';
//$inputfiletype = 'excel5'; //这个是读 xls的
$inputfiletype = 'excel2007';//这个是计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(); //取得总行数
$highestcolumn = $sheet->gethighestcolumn(); //取得总列
*/
$objworksheet = $objphpexcel->getactivesheet();//取得总行数
$highestrow = $objworksheet->gethighestrow();//取得总列数
echo 'highestrow='.$highestrow;
echo "<br>";
$highestcolumn = $objworksheet->gethighestcolumn();
$highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);//总列数
echo 'highestcolumnindex='.$highestcolumnindex;
echo "<br />";
$headtitle=array();
for ($row = 1;$row <= $highestrow;$row++)
{
$strs=array();
//注意highestcolumnindex的列数索引从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]",
);
//在这儿,你可以连接,你的数据库,写入数据库了
print_r($info);
echo '<br />';
}
?>
如对本文有疑问,
点击进行留言回复!!
相关文章:
-
-
-
-
网安追踪流程
1.不用代理网民发帖流程:发帖人 → ISP → 服务器托管商 → 服务器网警追踪流程:网监 → 服务器IP →...
[阅读全文]
-
-
-
HTTP状态码大全
转自:https://www.cnblogs.com/lxinxuan/archive/2009/10/22/1...
[阅读全文]
-
-
-
-
网友评论