完整项源码下载地址：https://github.com/sunjdk/SEO-SYSTEM
PHPExcel 读取Excel Demo
$objExcel=new \PHPExcel();
$objReader=new \PHPExcel_Reader_Excel2007();
foreach($list as $k=>$v){
$path=$v['excel'];
if(!$objReader->canRead($path)){
$objReader=new \PHPExcel_Reader_Excel5();
if(!$objReader->canRead($path)){
echo '读取错误';
return ;
}
}
$objReader->setReadDataOnly(true);
$excel=$objReader->load($path);
$currentSheet=$excel->getSheet(0);
$maxcol=$currentSheet->getHighestColumn();
$maxrow=$currentSheet->getHighestRow();
$excelData=array();
for($row=1;$row<=$maxrow;$row++){
for($col='A';$col<=$maxcol;$col++){
$address = $col.$row;
$excelData[$row][$col]=$currentSheet->getCell($address)->getValue();
}
}
$list[$k]['excel']=$excelData;
} WebUpload 异步上传整合Demo$(function(){
var BASE_URL = "__PUBLIC__/js/webuploader";
var syncPath="{:U('AdminSeo/synUpload')}";
var $list=$('#thelist'),
$btn = $('#ctlBtn'),
state = 'pending',
uploader;
uploader=WebUploader.create({
resize: false,
swf: BASE_URL + '/js/Uploader.swf',
server: syncPath,
pick:{
id:'#picker',
name:'',
label:'点击选择Excel文件',
multiple:false
} ,
fileNumLimit:1,
duplicate:true,//是否可重复选择同一文件
accept: {
title: 'Files',
extensions: 'xls,xlsx',
mimeTypes: 'application/vnd.ms-excel'
}
});
uploader.on( 'beforeFileQueued', function( file ){
if(file.size>(1024*1024*8)){
alert('文件大于8M');
return false;
}else{
return true;
}
});
uploader.on( 'fileQueued', function( file ) {
$list.append( '<div id="' + file.id + '" class="item">' +
'<h4 class="info">' + file.name + '</h4>' +
'<p class="state">等待上传...</p>' +
'</div>' );
});
// 文件上传过程中创建进度条实时显示。
uploader.on( 'uploadProgress', function( file, percentage ) {
var $li = $( '#'+file.id ),
$percent = $li.find('.progress .progress-bar');
// 避免重复创建
if ( !$percent.length ) {
$percent = $('<div class="progress progress-striped active">' +
'<div class="progress-bar" role="progressbar" style="width: 0%">' +
'</div>' +
'</div>').appendTo( $li ).find('.progress-bar');
}
$li.find('p.state').text('上传中');
$percent.css( 'width', percentage * 100 + '%' );
});
uploader.on( 'uploadSuccess', function( file,response ) {
if(response.status){
$("input[name='excel']").val(response.value);
$( '#'+file.id ).find('p.state').text('已上传');
}else{
$( '#'+file.id ).find('p.state').text(response.msg);
}
});
uploader.on( 'uploadError', function( file ) {
$( '#'+file.id ).find('p.state').text('上传出错');
});
uploader.on( 'uploadComplete', function( file ) {
$( '#'+file.id ).find('.progress').fadeOut();
});
uploader.on( 'all', function( type ) {
if ( type === 'startUpload' ) {
state = 'uploading';
} else if ( type === 'stopUpload' ) {
state = 'paused';
} else if ( type === 'uploadFinished' ) {
state = 'done';
}
if ( state === 'uploading' ) {
$btn.text('暂停上传');
} else {
$btn.text('开始上传');
}
});
uploader.on('uploadFinished', function () {
//清空队列
uploader.reset();
});
/* uploader.on('uploadAccept', function( file, response ){
//console.log(response);
if(!response.status){
$( '#'+file.id ).find('p.state').text(response.msg);
}
}); */
$btn.on( 'click', function() {
if ( state === 'uploading' ) {
uploader.stop();
} else {
uploader.upload();
}
});
})作者：桃谷六仙(微信：huaweixiPhone)打赏途径：
案例链接：http://www.topthink.com/topic/26801.html
