php实现excel单元格合并,字体加粗居中等操作

发布于:2021-07-26 09:53:34

使用的是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


阅读 199+

一片空白

父爱如山,不善表达。回想十多年前,总记得父亲有个宽厚的肩膀,小小的自己跨坐在上面,越过人山人海去看更广阔的天空,那个时候期望自己有一双翅膀,能够像鸟儿一样飞得高,看得远。虽然父亲有时会和自己开玩笑,但在做错事的时候会受到严厉的训斥。父亲有双粗糙的大手掌。