<?
php
class ExcelAction
extends Action{
public function read(
$filename,
$encode='utf-8'
){
vendor('Excel.PHPExcel'
);
$objReader = PHPExcel_IOFactory::
createReader(Excel5);
$objReader->setReadDataOnly(
true);
$objPHPExcel =
$objReader->load(
$filename);
$objWorksheet =
$objPHPExcel->
getActiveSheet();
$highestRow =
$objWorksheet->
getHighestRow();
$highestColumn =
$objWorksheet->
getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString(
$highestColumn);
$excelData =
array();
for (
$row = 1;
$row <=
$highestRow;
$row++
) {
for (
$col = 0;
$col <
$highestColumnIndex;
$col++
) {
$excelData[
$row][] =(
string)
$objWorksheet->getCellByColumnAndRow(
$col,
$row)->
getValue();
}
}
return $excelData;
}
public function excel(){
$this->
display();
}
public function runexcel(){
if (!
empty (
$_FILES ['file_stu'] ['name'
] ))
{
$tmp_file =
$_FILES ['file_stu'] ['tmp_name'
];
$file_types =
explode ( ".",
$_FILES ['file_stu'] ['name'
] );
$file_type =
$file_types [
count (
$file_types ) - 1
];
/*判别是不是.xls文件，判别是不是excel文件*/
if (
strtolower (
$file_type ) != "xls"
)
{
$this->error ( '不是Excel文件，重新上传'
);
}
/*设置上传路径*/
$savePath = '/'
;
/*以时间来命名上传的文件*/
$str =
date ( 'Ymdhis'
);
$file_name =
$str . "." .
$file_type;
/*是否上传成功*/
if (!
copy (
$tmp_file,
$savePath .
$file_name ))
{
$this->error ( '上传失败'
);
}
/*
*对上传的Excel数据进行处理生成编程数据,这个函数会在下面第三步的ExcelToArray类中
注意：这里调用执行了第三步类里面的read函数，把Excel转化为数组并返回给$res,再进行数据库写入
*/
$res =
$this->read (
$savePath .
$file_name );
/*
重要代码 解决Thinkphp M、D方法不能调用的问题
如果在thinkphp中遇到M 、D方法失效时就加入下面一句代码
*/
spl_autoload_register ( array ('Think', 'autoload'
) );
/*对生成的数组进行数据库的写入*/
foreach (
$res as $k =>
$v )
{
if (
$k != 0
)
{
$data ['khmc'] =
$v[0
];
$data ['lxdz'] =
$v[6
];
$data ['khdh'] =
$v[4
];
$result = M ( 'khgl' )->add (
$data );
if (!
$result)
{
$this->error ( '导入数据库失败'
);
}
}
}
}
}
}
?>
转载于:https://www.cnblogs.com/hgj123/p/4260149.html
