php使用phpword產生word文檔

PHPz
發布: 2023-02-28 20:58:01
原創
28185 人瀏覽過

php使用phpword生成word文檔:

相關推薦PHPWord中文使用手冊下載

<p>
<?php
require_once &#39;../libs/PHPWord/PHPWord.php&#39;;
require_once &#39;../libs/PHPWord/PHPWord/IOFactory.php&#39;;
require_once &#39;../../config.php&#39;;
// require_once &#39;../common/conn.php&#39;;</p>
<p>// New Word Document
$PHPWord = new PHPWord();</p>
<p>/**********文本格式的word text.php************/
// New portrait section</p>
<p>//逗号 分割字符串
$arr = $_REQUEST[&#39;arr&#39;];
$a = explode(&#39;,&#39;,$arr);
//echo $arr;
date_default_timezone_set("Asia/Shanghai");//设置一个时区
$tm=date(&#39;Y-m-d H:i:s&#39;);
//exit($tm);
/**********前多日雨量*********/
if(in_array(&#39;1&#39;, $a, TRUE)){
$section = $PHPWord->createSection();
$PHPWord->addFontStyle(&#39;rStyle&#39;, array(&#39;bold&#39;=>false, &#39;italic&#39;=>false, &#39;size&#39;=>16));
$PHPWord->addParagraphStyle(&#39;pStyle&#39;, array(&#39;align&#39;=>&#39;center&#39;, &#39;spaceAfter&#39;=>100));
$c = "前三日雨量报表";
$section->addText($c, &#39;rStyle&#39;, &#39;pStyle&#39;);</p>
<p>$styleTable = array(&#39;borderSize&#39;=>6, &#39;borderColor&#39;=>&#39;006699&#39;, &#39;cellMargin&#39;=>80);
$styleFirstRow = array(&#39;borderBottomSize&#39;=>18, &#39;borderBottomColor&#39;=>&#39;0000FF&#39;, &#39;bgColor&#39;=>&#39;66BBFF&#39;);</p>
<p>// Define cell style arrays
$styleCell = array(&#39;valign&#39;=>&#39;center&#39;);
// Define font style for first row
$fontStyle = array(&#39;bold&#39;=>true, &#39;align&#39;=>&#39;center&#39;);
//设置标题
$PHPWord->addFontStyle(&#39;rStyle&#39;, array(&#39;bold&#39;=>true, &#39;italic&#39;=>true, &#39;size&#39;=>16));
$PHPWord->addParagraphStyle(&#39;pStyle&#39;, array(&#39;align&#39;=>&#39;center&#39;, &#39;spaceAfter&#39;=>100));</p>
<p>// Add table style
$PHPWord->addTableStyle(&#39;myOwnTableStyle&#39;, $styleTable, $styleFirstRow);</p>
<p>// Add table
$table = $section->addTable(&#39;myOwnTableStyle&#39;);</p>
<p>// Add row设置行高
$table->addRow(500);</p>
<p>$table->addCell(2300, $styleCell)->addText(&#39;站码&#39;, $fontStyle);
$table->addCell(2300, $styleCell)->addText(&#39;站名&#39;, $fontStyle);
$table->addCell(2300, $styleCell)->addText(&#39;雨量&#39;, $fontStyle);
$table->addCell(2300, $styleCell)->addText(&#39;水文站监测类型&#39;, $fontStyle);</p>
<p>$conn = mssql_connect($config[&#39;mssql&#39;][&#39;host&#39;],$config[&#39;mssql&#39;][&#39;user&#39;],$config[&#39;mssql&#39;][&#39;password&#39;]);
mssql_select_db($config[&#39;mssql&#39;][&#39;dbname&#39;],$conn);</p>
<p>$stm = date(&#39;Y-m-d H:i:s&#39;,strtotime(&#39;-3 days&#39;));
$sql = "EXEC HNOW05_GETPPSPACE &#39;&#39;,&#39;&#39;,&#39;".$stm."&#39;,1,1";
$res=mssql_query($sql);</p>
<p>while($arr = mssql_fetch_array($res)){
//echo $arr["STCD"]."</br>";
$table->addRow();
$table->addCell(2300)->addText($arr["STCD"]);
$table->addCell(2300)->addText($arr["STNM"]);
$table->addCell(2300)->addText($arr["P"]);
if($arr["STTP"] == &#39;MM&#39;){
$table->addCell(2300)->addText(&#39;气象站&#39;);
}else if($arr["STTP"] == &#39;BB&#39;){
$table->addCell(2300)->addText(&#39;蒸发站&#39;);
}else if($arr["STTP"] == &#39;DD&#39;){
$table->addCell(2300)->addText(&#39;堰闸水文站&#39;);
}else if($arr["STTP"] == &#39;TT&#39;){
$table->addCell(2300)->addText(&#39;落潮位站&#39;);
}else if($arr["STTP"] == &#39;DP&#39;){
$table->addCell(2300)->addText(&#39;泵站&#39;);
}else if($arr["STTP"] == &#39;SS&#39;){
$table->addCell(2300)->addText(&#39;墒情站&#39;);
}else if($arr["STTP"] == &#39;PP&#39;){
$table->addCell(2300)->addText(&#39;雨量站&#39;);
}else if($arr["STTP"] == &#39;ZZ&#39;){
$table->addCell(2300)->addText(&#39;河道水位水文站&#39;);
}else if($arr["STTP"] == &#39;RR&#39;){
$table->addCell(2300)->addText(&#39;水库水文站&#39;);
}else if($arr["STTP"] == &#39;ZG&#39;){
$table->addCell(2300)->addText(&#39;地下水站&#39;);
}else if($arr["STTP"] == &#39;ZB&#39;){
$table->addCell(2300)->addText(&#39;分洪水位站&#39;);
}
}
$section->addTextBreak(2);
}else{</p>
<p>}</p>
<p>/******地质灾害*******/
if(in_array(&#39;3&#39;, $a, TRUE)){
$section = $PHPWord->createSection();
$PHPWord->addFontStyle(&#39;rStyle&#39;, array(&#39;bold&#39;=>false, &#39;italic&#39;=>false, &#39;size&#39;=>16));
$PHPWord->addParagraphStyle(&#39;pStyle&#39;, array(&#39;align&#39;=>&#39;center&#39;, &#39;spaceAfter&#39;=>100));
$c = "地质灾害";
$section->addText($c, &#39;rStyle&#39;, &#39;pStyle&#39;);</p>
<p>$content="根据市气象局未来24小时降雨预报和市水利局实时降雨数据,市国土资源局进行了地质灾害预报,
请有关部门关注</p>
<p>实时预警信息,做好地质灾害防范工作";
$section->addText($content);
// Add image elements
$section->addImage("images/image001.jpg", array(&#39;width&#39;=>600, &#39;height&#39;=>480, &#39;align&#39;=>&#39;center&#39;));
}else{</p>
<p>}
// Save File
$fileName = "word报表".date("YmdHis");
header("Content-type: application/vnd.ms-word");
header("Content-Disposition:attachment;filename=".$fileName.".docx");
header(&#39;Cache-Control: max-age=0&#39;);
$objWriter = PHPWord_IOFactory::createWriter($PHPWord, &#39;Word2007&#39;);
$objWriter->save(&#39;php://output&#39;);
?>
</p>
登入後複製

以上就是php使用phpword產生word文件 的內容,更多相關內容請關注PHP中文網(www.php.cn)!

相關文章:

php匯出產生word的方法

在php程式中將網頁產生word文件並提供下載的實例程式碼

PHP產生word文件的三種實作方式

相關標籤:
來源:php.cn
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板