随笔 - 273&
文章 - 0&评论 - 34&trackbacks - 0
include 'global.php';
$ids = $_GET['ids'];
$sql = "select * from crm_cost_end where id in ( {$ids} )";
$result = $db-&findAll($sql);
//echo $result[1]['sn'];
//创建一个excel对象
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel-&getProperties()-&setCreator("ctos")
-&setLastModifiedBy("ctos")
-&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");
//set width
$objPHPExcel-&getActiveSheet()-&getColumnDimension('A')-&setWidth(8);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('B')-&setWidth(10);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('C')-&setWidth(25);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('D')-&setWidth(12);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('E')-&setWidth(50);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('F')-&setWidth(10);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('G')-&setWidth(12);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('H')-&setWidth(12);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('I')-&setWidth(12);
$objPHPExcel-&getActiveSheet()-&getColumnDimension('J')-&setWidth(30);
//设置行高度
$objPHPExcel-&getActiveSheet()-&getRowDimension('1')-&setRowHeight(22);
$objPHPExcel-&getActiveSheet()-&getRowDimension('2')-&setRowHeight(20);
//set font size bold
$objPHPExcel-&getActiveSheet()-&getDefaultStyle()-&getFont()-&setSize(10);
$objPHPExcel-&getActiveSheet()-&getStyle('A2:J2')-&getFont()-&setBold(true);
$objPHPExcel-&getActiveSheet()-&getStyle('A2:J2')-&getAlignment()-&setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel-&getActiveSheet()-&getStyle('A2:J2')-&getBorders()-&getAllBorders()-&setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//设置水平居中
$objPHPExcel-&getActiveSheet()-&getStyle('A1')-&getAlignment()-&setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel-&getActiveSheet()-&getStyle('A')-&getAlignment()-&setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel-&getActiveSheet()-&getStyle('B')-&getAlignment()-&setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel-&getActiveSheet()-&getStyle('D')-&getAlignment()-&setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel-&getActiveSheet()-&getStyle('F')-&getAlignment()-&setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel-&getActiveSheet()-&getStyle('G')-&getAlignment()-&setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel-&getActiveSheet()-&getStyle('H')-&getAlignment()-&setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel-&getActiveSheet()-&getStyle('I')-&getAlignment()-&setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel-&getActiveSheet()-&mergeCells('A1:J1');
// set table header content
$objPHPExcel-&setActiveSheetIndex(0)
-&setCellValue('A1', '订单数据汇总
时间:' . date('Y-m-d H:i:s'))
-&setCellValue('A2', '订单ID')
-&setCellValue('B2', '下单人')
-&setCellValue('C2', '客户名称')
-&setCellValue('D2', '下单时间')
-&setCellValue('E2', '需求机型')
-&setCellValue('F2', '需求数量')
-&setCellValue('G2', '需求交期')
-&setCellValue('H2', '确认BOM料号')
-&setCellValue('I2', 'PMC确认交期')
-&setCellValue('J2', 'PMC交货备注');
// Miscellaneous glyphs, UTF-8
for ($i = 0; $i & count($result) - 1; $i++) {
$objPHPExcel-&getActiveSheet(0)-&setCellValue('A' . ($i + 3), $result[$i]['id']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('B' . ($i + 3), $result[$i]['realname']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('C' . ($i + 3), $result[$i]['customer_name']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('D' . ($i + 3), $OrdersData[$i]['create_time']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('E' . ($i + 3), $result[$i]['require_product']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('F' . ($i + 3), $result[$i]['require_count']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('G' . ($i + 3), $result[$i]['require_time']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('H' . ($i + 3), $result[$i]['product_bom_encoding']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('I' . ($i + 3), $result[$i]['delivery_time']);
$objPHPExcel-&getActiveSheet(0)-&setCellValue('J' . ($i + 3), $result[$i]['delivery_memo']);
$objPHPExcel-&getActiveSheet()-&getStyle('A' . ($i + 3) . ':J' . ($i + 3))-&getAlignment()-&setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel-&getActiveSheet()-&getStyle('A' . ($i + 3) . ':J' . ($i + 3))-&getBorders()-&getAllBorders()-&setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel-&getActiveSheet()-&getRowDimension($i + 3)-&setRowHeight(16);
// Rename sheet
$objPHPExcel-&getActiveSheet()-&setTitle('订单汇总表');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel-&setActiveSheetIndex(0);
// Redirect output to a client&s web browser (Excel5)
ob_end_clean();//清除缓冲区,避免乱码
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition:filename="订单汇总表(' . date('Ymd-His') . ').xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter-&save('php://output');
在header() 前面加上ob_end_clean() 函数, 清除缓冲区, 这样就不会乱码了!
阅读(...) 评论()FCKeditor表单提交保存出现乱码解决方法-asp-电脑编程网FCKeditor表单提交保存出现乱码解决方法作者：佚名　和相关&&
最近在使用FCKeditor时发现有出现乱码 的问题,所以自己研究了下FCKeditor的代码 写下点心得体会.
FCKeditor使用：
程序代码
&!--#include file="FCKeditor/fckeditor." --&&%Dim sBasePathsBasePath = "FCKeditor/"Dim oFCKeditorSet oFCKeditor = New FCKeditoroFCKeditor.BasePath = sBasePathoFCKeditor.Config("AutoDetectLanguage") = FalseoFCKeditor.Config("DefaultLanguage") = "zh-cn"oFCKeditor.Value = contentoFCKeditor.Height = "350"oFCKeditor.Create "Content"%&页面编码为gb2312，而fck默认的是utf-8解决办法：在页头加入以下代码：
程序代码
&%OptionExplicitresponse.codepage=936response.charset="gb2312"Response.AddHeader"ragma","no-cache"Response.ContentType="text/html"Response.Expires=-1Response.Buffer=true%&
相关资料：｜｜｜｜｜｜｜FCKeditor表单提交保存出现乱码解决方法来源网络，如有侵权请告知，即处理！编程Tags：　　　　　　　　　　　　　　　　&　　　　　　　　　　　　　　　　　　　　excel表格中数字全部变成#字符乱码怎么办？
作者：佚名
字体：[ ] 来源：互联网 时间：06-15 16:07:28
excel表格中数字显示乱码全是#符号怎么办？有时候网上下载的表格中，准考证号，身份证号，日期的数值类的数据，经常会显示不出来，或者不完整。该怎么才能显示数据呢？请看下文详细设置
有时候网上下载的表格中，准考证号，身份证号，日期的数值类的数据，经常会显示不出来，或者不完整。其实并不是表格不完整，只要我们稍微设置一下就出来了。
1、如图，下载的表格，准考证号这一列完全看不到。
2、这时候选中这一列，右键点击&设置单元格格式&
3、在对话框中选择&数值&小数位数，选择&0&，点击确定。
4、完整的准考证号就出来了。
5、这时的表格看起来很乱，各种对齐方式一起存在呢。在对齐方式中选择水平居中。
6、完整又美观的表格就这样完成了。
大家感兴趣的内容
12345678910
最近更新的内容