PHPExcel 读取Excel表格Demo
完整项源码下载地址: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

评论() 相关

收藏

赞

sWWWs

ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。