利用PHPExcel导出Excel并设置Excel格式以及数据源
浏览:23969
发布日期:2013/07/24 分类:技术分享
代码有点长,读起来有点累。先来个截图导出的Excel太宽了,所以将后面的列宽重新调整了再截的图
功能包括:
1、设置单元格格式,包括单元格边框、单元格高度、单元格宽度
2、合并指定的单元格
3、设置Excel数据源,并将数据源保护起来(这个是为了实现单元格下拉选项功能)
4、设置字体样式
public
function export(){ -
-
$resumeState C ('RESUME_STATE'); -
$processingStatus C ('PROCESSING_STATUS'); -
$hunyin C ('HUNYIN'); -
$sex C ('SEX'); -
$AQE C ('AQE'); -
-
-
$C M ('Company'); -
$company $C ->where('status=1')->field('id,title')->order($this->order)->select(); -
-
-
$condition $this ->condition; -
$Model $this ->model; -
$Dao M ($Model); -
$list $Dao ->where($condition)->select(); -
-
(empty($list)){ -
$this -
-
-
vendor -
$fileName $this ->fileName; -
$fileName empty ($fileName)?'导出简历-'.date('Y-m-d',time()):$fileName; -
-
$PHPExcel new PHPExcel(); -
-
-
$PHPExcel -
-
-
-
-
-
-
$PHPExcel -
$PHPExcel -
-
-
$hrlist M ('Admin')->field('id,nickname')->select(); -
($hrlist as $key =>$value ){ -
$hr = $value ['nickname']; -
-
-
-
$PHPExcel -
$subObject $PHPExcel ->getSheet(1); -
$subObject -
($resumeState as $key =>$value ){ -
$subObject -
-
($processingStatus as $key =>$value ){ -
$subObject -
-
($company as $key =>$value ){ -
$subObject -
$companyList -
-
$subObject -
$subObject -
$subObject -
-
-
$subObject -
$subObject -
-
-
$PHPExcel '上海**人力资源服务有限公司'); -
-
$PHPExcel '简历列表(导出日期:'.date('Y-m-d',time()).')'); -
-
-
$PHPExcel 'ID'); -
$PHPExcel '姓名'); -
$PHPExcel '性别'); -
$PHPExcel '年龄'); -
$PHPExcel '联系方式'); -
$PHPExcel '学历'); -
$PHPExcel '是否有AQE证书'); -
$PHPExcel '住址'); -
$PHPExcel '面试日期'); -
$PHPExcel '面试时间'); -
$PHPExcel '所属HR'); -
-
$PHPExcel '备注'); -
$PHPExcel '证件号码'); -
$PHPExcel 'QQ'); -
$PHPExcel '电子邮箱'); -
$PHPExcel '出生日期'); -
$PHPExcel '婚姻状况'); -
$PHPExcel '户籍'); -
$PHPExcel '毕业时间'); -
$PHPExcel '毕业院校'); -
-
$PHPExcel '专业'); -
$PHPExcel '工作经历'); -
$PHPExcel '期望工作地点'); -
$PHPExcel '期望薪酬'); -
$PHPExcel '期望职业'); -
$PHPExcel '面试单位'); -
$PHPExcel '面试岗位'); -
$PHPExcel '目前状态'); -
$PHPExcel '处理状态'); -
$PHPExcel '自我评价'); -
$PHPExcel '其他'); -
-
-
$k 1; -
($list as $key =>$value ){ -
$k -
-
$PHPExcel $value ['id']); -
$PHPExcel $value ['name']); -
-
-
$PHPExcel -
setType (PHPExcel_Cell_DataValidation::TYPE_LIST) -
setErrorStyle (PHPExcel_Cell_DataValidation::STYLE_INFORMATION) -
setAllowBlank (false) -
setShowInputMessage (true) -
setShowErrorMessage (true) -
setShowDropDown (true) -
setErrorTitle ('请选择性别') -
setError ('您输入的值不在下拉框列表内.') -
setPromptTitle ('性别') -
setFormula1 ('"'.join(',',$sex ).'"'); -
$PHPExcel $sex [$value['sex']]); -
-
-
$PHPExcel $value ['age']); -
-
$PHPExcel $value ['tel']); -
$PHPExcel $value ['xueli']); -
-
-
$PHPExcel -
setType (PHPExcel_Cell_DataValidation::TYPE_LIST) -
setErrorStyle (PHPExcel_Cell_DataValidation::STYLE_INFORMATION) -
setAllowBlank (false) -
setShowInputMessage (true) -
setShowErrorMessage (true) -
setShowDropDown (true) -
setErrorTitle ('请选择是否有AQE证书') -
setError ('您输入的值不在下拉框列表内.') -
setPromptTitle ('是否有AQE证书') -
setFormula1 ('"'.join(',',$AQE ).'"'); -
$PHPExcel $AQE [$value['hasAQE']]); -
-
$PHPExcel $value ['juzhudi']); -
$PHPExcel setDate ($value['auditionTime'],'Y年m月d日'));//面试日期 -
$PHPExcel setDate ($value['auditionTime'],'H点i分'));//面试时间 -
$PHPExcel $hr [$value['userid']]);//所属HR -
$PHPExcel $value ['remark']);//备注 -
-
$PHPExcel $value ['cid']);//证件号码 -
$PHPExcel $value ['qq']); -
$PHPExcel $value ['email']); -
$PHPExcel setDate ($value['birthday'])); -
-
-
-
-
-
$PHPExcel -
setType (PHPExcel_Cell_DataValidation::TYPE_LIST) -
setErrorStyle (PHPExcel_Cell_DataValidation::STYLE_INFORMATION) -
setAllowBlank (false) -
setShowInputMessage (true) -
setShowErrorMessage (true) -
setShowDropDown (true) -
setErrorTitle ('请选择婚姻') -
setError ('您输入的值不在下拉框列表内.') -
setPromptTitle ('性别') -
setFormula1 ('"'.join(',',$hunyin ).'"'); -
$PHPExcel $hunyin [$value['hunyin']]); -
-
$PHPExcel $value ['huji']); -
$PHPExcel setDate ($value['graduationTime'])); -
$PHPExcel $value ['graduationSchool']); -
$PHPExcel $value ['specialty']); -
$PHPExcel $value ['works']); -
$PHPExcel $value ['expectAddress']); -
$PHPExcel $value ['expectSalary']); -
$PHPExcel $value ['expectProfession']); -
-
-
$PHPExcel -
setType (PHPExcel_Cell_DataValidation::TYPE_LIST) -
setErrorStyle (PHPExcel_Cell_DataValidation::STYLE_INFORMATION) -
setAllowBlank (false) -
setShowInputMessage (true) -
setShowErrorMessage (true) -
setShowDropDown (true) -
setErrorTitle ('输入的值有误') -
setError ('您输入的值不在下拉框列表内.') -
setPromptTitle ('面试单位') -
setFormula1 ('data!$C$1:$C$'.count($company)); -
$PHPExcel $companyList [$value['company']]);//面试单位 -
$PHPExcel $value ['post']);//面试岗位 -
-
-
$PHPExcel -
setType (PHPExcel_Cell_DataValidation::TYPE_LIST) -
setErrorStyle (PHPExcel_Cell_DataValidation::STYLE_INFORMATION) -
setAllowBlank (false) -
setShowInputMessage (true) -
setShowErrorMessage (true) -
setShowDropDown (true) -
setErrorTitle ('输入的值有误') -
setError ('您输入的值不在下拉框列表内.') -
setPromptTitle ('简历状态') -
setFormula1 ('data!$A$1:$A$'.count($resumeState)); -
$PHPExcel $resumeState [$value['resumeState']]); -
-
-
$PHPExcel -
setType (PHPExcel_Cell_DataValidation::TYPE_LIST) -
setErrorStyle (PHPExcel_Cell_DataValidation::STYLE_INFORMATION) -
setAllowBlank (false) -
setShowInputMessage (true) -
setShowErrorMessage (true) -
setShowDropDown (true) -
setErrorTitle ('输入的值有误') -
setError ('您输入的值不在下拉框列表内.') -
setPromptTitle ('处理状态') -
setFormula1 ('data!$B$1:$B$'.count($processingStatus)); -
$PHPExcel $processingStatus [$value['processingStatus']]); -
-
$PHPExcel $value ['selfIntroduction']); -
$PHPExcel $value ['other']); -
-
-
$PHPExcel -
-
-
-
$PHPExcel -
$PHPExcel -
-
-
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
-
-
$PHPExcel -
$PHPExcel -
$PHPExcel -
-
-
$PHPExcel -
$PHPExcel -
$PHPExcel -
$PHPExcel -
-
$PHPExcel -
$PHPExcel -
-
$PHPExcel -
-
$PHPExcel -
-
-
$PHPExcel -
-
-
$PHPExcel -
-
-
$PHPExcel -
-
-
-
$objWriter new PHPExcel_Writer_Excel5($PHPExcel); -
header public" ); -
header 0" ); -
header post-check=0, );pre-check=0" -
header -
header -
header -
header -
-
-
$encoded_filename urlencode ($fileName); -
$ua $_SERVER ["HTTP_USER_AGENT"]; -
(preg_match("/MSIE/", $ua )){ -
header attachment; filename="' . $encoded_filename .'.xls"'); -
else if (preg_match("/Firefox/", $ua )){ -
header attachment; filename*="utf8\'\'' . $fileName .'.xls"'); -
else { -
header attachment; filename="' . $fileName .'.xls"'); -
-
-
header -
$objWriter -
赞赏码
非学,无以致疑;非问,无以广识