PHPexcel数据按模板导出
2024-10-12 08:51:14
<?php
header("Content-type: text/html; charset=gb2312");
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE); define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); date_default_timezone_set('Europe/London'); /** PHPExcel_IOFactory */
require_once dirname(__FILE__) . '/../Classes/PHPExcel/IOFactory.php';
$objReader = PHPExcel_IOFactory::createReader('Excel5');
//设置模板文件
$objPHPExcel = $objReader->load("templates/bills.xls");
//将json字符串转换为数组
$billData = json_decode($_REQUEST["billData"],true);
//填充单元格
$objPHPExcel->getActiveSheet()->setCellValue('B4', $billData['party'])
->setCellValue('B5', $billData['game'])
->setCellValue('A9', $billData['month'])
->setCellValue('I28', $billData['total'])
->setCellValue('H30', $billData['partyaccount']['name'])
->setCellValue('H31', $billData['partyaccount']['bank'])
->setCellValue('H32', $billData['partyaccount']['account'])
->setCellValue('H33', $billData['partyaccount']['address'])
->setCellValue('H34', $billData['partyaccount']['contactpeople']) ->setCellValue('H35', $billData['partyaccount']['contacttel']); //循环填充相同标题单元格
$row=11;
foreach($billData['bills'] as $r => $dataRow) {
$objPHPExcel->getActiveSheet()->setCellValue('B'.$row, $dataRow['cardtype'])
->setCellValue('c'.$row, $dataRow['orderamount'])
->setCellValue('D'.$row, $dataRow['feerate'])
->setCellValue('E'.$row, $dataRow['fee'])
->setCellValue('F'.$row, $dataRow['amount'])
->setCellValue('G'.$row, $dataRow['partyratio'])
->setCellValue('H'.$row, $dataRow['partynumber'])
->setCellValue('I'.$row, $dataRow['partyamount'])
->setCellValue('J'.$row, $dataRow['memo']);
$objPHPExcel->getActiveSheet()->getStyle('c'.$row)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$row++;
} $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $str= mb_convert_encoding("out/bill_".$billData['party'].'_'.$billData['game'].'_'.$billData['month'].".xls","gb2312","UTF-8");
$objWriter->save($str);
//让访问浏览器直接下载文件流
Header("Location: /out/bill_".$billData['party'].'_'.$billData['game'].'_'.$billData['month'].".xls");
最新文章
- Hibernate的映射文件配置
- 【代码笔记】iOS-背景色随机显示
- Extjs ComboBox 动态选中第一项
- MP20 MBO issue summary
- JQuery事件手册
- 简单实用的纯CSS百分比圆形进度条插件
- js中的正则表达式入门
- 常用VI操作命令
- WPF绘制光滑连续贝塞尔曲线
- 程序员面试宝典3TH-ch7.2
- Phaser.js之简单的跑酷游戏
- Vue.js 基本功能了解一下~
- Unity3D学习笔记(三十六):Shader着色器(3)- 光照
- yarn hadoop-2.3.0 installation cluster Centos 64bits
- sqlserver不太常见的,可能常见但又疑问的tsql语句
- geoserver REST使用
- C中预编译详解
- hdu-1087(动态规划)
- 【BZOJ4006】管道连接(动态规划,斯坦纳树)
- JavaScript创建对象的4种方法
热门文章
- Canny边缘检测-Wiki
- coroutine协程
- hadoop 异常 INFO ipc.Client: Retrying connect to server:
- [BZOJ 2821] 作诗(Poetize) 【分块】
- codeforces C. Xor-tree
- Rundeck,RUN起来!!
- Linux kernel ‘key_notify_policy_flush’函数信息泄露漏洞
- sed删除文本第一个匹配行
- CMOS Sensor的调试经验分享
- (转载)遍历memcache中已缓存的key