//往表格里面插入值或者打开表格填写
<%@ page language="java" import="java.util.*, java.awt.*" pageEncoding="gb2312"%>
<%@page import="com.zhuozhengsoft.pageoffice.*, com.zhuozhengsoft.pageoffice.wordwriter.*"%>
<%@ taglib uri="http://java.pageoffice.cn" prefix="po"%>
<%
//***************************卓正PageOffice组件的使用********************************
WordDocument doc = new WordDocument();
//打开数据区域
DataRegion dTable = doc.openDataRegion("PO_table");
//设置数据区域可编辑性
dTable.setEditing(true);
//打开数据区域中的表格,OpenTable(index)方法中的index为word文档中表格的下标,从1开始
Table table1 = doc.openDataRegion("PO_Table").openTable(1);
//设置表格边框样式
table1.getBorder().setLineColor(Color.green);
table1.getBorder().setLineWidth(WdLineWidth.wdLineWidth050pt);
// 设置表头单元格文本居中
table1.openCellRC(1, 2).getParagraphFormat().setAlignment(WdParagraphAlignment.wdAlignParagraphCenter);
table1.openCellRC(1, 3).getParagraphFormat().setAlignment(WdParagraphAlignment.wdAlignParagraphCenter);
table1.openCellRC(2, 1).getParagraphFormat().setAlignment(WdParagraphAlignment.wdAlignParagraphCenter);
table1.openCellRC(3, 1).getParagraphFormat().setAlignment(WdParagraphAlignment.wdAlignParagraphCenter);
// 给表头单元格赋值
table1.openCellRC(1, 2).setValue("产品1");
table1.openCellRC(1, 3).setValue("产品2");
table1.openCellRC(2, 1).setValue("A部门");
table1.openCellRC(3, 1).setValue("B部门");
PageOfficeCtrl poCtrl = new PageOfficeCtrl(request);
poCtrl.setWriter(doc);
//添加自定义按钮
poCtrl.addCustomToolButton("保存", "Save", 1);
poCtrl.addCustomToolButton("全屏/还原", "IsFullScreen", 4);
//设置服务器页面
poCtrl.setServerPage(request.getContextPath()+"/poserver.zz"); //此行必须
//设置保存页
poCtrl.setSaveDataPage("SaveData.jsp");
//设置文档打开方式
poCtrl.webOpen("doc/test.doc", OpenModeType.docSubmitForm, "张佚名");
poCtrl.setTagId("PageOfficeCtrl1");
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>数据区域提交表格</title>
<link href="p_w_picpaths/csstg.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="content">
<div id="textcontent" >
<script type="text/javascript">
//保存页面
function Save() {
document.getElementById("PageOfficeCtrl1").WebSave();
}
//全屏/还原
function IsFullScreen() {
document.getElementById("PageOfficeCtrl1").FullScreen = !document.getElementById("PageOfficeCtrl1").FullScreen;
}
</script>
<!--************** 卓正 PageOffice组件 ************************-->
<po:PageOfficeCtrl id="PageOfficeCtrl1">
</po:PageOfficeCtrl>
</div>
</div>
</body>
</html>
循环取出
<%@ page language="java"
import="java.util.*,com.zhuozhengsoft.pageoffice.*,com.zhuozhengsoft.pageoffice.wordreader.*"
pageEncoding="gb2312"%>
<%
//----------- PageOffice 服务器端编程开始 -------------------//
WordDocument doc = new WordDocument(request,response);
DataRegion dataReg = doc.openDataRegion("PO_table");
Table table = dataReg.openTable(1);
//输出提交的table中的数据
out.print("表格中的各个单元的格数据为:<br/><br/>");
StringBuilder dataStr = new StringBuilder();
for (int i = 1; i <= table.getRowsCount(); i++)
{
dataStr.append("<div style='width:220px;'>");
for (int j = 1; j <= table.getColumnsCount(); j++)
{
dataStr.append("<div style='float:left;width:70px;border:1px solid red;'>"+table.openCellRC(i,j).getValue()+"</div>");
}
dataStr.append("</div>");
}
out.print(dataStr.toString());
//向客户端显示提交的数据
doc.showPage(300, 300);
doc.close();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'SaveFile.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
</body>
</html>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。