php实现excel单元格合并,字体加粗居中等操作
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了php实现excel单元格合并,字体加粗居中等操作,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含6401字,纯文字阅读大概需要10分钟。
内容图文
使用的是phpexcel,基本用的原生语法,所见即所得,直接复制下面代码,即可:
// 引用phpexcel类 $this->load->library(‘PHPExcel‘); // 创建对象$objPHPExcel = new PHPExcel(); // 显示错误信息error_reporting(E_ALL); // Set properties$objPHPExcel->getProperties()->setCreator("1245049149@qq.com") ->setLastModifiedBy("1245049149@qq.com") ->setTitle("Office 2007 XLSX Test Document") ->setSubject("Office 2007 XLSX Test Document") ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") ->setKeywords("office 2007 openxml php") ->setCategory("Test result file"); // 字体和样式$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(12); //字体大小$objPHPExcel->getActiveSheet()->getStyle(‘A2:D2‘)->getFont()->setBold(false); //第二行是否加粗$objPHPExcel->getActiveSheet()->getStyle(‘A1‘)->getFont()->setBold(true); //第一行是否加粗$objPHPExcel->getActiveSheet()->getStyle(‘A1‘)->getFont()->setSize(16); //第一行字体大小$objPHPExcel->getActiveSheet()->getStyle(‘A2‘)->getFont()->setSize(14); //第二行字体大小$objPHPExcel->getActiveSheet()->getStyle(‘A6‘)->getFont()->setSize(14); //第六行字体大小$objPHPExcel->getActiveSheet()->getStyle(‘A11‘)->getFont()->setSize(14); //第十一行字体大小 // 设置垂直居中$objPHPExcel->getActiveSheet()->getStyle(‘A1‘)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(‘A2:D2‘)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); // 设置水平居中$objPHPExcel->getActiveSheet()->getStyle(‘A1‘)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(‘A3:G5‘)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(‘A7:G10‘)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(‘A12:B15‘)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //设置左对齐$objPHPExcel->getActiveSheet()->getStyle(‘A2‘)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle(‘A6‘)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle(‘A11‘)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); // 设置行高度$objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(20); //设置默认行高$objPHPExcel->getActiveSheet()->getRowDimension(‘1‘)->setRowHeight(30); //第一行行高 //设置单元格宽度$objPHPExcel->getActiveSheet()->getColumnDimension(‘A‘)->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension(‘B‘)->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension(‘C‘)->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension(‘D‘)->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension(‘E‘)->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension(‘F‘)->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension(‘G‘)->setWidth(20); // 合并$objPHPExcel->getActiveSheet()->mergeCells(‘A1:G1‘); $objPHPExcel->getActiveSheet()->mergeCells(‘A2:G2‘); $objPHPExcel->getActiveSheet()->mergeCells(‘A6:G6‘); $objPHPExcel->getActiveSheet()->mergeCells(‘A11:B11‘); // 设置内容$objPHPExcel->setActiveSheetIndex(0) ->setCellValue(‘A1‘, ‘利润核算统计‘) ->setCellValue(‘A2‘, ‘【用户充值】‘) ->setCellValue(‘A3‘, ‘费率‘) ->setCellValue(‘B3‘, ‘笔数 ‘) ->setCellValue(‘C3‘, ‘充值进账‘) ->setCellValue(‘D3‘, ‘手续费‘) ->setCellValue(‘E3‘, ‘利润‘) ->setCellValue(‘A4‘, ‘1.0%‘) ->setCellValue(‘B4‘, $pay_log_list[‘aa‘]) ->setCellValue(‘C4‘, $pay_log_list[‘bb‘]) ->setCellValue(‘D4‘, $pay_log_list[‘cc‘]) ->setCellValue(‘E4‘, $pay_log_list[‘dd‘]) ->setCellValue(‘A5‘, ‘合计‘) ->setCellValue(‘B5‘, $pay_log_list[‘ee‘]) ->setCellValue(‘C5‘, $pay_log_list[‘ff‘]) ->setCellValue(‘D5‘, $pay_log_list[‘gg‘]) ->setCellValue(‘E5‘, $pay_log_list[‘hh‘]) ->setCellValue(‘A6‘, ‘【用户提现】‘) ->setCellValue(‘A7‘, ‘类别‘) ->setCellValue(‘B7‘, ‘笔数‘) ->setCellValue(‘C7‘, ‘申请提现‘) ->setCellValue(‘D7‘, ‘手续费‘) ->setCellValue(‘E7‘, ‘快钱提现‘) ->setCellValue(‘F7‘, ‘手续费‘) ->setCellValue(‘G7‘, ‘利润‘) ->setCellValue(‘A8‘, ‘收取手续费‘) ->setCellValue(‘B8‘, $withdraw_list[‘ii‘]) ->setCellValue(‘C8‘, $withdraw_list[‘kk‘]) ->setCellValue(‘D8‘, $withdraw_list[‘ll‘]) ->setCellValue(‘E8‘, $withdraw_list[‘mm‘]) ->setCellValue(‘F8‘, $withdraw_list[‘nn‘]) ->setCellValue(‘G8‘, $withdraw_list[‘oo‘]) ->setCellValue(‘A9‘, ‘未收取手续费‘) ->setCellValue(‘B9‘, $withdraw_list[‘pp‘]) ->setCellValue(‘C9‘, $withdraw_list[‘qq‘]) ->setCellValue(‘D9‘, $withdraw_list[‘rr‘]) ->setCellValue(‘E9‘, $withdraw_list[‘ss‘]) ->setCellValue(‘F9‘, $withdraw_list[‘tt‘]) ->setCellValue(‘G9‘, $withdraw_list[‘ww‘]) ->setCellValue(‘A10‘, ‘合计‘) ->setCellValue(‘B10‘, $withdraw_list[‘uu‘]) ->setCellValue(‘C10‘, $withdraw_list[‘vv‘]) ->setCellValue(‘D10‘, $withdraw_list[‘xx‘]) ->setCellValue(‘E10‘, $withdraw_list[‘yy‘]) ->setCellValue(‘F10‘, $withdraw_list[‘zz‘]) ->setCellValue(‘G10‘, $withdraw_list[‘aaa‘]) ->setCellValue(‘A11‘, ‘【利润汇总】‘) ->setCellValue(‘A12‘, ‘充值手续费收‘) ->setCellValue(‘B12‘, $all_summary[‘bbb‘]) ->setCellValue(‘A13‘, ‘提现手续费支‘) ->setCellValue(‘B13‘, $all_summary[‘ccc‘]) ->setCellValue(‘A14‘, ‘快钱提现手续费支‘) ->setCellValue(‘B14‘, $all_summary[‘ddd‘]) ->setCellValue(‘A15‘, ‘利润‘) ->setCellValue(‘B15‘, $all_summary[‘eee‘]); // Rename sheet$objPHPExcel->getActiveSheet()->setTitle(‘利润核算表‘); // Set active sheet index to the first sheet, so Excel opens this as the first sheet$objPHPExcel->setActiveSheetIndex(0); // 设置输出$tableName = ‘利润核算表【‘.$st.‘--‘.$et.‘】‘; header(‘Content-Type: application/vnd.ms-excel‘); header(‘Content-Disposition: attachment;filename="‘ .$tableName. ‘.xls"‘); header(‘Cache-Control: max-age=0‘); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel5‘); $objWriter->save(‘php://output‘); exit;
基本效果展示,视图页面样式:
下载excel后,效果展示:
转 : https://www.cnblogs.com/qwgshare/p/9782889.html
原文:https://www.cnblogs.com/fps2tao/p/10863401.html
内容总结
以上是互联网集市为您收集整理的php实现excel单元格合并,字体加粗居中等操作全部内容,希望文章能够帮你解决php实现excel单元格合并,字体加粗居中等操作所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。