php使用phpword生成word文档的例子

3. require_once '../libs/PHPWord/PHPWord.php';

4. require_once '../libs/PHPWord/PHPWord/IOFactory.php';
5. require_once '../../config.php';
6. // require_once '../common/conn.php';

7. // New Word Document

8. $PHPWord = new PHPWord();

9. /**********文本格式的word text.php************/

10. // New portrait section

11. //逗号 分割字符串

12. $arr = $_REQUEST['arr'];
13. $a = explode(',',$arr);
14. //echo $arr;
15. date_default_timezone_set("Asia/Shanghai");//设置一个时区
16. $tm=date('Y-m-d H:i:s');
17. //exit($tm);
18. /**********前多日雨量*********/
19. if(in_array('1', $a, TRUE)){
20. $section = $PHPWord->createSection();
21. $PHPWord->addFontStyle('rStyle', array('bold'=>false, 'italic'=>false, 'size'=>16));
22. $PHPWord->addParagraphStyle('pStyle', array('align'=>'center', 'spaceAfter'=>100));
23. $c = "前三日雨量报表";
24. $section->addText($c, 'rStyle', 'pStyle');

25. $styleTable = array('borderSize'=>6, 'borderColor'=>'006699', 'cellMargin'=>80);

26. $styleFirstRow = array('borderBottomSize'=>18, 'borderBottomColor'=>'0000FF', 'bgColor'=>'66BBFF');

27. // Define cell style arrays

28. $styleCell = array('valign'=>'center');
29. // Define font style for first row
30. $fontStyle = array('bold'=>true, 'align'=>'center');
31. //设置标题
32. $PHPWord->addFontStyle('rStyle', array('bold'=>true, 'italic'=>true, 'size'=>16));
33. $PHPWord->addParagraphStyle('pStyle', array('align'=>'center', 'spaceAfter'=>100));

34. // Add table style

35. $PHPWord->addTableStyle('myOwnTableStyle', $styleTable, $styleFirstRow);

36. // Add table

37. $table = $section->addTable('myOwnTableStyle');

38. // Add row设置行高

39. $table->addRow(500);

40. $table->addCell(2300, $styleCell)->addText('站码', $fontStyle);

41. $table->addCell(2300, $styleCell)->addText('站名', $fontStyle);
42. $table->addCell(2300, $styleCell)->addText('雨量', $fontStyle);
43. $table->addCell(2300, $styleCell)->addText('水文站监测类型', $fontStyle);

44. $conn = mssql_connect($config['mssql']['host'],$config['mssql']['user'],$config['mssql']['password']);

45. mssql_select_db($config['mssql']['dbname'],$conn);

46. $stm = date('Y-m-d H:i:s',strtotime('-3 days'));

47. $sql = "EXEC HNOW05_GETPPSPACE '','','".$stm."',1,1";
48. $res=mssql_query($sql);

49. while($arr = mssql_fetch_array($res)){

50. //echo $arr["STCD"]."";
51. $table->addRow();
52. $table->addCell(2300)->addText($arr["STCD"]);
53. $table->addCell(2300)->addText($arr["STNM"]);
54. $table->addCell(2300)->addText($arr["P"]);
55. if($arr["STTP"] == 'MM'){
56. $table->addCell(2300)->addText('气象站');
57. }else if($arr["STTP"] == 'BB'){
58. $table->addCell(2300)->addText('蒸发站');
59. }else if($arr["STTP"] == 'DD'){
60. $table->addCell(2300)->addText('堰闸水文站');
61. }else if($arr["STTP"] == 'TT'){
62. $table->addCell(2300)->addText('落潮位站');
63. }else if($arr["STTP"] == 'DP'){
64. $table->addCell(2300)->addText('泵站');
65. }else if($arr["STTP"] == 'SS'){
66. $table->addCell(2300)->addText('墒情站');
67. }else if($arr["STTP"] == 'PP'){
68. $table->addCell(2300)->addText('雨量站');
69. }else if($arr["STTP"] == 'ZZ'){
70. $table->addCell(2300)->addText('河道水位水文站');
71. }else if($arr["STTP"] == 'RR'){
72. $table->addCell(2300)->addText('水库水文站');
73. }else if($arr["STTP"] == 'ZG'){
74. $table->addCell(2300)->addText('地下水站');
75. }else if($arr["STTP"] == 'ZB'){
76. $table->addCell(2300)->addText('分洪水位站');
77. }
78. }
79. $section->addTextBreak(2);
80. }else{

81. }

82. /******地质灾害*******/

83. if(in_array('3', $a, TRUE)){
84. $section = $PHPWord->createSection();
85. $PHPWord->addFontStyle('rStyle', array('bold'=>false, 'italic'=>false, 'size'=>16));
86. $PHPWord->addParagraphStyle('pStyle', array('align'=>'center', 'spaceAfter'=>100));
87. $c = "地质灾害";
88. $section->addText($c, 'rStyle', 'pStyle');

89. $content="根据市气象局未来24小时降雨预报和市水利局实时降雨数据，市国土资源局进行了地质灾害预报，请有关部门关注

90. 实时预警信息，做好地质灾害防范工作";

91. $section->addText($content);
92. // Add image elements
93. $section->addImage("images/image001.jpg", array('width'=>600, 'height'=>480, 'align'=>'center'));
94. }else{

95. }

96. // Save File
97. $fileName = "word报表".date("YmdHis");
98. header("Content-type: application/vnd.ms-word");
99. header("Content-Disposition:attachment;filename=".$fileName.".docx");
100. header('Cache-Control: max-age=0');
101. $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007');
102. $objWriter->save('php://output');
103. ?>

复制代码