JSP PageOffice

https://github.com/zhuozhengsoft/jsp-pageoffice
Admin
JSP PageOffice is a comprehensive demonstration project showcasing how to integrate and use...
Tokens:20,744
Snippets:202
Trust Score:4.7
Update:6 months ago
Show doc for...
Tokens:
Raw
### Initiate Word to PDF Conversion

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/FileMakerPDF/Default.html

Call this function to start the Word to PDF conversion process. It shows a loading image and uses POBrowser to open a modal window for file processing.

```javascript
function convert(type) {
  document.getElementById("pgImg").style.display="block";
  POBrowser.openWindowModeless('FileMaker.jsp?type='+type , 'width=1px;height=1px;frame=no;');
}
```

--------------------------------

### Set POBrowser Header Token for Word Document

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/Token/index.html

Set the headerToken property before calling openWindowModeless. The token value must start with 'Authorization:' or 'mytoken:'.

```javascript
var mytoken="testToken";
POBrowser.headerToken = "Authorization:"+mytoken;
```

--------------------------------

### Initialize and Load Bookmarks

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/DataRegionEdit/DataRegionDlg.htm

Initializes bookmark data by checking existing bookmarks and then loads them into the UI. This function is typically called on page load.

```javascript
// 方法: window.external.CallParentFunc // 作用: 调用父窗口中的js函数, 目前只支持传递一个参数. var names = window.external.CallParentFunc("getBkNames", ""); var conts = window.external.CallParentFunc("getBkConts", ""); var bkmkArr = names.split(";"); var bkContArr = conts.split(";"); var addBkmkArr = new Array(0); var addBkmkContArr = new Array(0); //首次加载数据 function load() { pcheckBks(); searchBookMark(''); searchBookMark2(''); return; }
```

--------------------------------

### Get Word Table Data

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Extracts data from Word tables located within a data region using the OpenTable method.

```javascript
javascript:POBrowser.openWindowModeless('DataRegionTable/Default.jsp' , 'width=1200px;height=800px;');
```

--------------------------------

### Configure web.xml for PageOffice

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/README.md

Add these servlet and mapping configurations to your web.xml to enable PageOffice server-side functionality.

```xml
<!-- PageOffice Begin -->
<servlet>
	<servlet-name>poserver</servlet-name>
	<servlet-class>com.zhuozhengsoft.pageoffice.poserver.Server</servlet-class>
</servlet>
<servlet-mapping>
	<servlet-name>poserver</servlet-name>
	<url-pattern>/poserver.zz</url-pattern>
</servlet-mapping>
<servlet-mapping>
	<servlet-name>poserver</servlet-name>
	<url-pattern>/sealsetup.exe</url-pattern>
</servlet-mapping>
<servlet-mapping>
	<servlet-name>poserver</servlet-name>
	<url-pattern>/posetup.exe</url-pattern>
</servlet-mapping>
<servlet-mapping>
	<servlet-name>poserver</servlet-name>
	<url-pattern>/pageoffice.js</url-pattern>
</servlet-mapping>
<servlet-mapping>
	<servlet-name>poserver</servlet-name>
	<url-pattern>/jquery.min.js</url-pattern>
</servlet-mapping>
<servlet-mapping>
	<servlet-name>poserver</servlet-name>
	<url-pattern>/pobstyle.css</url-pattern>
</servlet-mapping>
<servlet>
	<servlet-name>adminseal</servlet-name>
	<servlet-class>com.zhuozhengsoft.pageoffice.poserver.AdminSeal</servlet-class>
</servlet>
<servlet-mapping>
	<servlet-name>adminseal</servlet-name>
	<url-pattern>/adminseal.zz</url-pattern>
</servlet-mapping>
<servlet-mapping>
	<servlet-name>adminseal</servlet-name>
	<url-pattern>/loginseal.zz</url-pattern>
</servlet-mapping>
<servlet-mapping>
	<servlet-name>adminseal</servlet-name>
	<url-pattern>/sealimage.zz</url-pattern>
</servlet-mapping>
<mime-mapping>
	<extension>mht</extension>
	<mime-type>message/rfc822</mime-type>
</mime-mapping>
<!--为了安全，强烈建议修改此密码-->
<context-param>
    <param-name>adminseal-password</param-name>
    <param-value>111111</param-value>
</context-param>
<!-- PageOffice End -->
```

--------------------------------

### webCreateNew - Create New Document

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Creates a new blank Office document instance for the user to edit.

```APIDOC
## webCreateNew - Create New Document

### Description
Creates a new Office document (Word, Excel, or PPT) with a specified version and author.

### Method
GET/POST (JSP Page Initialization)

### Parameters
#### Request Body
- **author** (String) - Required - The name of the user creating the document.
- **version** (DocumentVersion) - Required - The format version (e.g., Word2007, Excel2007).

### Request Example
```jsp
poCtrl1.webCreateNew("张佚名", DocumentVersion.Word2003);
```
```

--------------------------------

### Create New Word Document

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Demonstrates creating new documents using file copying or the WebCreateNew method.

```jsp
CreateWord/word-lists.jsp
```

--------------------------------

### Add Text Watermark to Word Document

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

This JSP example demonstrates how to add a text watermark to a Word document using the WaterMark property of the WordDocument object in PageOffice. Ensure the 'doc/test.doc' file exists.

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         import="com.zhuozhengsoft.pageoffice.wordwriter.WordDocument"
         pageEncoding="utf-8" %>
<% 
    PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
    poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");

    WordDocument doc = new WordDocument();

    // 添加水印，设置水印内容
    doc.getWaterMark().setText("PageOffice开发平台");

    poCtrl1.setWriter(doc);
    poCtrl1.webOpen("doc/test.doc", OpenModeType.docNormalEdit, "张三");
%>
```

```html
<div style="width:auto; height:700px;">
    <%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
</div>
```

--------------------------------

### Initialize PageOffice Controller

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/README.md

Instantiate the PageOfficeCtrl object and configure the server and save pages within your JSP.

```java
<%
  PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request); 
  poCtrl1.setServerPage("poserver.zz"); //此行必须
  poCtrl1.setSaveFilePage("savefile.jsp");//如要保存文件，此行必须
  //打开文件
  poCtrl1.webOpen("doc/test.doc", OpenModeType.docNormalEdit, "张三");
%>
```

--------------------------------

### Initialize and Configure PDFCtrl for Online Viewing

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Initializes the PDFCtrl object, sets the server page, and adds custom toolbar buttons for PDF viewing. Use this to enable features like printing, bookmark management, page navigation, and rotation.

```jsp
<%@ page language="java" import="com.zhuozhengsoft.pageoffice.PDFCtrl" pageEncoding="utf-8" %>
<%
    PDFCtrl pdfCtrl1 = new PDFCtrl(request);
    pdfCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");

    // 添加自定义工具栏按钮
    pdfCtrl1.addCustomToolButton("打印", "PrintFile()", 6);
    pdfCtrl1.addCustomToolButton("隐藏/显示书签", "SetBookmarks()", 0);
    pdfCtrl1.addCustomToolButton("-", "", 0); // 分隔符
    pdfCtrl1.addCustomToolButton("实际大小", "SetPageReal()", 16);
    pdfCtrl1.addCustomToolButton("适合页面", "SetPageFit()", 17);
    pdfCtrl1.addCustomToolButton("适合宽度", "SetPageWidth()", 18);
    pdfCtrl1.addCustomToolButton("-", "", 0);
    pdfCtrl1.addCustomToolButton("首页", "FirstPage()", 8);
    pdfCtrl1.addCustomToolButton("上一页", "PreviousPage()", 9);
    pdfCtrl1.addCustomToolButton("下一页", "NextPage()", 10);
    pdfCtrl1.addCustomToolButton("尾页", "LastPage()", 11);
    pdfCtrl1.addCustomToolButton("-", "", 0);
    pdfCtrl1.addCustomToolButton("向左旋转90度", "SetRotateLeft()", 12);
    pdfCtrl1.addCustomToolButton("向右旋转90度", "SetRotateRight()", 13);

    // 打开PDF文件
    pdfCtrl1.webOpen("doc/test.pdf");
%>
```

--------------------------------

### Create New Office Document with webCreateNew

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Initializes a new document session using webCreateNew and includes a client-side validation hook before saving.

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.DocumentVersion,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<%
    PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
    poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");

    // 设置保存前验证事件
    poCtrl1.setJsFunction_BeforeDocumentSaved("BeforeDocumentSaved()");

    // 设置保存页面
    poCtrl1.setSaveFilePage("SaveNewFile.jsp");

    // 新建Word文件（操作人, 文档版本）
    // DocumentVersion: Word2003, Word2007, Excel2003, Excel2007, PPT2003, PPT2007
    poCtrl1.webCreateNew("张佚名", DocumentVersion.Word2003);
%>

<!DOCTYPE HTML>
<html>
<head>
    <script type="text/javascript">
        function Save() {
            document.getElementById("PageOfficeCtrl1").WebSave();
            if (document.getElementById("PageOfficeCtrl1").CustomSaveResult == "ok") {
                alert('保存成功！');
                window.external.close(); // 关闭POBrowser窗口
            }
        }

        function BeforeDocumentSaved() {
            var subject = document.getElementById("FileSubject").value;
            if (subject.length <= 0) {
                document.getElementById("PageOfficeCtrl1").Alert("请输入文档主题");
                return false; // 阻止保存
            }
            return true; // 允许保存
        }
    </script>
</head>
<body>
    文档主题：<input name="FileSubject" id="FileSubject" type="text"/>
    <input type="button" onclick="Save()" value="保存并关闭"/>
    <%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
</body>
</html>
```

--------------------------------

### Configure External Seal Database

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/README.md

Add these parameters to web.xml to connect to an external database like Oracle for seal storage.

```xml
<context-param>
  <param-name>posealdb-driver</param-name>
  <param-value>oracle.jdbc.driver.OracleDriver</param-value>
</context-param>
<context-param>
  <param-name>posealdb-url</param-name>
  <param-value>jdbc:oracle:thin:@192.168.0.1:1521:orcl</param-value>
</context-param>
<context-param>
  <param-name>posealdb-username</param-name>
  <param-value>system</param-value>
</context-param>
<!-- 为了安全，强烈建议修改此密码--> 
<context-param>
  <param-name>posealdb-password</param-name>
  <param-value>111111</param-value>
</context-param>
```

--------------------------------

### Initialize PageOfficeCtrl for Document Editing

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Configures the PageOffice controller to open an existing Word document with custom toolbars and buttons. Requires the server page to be set and the control to be rendered in the HTML body.

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<%
    // 创建PageOffice控制器实例
    PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);

    // 设置服务器页面（必须）
    poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");

    // 设置页面显示标题
    poCtrl1.setCaption("演示：在线编辑Word文档");

    // 隐藏Office工具条
    poCtrl1.setOfficeToolbars(false);

    // 隐藏菜单栏
    poCtrl1.setMenubar(false);

    // 隐藏自定义工具栏
    poCtrl1.setCustomToolbar(false);

    // 添加自定义按钮（按钮名称, JS函数名, 图标索引）
    poCtrl1.addCustomToolButton("保存", "Save()", 1);
    poCtrl1.addCustomToolButton("打印", "PrintFile()", 6);
    poCtrl1.addCustomToolButton("全屏/还原", "IsFullScreen()", 4);

    // 设置保存文件页面
    poCtrl1.setSaveFilePage("SaveFile.jsp");

    // 打开Word文件（文件路径, 打开模式, 用户名）
    // OpenModeType: docNormalEdit(普通编辑), docReadOnly(只读), docRevisionOnly(强制留痕)
    poCtrl1.webOpen("doc/test.doc", OpenModeType.docNormalEdit, "张三");
%>

<!DOCTYPE HTML>
<html>
<head>
    <title>在线编辑Word文档</title>
    <script type="text/javascript">
        // 保存文档
        function Save() {
            document.getElementById("PageOfficeCtrl1").WebSave();
            if (document.getElementById("PageOfficeCtrl1").CustomSaveResult == "ok") {
                alert('保存成功！');
            }
        }

        // 打印文档
        function PrintFile() {
            document.getElementById("PageOfficeCtrl1").ShowDialog(4);
        }

        // 全屏切换
        function IsFullScreen() {
            document.getElementById("PageOfficeCtrl1").FullScreen = !document.getElementById("PageOfficeCtrl1").FullScreen;
        }
    </script>
</head>
<body>
<div style="width: auto; height: 700px;">
    <%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
</div>
</body>
</html>
```

--------------------------------

### Handle Word Generation and Post-Processing

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/FileMakerSingle/Default.html

Functions to manage the UI state during file generation and handle the resulting file via download or modal window.

```javascript
function myFunc(type){ alert("文件生成成功！"); document.getElementById("pgImg").style.display="none"; if("1"==type){ //下载生成的pdf文件 location.href="DownWord.jsp"; }else if("2"==type){ //打开pdf文件 POBrowser.openWindowModeless('OpenWord.jsp' , 'width=1200px;height=800px;'); } }
```

```javascript
function convert(type) { document.getElementById("pgImg").style.display="block"; POBrowser.openWindowModeless('FileMakerSingle.jsp?type='+type , 'width=1px;height=1px;frame=no;'); }
```

--------------------------------

### Load Right Data List (Added Bookmarks)

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/DataRegionEdit/DataRegionDlg.htm

Populates the right-side table with bookmarks that have been added. It supports filtering and provides 'Locate' and 'Delete' actions for each added bookmark.

```javascript
//加载右侧数据列表 function searchBookMark2(s) { //删除所有行 var tb1 = document.getElementById("bkmkTable2"); var rCount = tb1.rows.length; for (var i = 0; i < rCount; i++) { tb1.deleteRow(0); } var oTable = document.getElementById("bkmkTable2"); if (addBkmkArr != null) { for (var i = 0; i < addBkmkArr.length; i++) { if (addBkmkArr[i] != null && 0 == addBkmkArr[i].toLocaleLowerCase().indexOf(s.toLocaleLowerCase()) && "" != addBkmkArr[i]) { var oTr = oTable.insertRow(); var oTd = oTr.insertCell(); oTd.innerHTML = addBkmkArr[i]; oTd = oTr.insertCell(); oTd.innerHTML = addBkmkContArr[i]; oTd = oTr.insertCell(); oTd.innerHTML = "&nbsp;&nbsp;<a href=\"javascript:void(0);\" onclick= \"locate('PO	" + addBkmkArr[i] + "')\">\&nbsp;定位</a>"; oTd = oTr.insertCell(); oTd.innerHTML = "&nbsp;&nbsp;<a href=\"javascript:void(0);\" onclick= \"del('" + addBkmkArr[i] + "','" + addBkmkContArr[i] + "')\">\&nbsp;删除</a>"; } } } }
```

--------------------------------

### Manage POBrowser Windows

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Demonstrates opening Office documents in independent browser windows using POBrowser. Requires the pageoffice.js library to be included.

```html
<!-- 在HTML页面中使用POBrowser打开文档 -->
<!DOCTYPE HTML>
<html>
<head>
    <title>PageOffice示例</title>
    <!-- 必须引用pageoffice.js -->
    <script type="text/javascript" src="pageoffice.js"></script>
</head>
<body>
<script type="text/javascript">
    // 以非模态窗口打开文档
    function openDoc() {
        POBrowser.openWindowModeless('Word.jsp', 'width=1200px;height=800px;');
    }

    // 以全屏方式打开文档
    function openDocFullScreen() {
        POBrowser.openWindowModeless('Word.jsp', 'fullscreen=yes;');
    }

    // 以模态窗口打开（已过时，不推荐）
    function openDocModal() {
        POBrowser.openWindow('Word.jsp', 'width=1200px;height=800px;');
    }

    // 传递参数给子页面
    function openDocWithParam() {
        POBrowser.openWindowModeless('Word.jsp', 'width=1200px;height=800px;', encodeURI('张三'));
    }

    // 隐藏边框打开
    function openDocNoFrame() {
        POBrowser.openWindowModeless('Word.jsp', 'left=10px;top=10px;width=780px;height=900px;frame=no;');
    }
</script>

<button onclick="openDoc()">打开Word文档</button>
<button onclick="openDocFullScreen()">全屏打开</button>
<button onclick="openDocWithParam()">带参数打开</button>
</body>
</html>
```

```jsp
<!-- Word.jsp - 子页面调用父页面函数 -->
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<%
    PageOfficeCtrl poCtrl = new PageOfficeCtrl(request);
    poCtrl.setServerPage(request.getContextPath() + "/poserver.zz");
    poCtrl.addCustomToolButton("保存", "Save()", 1);
    poCtrl.addCustomToolButton("关闭", "CloseFile()", 21);
    poCtrl.setSaveFilePage("SaveFile.jsp");
    poCtrl.webOpen("doc/test.doc", OpenModeType.docNormalEdit, "张佚名");
%>

<body>
<script type="text/javascript">
    function Save() {
        document.getElementById("PageOfficeCtrl1").WebSave();
        if (document.getElementById("PageOfficeCtrl1").CustomSaveResult == "ok") {
            // 调用父页面的函数
            if (window.external.CallParentFunc("refreshList()") == 'poerror:parentlost') {
                alert('父页面已关闭！');
            }
        }
    }

    function CloseFile() {
        // 关闭POBrowser窗口
        window.external.close();
    }
</script>
<%=poCtrl.getHtmlCode("PageOfficeCtrl1")%>
</body>
```

--------------------------------

### Initialize PageOffice Control for Streaming

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Configures the PageOfficeCtrl to open a document via a streaming URL and defines the save callback.

```jsp
<!-- Stream.jsp - 打开数据库中的文档 -->
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<%
    PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
    poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");
    poCtrl1.setMenubar(false);
    poCtrl1.addCustomToolButton("保存", "Save()", 1);
    poCtrl1.setSaveFilePage("SaveFile.jsp?id=1");

    // 通过流式页面打开数据库中的文档
    poCtrl1.webOpen("Openstream.jsp?id=1", OpenModeType.docNormalEdit, "张三");
%>

<body>
<script type="text/javascript">
    function Save() {
        document.getElementById("PageOfficeCtrl1").WebSave();
        if (document.getElementById("PageOfficeCtrl1").CustomSaveResult == "ok") {
            document.getElementById("PageOfficeCtrl1").Alert('保存成功！');
        }
    }
</script>
<%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
</body>
```

--------------------------------

### Load Left Data List (Bookmarks)

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/DataRegionEdit/DataRegionDlg.htm

Populates the left-side table with bookmarks from the document. It supports filtering based on user input and provides an 'Add' action for each bookmark.

```javascript
//加载左侧数据列表 function searchBookMark(s) { //删除所有行 var tb1 = document.getElementById("bkmkTable"); var rCount = tb1.rows.length; for (var i = 0; i < rCount; i++) { tb1.deleteRow(0); } var oTable = document.getElementById("bkmkTable"); for (var i = 0; i < bkmkArr.length; i++) { if (bkmkArr[i] != null && bkmkArr[i] != "" && 0 == bkmkArr[i].toLocaleLowerCase().indexOf(s.toLocaleLowerCase())) { var oTr = oTable.insertRow(); var oTd = oTr.insertCell(); oTd.innerHTML = bkmkArr[i]; oTd = oTr.insertCell(); oTd.innerHTML = bkContArr[i]; oTd = oTr.insertCell(); oTd.innerHTML = "&nbsp;&nbsp;<a href=\"javascript:void(0);\" onclick= \"add('" + bkmkArr[i] + "','" + bkContArr[i] + "')\">\&nbsp;添加</a>"; } } }
```

--------------------------------

### PageOfficeCtrl - Initialize Document

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Initializes the PageOffice control to open an existing Office document for editing or viewing.

```APIDOC
## PageOfficeCtrl - Initialize Document

### Description
Initializes the PageOffice control, configures UI elements like toolbars and custom buttons, and opens a specified document.

### Method
GET/POST (JSP Page Initialization)

### Parameters
#### Request Body
- **request** (HttpServletRequest) - Required - The current HTTP request object.

### Request Example
```jsp
// Initialize control
PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");
poCtrl1.webOpen("doc/test.doc", OpenModeType.docNormalEdit, "张三");
```

### Response
#### Success Response (200)
- **HTML/JS** (String) - Returns the HTML code required to render the PageOffice control in the browser.
```

--------------------------------

### Initialize PageOfficeCtrl for Word Editing and PDF Conversion

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Initializes the PageOfficeCtrl object, sets the server page, and configures custom toolbars for saving and converting Word documents to PDF. It also specifies the page to handle file saving.

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<% 
    PageOfficeCtrl pocCtrl = new PageOfficeCtrl(request);
    pocCtrl.setServerPage(request.getContextPath() + "/poserver.zz");

    pocCtrl.addCustomToolButton("保存", "Save()", 1);
    pocCtrl.addCustomToolButton("另存为PDF文件", "SaveAsPDF()", 1);
    pocCtrl.setSaveFilePage("SaveFile.jsp");

    String fileName = "template.doc";
    String pdfName = fileName.substring(0, fileName.length() - 4) + ".pdf";

    pocCtrl.webOpen("doc/" + fileName, OpenModeType.docNormalEdit, "张佚名");
%>
```

--------------------------------

### Convert Word to PDF and Download

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/FileMakerPDF/Default.html

Use this function to convert a Word document to PDF and then download the generated PDF file. It displays a loading indicator during the conversion process.

```javascript
function myFunc(type){
  alert("转换完成！");
  document.getElementById("pgImg").style.display="none";
  if("1"==type){
    //下载生成的pdf文件
    location.href="DownPDF.jsp";
  }else if("2"==type){
    //打开pdf文件
    POBrowser.openWindowModeless('OpenPDF.jsp' , 'width=1200px;height=800px;');
  }
}
```

--------------------------------

### Convert Office to PDF

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Converts an opened Word document to PDF format on the server.

```javascript
javascript:POBrowser.openWindowModeless('SaveAsPDF/WordToPDF.jsp' , 'width=1200px;height=800px;');
```

--------------------------------

### Open PDF File Online

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Opens a PDF file using the POPDF component with configurable UI elements.

```javascript
javascript:POBrowser.openWindowModeless('POPDF/PDF.jsp' , 'width=1050px;height=900px;');
```

--------------------------------

### Open PageOffice Window via POBrowser

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Opens a document window using the POBrowser modeless method for cross-browser compatibility.

```javascript
POBrowser.openWindowModeless('HtmlWord/index.html' , 'width=1200px;height=800px;');
```

```javascript
POBrowser.openWindowModeless('PromptSave/Word.jsp' , 'width=1200px;height=800px;');
```

```javascript
POBrowser.openWindowModeless('OpenWindowModeless/Word.jsp' , 'width=1200px;height=800px;');
```

```javascript
POBrowser.openWindowModeless('GetParentParamValue/Word.jsp' , 'width=1200px;height=800px;',encodeURI('张三'));
```

--------------------------------

### Render PageOffice HTML

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/README.md

Insert this code into the body of your HTML to display the office interface.

```jsp
<%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
```

--------------------------------

### Open Modal PageOffice Window

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Opens a document window using a modal dialog. Note that this method is deprecated and not recommended.

```javascript
POBrowser.openWindow('OpenWindow/Word.jsp' , 'width=1200px;height=800px;');
```

--------------------------------

### 使用 Workbook 操作 Excel 单元格

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

通过 Workbook 和 Sheet 对象打开 Excel 工作表，并对指定单元格进行赋值和格式化处理。

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<%@ page import="com.zhuozhengsoft.pageoffice.excelwriter.Cell" %>
<%@ page import="com.zhuozhengsoft.pageoffice.excelwriter.Sheet" %>
<%@ page import="com.zhuozhengsoft.pageoffice.excelwriter.Workbook" %>
<%@ page import="java.text.DecimalFormat,java.text.NumberFormat" %>
<%
    PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
    poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");
    poCtrl1.setCaption("Excel数据填充示例");

    // 定义Workbook对象
    Workbook workBook = new Workbook();

    // 打开工作表（Sheet名称）
    Sheet sheet = workBook.openSheet("Sheet1");

    // 打开单元格并赋值
    Cell cellB4 = sheet.openCell("B4");
    cellB4.setValue("1月");

    Cell cellC4 = sheet.openCell("C4");
    cellC4.setValue("300");

    Cell cellD4 = sheet.openCell("D4");
    cellD4.setValue("270");

    Cell cellE4 = sheet.openCell("E4");
    cellE4.setValue("270");

    // 计算百分比
    Cell cellF4 = sheet.openCell("F4");
    DecimalFormat df = (DecimalFormat) NumberFormat.getInstance();
    cellF4.setValue(df.format(270.00 / 300 * 100) + "%");

    // 关联Workbook对象
    poCtrl1.setWriter(workBook);
    poCtrl1.setMenubar(false);
    poCtrl1.setCustomToolbar(false);

    // 打开Excel文件
    poCtrl1.webOpen("doc/test.xls", OpenModeType.xlsNormalEdit, "张三");
%>

<body>
<div style="width: auto; height: 700px;">
    <%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
</div>
</body>
```

--------------------------------

### Fill Data Using DataTag

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Populates Word templates using DataTags to fill multiple locations with the same data.

```javascript
javascript:POBrowser.openWindowModeless('WordDataTag/DataTag.jsp' , 'width=1200px;height=800px;');
```

--------------------------------

### Add Bookmark Functionality

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/DataRegionEdit/DataRegionDlg.htm

Adds a bookmark to the document using the 'addBookMark' function provided by the external interface. It checks for success before updating local arrays.

```javascript
//***** 书签操作 ******** function add(name, content) { if ("true" == window.external.CallParentFunc("addBookMark", "PO_" + name + "=" + content)) { var start = 0; for (var i = 0; i < bkmkArr.length; i++) { if (bkmkArr[i] == name) { start = i; } } addBkmkArr.splice(0, 0, name); //向数组第一个位置（0坐标处）添加一个元素 addBkmkContAr
```

--------------------------------

### Open Word document via POBrowser

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/CallParentFunction/index.html

Opens a modeless window for a Word document using the POBrowser API.

```javascript
POBrowser.openWindowModeless('Word.jsp?id=123', 'width=1200px;height=800px;scroll=no;');
```

--------------------------------

### Implement Revision Tracking with PageOffice

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Uses the Document.Revisions object to list, identify, and navigate to specific document changes. Requires the PageOfficeCtrl to be initialized in docRevisionOnly mode.

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<%
    PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
    poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");

    // 文档打开后触发的事件
    poCtrl1.setJsFunction_AfterDocumentOpened("AfterDocumentOpened()");
    poCtrl1.addCustomToolButton("保存", "Save()", 1);
    poCtrl1.setOfficeToolbars(false);
    poCtrl1.setSaveFilePage("SaveFile.jsp");

    // 以强制留痕模式打开
    poCtrl1.webOpen("doc/test.doc", OpenModeType.docRevisionOnly, "Tom");
%>

<body>
<script type="text/javascript">
    function Save() {
        document.getElementById("PageOfficeCtrl1").WebSave();
    }

    function AfterDocumentOpened() {
        refreshList();
    }

    // 获取并显示痕迹列表
    function refreshList() {
        document.getElementById("ul_Comments").innerHTML = "";
        var revCount = document.getElementById("PageOfficeCtrl1").Document.Revisions.Count;

        for (var i = 1; i <= revCount; i++) {
            var revision = document.getElementById("PageOfficeCtrl1").Document.Revisions.Item(i);
            var str = revision.Author + " " + revision.Date;

            // Type: 1=插入, 2=删除, 其他=格式调整
            if (revision.Type == "1") {
                str += ' 插入：' + revision.Range.Text;
            } else if (revision.Type == "2") {
                str += ' 删除：' + revision.Range.Text;
            } else {
                str += ' 调整格式或样式。';
            }

            document.getElementById("ul_Comments").innerHTML +=
                "<li><a href='#' onclick='goToRevision(" + i + ")'>" + str + "</a></li>";
        }
    }

    // 定位到指定痕迹
    function goToRevision(index) {
        document.getElementById("PageOfficeCtrl1").Document.Revisions.Item(index).Range.Select();
    }
</script>

<div style="float:left; width:200px; height:700px; border:solid 1px red;">
    <h3>痕迹列表</h3>
    <input type="button" value="刷新" onclick="refreshList()"/>
    <ul id="ul_Comments"></ul>
</div>
<div style="width:1050px; height:700px; float:right;">
    <%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
</div>
</body>
```

--------------------------------

### Include PageOffice JavaScript

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/README.md

Reference the pageoffice.js file in your page to enable POBrowser functionality.

```html
<script type="text/javascript" src="/pageoffice.js"></script>
```

--------------------------------

### 使用 Table 填充定义名称区域

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

利用 openTableByDefinedName 方法打开 Excel 定义名称区域，并通过循环填充数据及自动行增长。

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<%@ page import="com.zhuozhengsoft.pageoffice.excelwriter.Sheet" %>
<%@ page import="com.zhuozhengsoft.pageoffice.excelwriter.Table" %>
<%@ page import="com.zhuozhengsoft.pageoffice.excelwriter.Workbook" %>
<%
    PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
    poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");

    Workbook workBook = new Workbook();
    Sheet sheet = workBook.openSheet("Sheet1");

    // 打开定义名称的区域（名称, 行数, 列数, 是否自动增长）
    Table table = sheet.openTableByDefinedName("report", 10, 5, false);

    // 循环填充多行数据
    for (int i = 0; i < 5; i++) {
        table.getDataFields().get(0).setValue("产品" + (i + 1));
        table.getDataFields().get(1).setValue(String.valueOf(100 + i * 10));
        table.getDataFields().get(2).setValue(String.valueOf(120 + i * 10));
        table.getDataFields().get(3).setValue(String.valueOf(500 + i * 50));
        table.getDataFields().get(4).setValue("120%");
        table.nextRow(); // 移动到下一行
    }
    table.close();

    poCtrl1.setWriter(workBook);
    poCtrl1.setSaveDataPage("SaveData.jsp");
    poCtrl1.addCustomToolButton("保存", "Save()", 1);
    poCtrl1.webOpen("doc/test.xls", OpenModeType.xlsSubmitForm, "张三");
%>

<body>
<script type="text/javascript">
    function Save() {
        document.getElementById("PageOfficeCtrl1").WebSave();
    }
</script>
<div style="width: 1000px; height: 800px;">
    <%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
</div>
</body>
```

--------------------------------

### Fill Word Data Regions

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Use WordDocument to populate pre-defined data regions in a Word template. Data regions must be named with the 'PO_' prefix in the template.

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.OpenModeType,com.zhuozhengsoft.pageoffice.PageOfficeCtrl"
         pageEncoding="utf-8" %>
<%@ page import="com.zhuozhengsoft.pageoffice.wordwriter.DataRegion" %>
<%@ page import="com.zhuozhengsoft.pageoffice.wordwriter.WordDocument" %>
<%
    // 创建WordDocument对象
    WordDocument doc = new WordDocument();

    // 打开数据区域并赋值（数据区域名称格式：PO_xxx）
    DataRegion dataRegion1 = doc.openDataRegion("PO_userName");
    dataRegion1.setValue("张三");

    DataRegion dataRegion2 = doc.openDataRegion("PO_deptName");
    dataRegion2.setValue("销售部");

    DataRegion dataRegion3 = doc.openDataRegion("PO_date");
    dataRegion3.setValue("2024-01-15");

    // 设置数据区域可编辑性
    dataRegion1.setEditing(false); // 禁止编辑
    dataRegion2.setEditing(true);  // 允许编辑

    // 创建PageOffice控制器
    PageOfficeCtrl poCtrl1 = new PageOfficeCtrl(request);
    poCtrl1.setServerPage(request.getContextPath() + "/poserver.zz");

    // 关联WordDocument对象
    poCtrl1.setWriter(doc);

    // 打开Word文件
    poCtrl1.webOpen("doc/test.doc", OpenModeType.docNormalEdit, "张三");
%>

<body>
<div style="width: auto; height: 700px;">
    <%=poCtrl1.getHtmlCode("PageOfficeCtrl1")%>
</div>
</body>
```

--------------------------------

### Read Document Stream from Database

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Retrieves a document as a binary stream from a database BLOB field and writes it to the HTTP response.

```jsp
<!-- Openstream.jsp - 从数据库读取文档流 -->
<%@ page language="java"
         import="java.io.OutputStream,java.sql.Connection,java.sql.DriverManager,java.sql.ResultSet,java.sql.Statement"
         pageEncoding="utf-8" %>
<%
    String id = request.getParameter("id");
    if (id == null) id = "1";

    Class.forName("org.sqlite.JDBC");
    String strUrl = "jdbc:sqlite:" + this.getServletContext().getRealPath("demodata/DataBase.db");
    Connection conn = DriverManager.getConnection(strUrl);
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select * from stream where id = " + id);

    if (rs.next()) {
        byte[] fileBytes = rs.getBytes("Word");
        int fileSize = fileBytes.length;

        response.reset();
        response.setContentType("application/msword");
        response.setHeader("Content-Disposition", "attachment; filename=document.doc");
        response.setContentLength(fileSize);

        OutputStream outputStream = response.getOutputStream();
        outputStream.write(fileBytes);
        outputStream.flush();
        outputStream.close();
    }

    rs.close();
    conn.close();
%>
```

--------------------------------

### Import PageOffice in JSP

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/README.md

Include this directive at the top of your JSP files to access PageOffice classes.

```jsp
<%@ page language="java" import="com.zhuozhengsoft.pageoffice.*" %>
```

--------------------------------

### Open Word Document in Modaless Window with POBrowser

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/Token/index.html

Use the openWindowModeless method to open a Word document in a non-blocking window. Specify the JSP page and window dimensions.

```javascript
POBrowser.openWindowModeless	('Word.jsp', 'width=1200px;height=800px;'	);
```

--------------------------------

### Run Macro in Document

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Executes macros embedded within an Office document using the RunMacro method.

```javascript
javascript:POBrowser.openWindowModeless('RunMacro/Word.jsp' , 'width=1200px;height=800px;');
```

--------------------------------

### Dynamically Create Data Region

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Uses the CreateDataRegion method to add data regions at runtime for flexible document generation.

```javascript
javascript:POBrowser.openWindowModeless('DataRegionCreate/DataRegionCreate.jsp' , 'width=1200px;height=800px;');
```

--------------------------------

### FileMaker Single Document Conversion

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/index.html

Generates files on the server using the FileMaker object without opening the document in the client UI.

```html
FileMakerSingle/Default.html
```

--------------------------------

### Delete and Locate Bookmarks

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/DataRegionEdit/DataRegionDlg.htm

Functions to remove bookmarks from arrays and trigger parent window actions, and to navigate to a specific bookmark.

```javascript
r.splice(0, 0, content); bkmkArr.splice(start, 1); //删除数组中相应坐标处的一个元素 bkContArr.splice(start, 1); searchBookMark(''); searchBookMark2(''); } } function del(name, cont) { if ("true" == window.external.CallParentFunc("delBookMark", "PO_" + name)) { var start = 0; for (var i = 0; i < addBkmkArr.length; i++) { if (addBkmkArr[i] == name) { start = i; } } bkmkArr.splice(0, 0, name); bkContArr.splice(0, 0, cont); addBkmkArr.splice(start, 1); addBkmkContArr.splice(start, 1); searchBookMark(''); searchBookMark2(''); } else { alert(0) } } function locate(bkName) { window.external.CallParentFunc("locateBK", bkName); }
```

```javascript
load(); //alert(2);
```

--------------------------------

### Button Click Handler for Right Table Search

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/DataRegionEdit/DataRegionDlg.htm

Handles the click event for a button that filters the right-side table of added bookmarks based on user input. It reloads the table with matching added bookmarks.

```javascript
function Button2_onclick() { var s = document.getElementById("Text2").value.toLocaleLowerCase(); var tb1 = document.getElementById("bkmkTable2"); var rCount = tb1.rows.length; for (var i = 0; i < rCount; i++) { tb1.deleteRow(0); } var oTable = document.getElementById("bkmkTable2"); if (addBkmkArr != null) { for (var i = 0; i < addBkmkArr.length; i++) { if (addBkmkArr[i] != null && addBkmkArr[i].toLocaleLowerCase().indexOf(s) >= 0 && "" != addBkmkArr[i]) { var oTr = oTable.insertRow(); var oTd = oTr.insertCell(); oTd.innerHTML = addBkmkArr[i]; oTd = oTr.insertCell(); oTd.innerHTML = addBkmkContArr[i]; oTd = oTr.insertCell(); oTd.innerHTML = "&nbsp;&nbsp;<a href=\"javascript:void(0);\" onclick= \"locate('PO	" + addBkmkArr[i] + "')\">\&nbsp;定位</a>"; oTd = oTr.insertCell(); oTd.innerHTML = "&nbsp;&nbsp;<a href=\"javascript:void(0);\" onclick= \"del('" + addBkmkArr[i] + "','" + addBkmkContArr[i] + "')\">\&nbsp;删除</a>"; } } } }
```

--------------------------------

### Button Click Handler for Left Table Search

Source: https://github.com/zhuozhengsoft/jsp-pageoffice/blob/main/DataRegionEdit/DataRegionDlg.htm

Handles the click event for a button that filters the left-side bookmark table based on user input from a text field. It reloads the table with matching bookmarks.

```javascript
function Button1_onclick() { var s = document.getElementById("Text1").value.toLocaleLowerCase(); var tb1 = document.getElementById("bkmkTable"); var rCount = tb1.rows.length; for (var i = 0; i < rCount; i++) { tb1.deleteRow(0); } var oTable = document.getElementById("bkmkTable"); for (var i = 0; i < bkmkArr.length; i++) { if (bkmkArr[i] != null && bkmkArr[i] != "" && bkmkArr[i].toLocaleLowerCase().indexOf(s) >= 0) { var oTr = oTable.insertRow(); var oTd = oTr.insertCell(); oTd.innerHTML = bkmkArr[i]; oTd = oTr.insertCell(); oTd.innerHTML = bkContArr[i]; oTd = oTr.insertCell(); oTd.innerHTML = "&nbsp;&nbsp;<a href=\"javascript:void(0);\" onclick= \"add('" + bkmkArr[i] + "','" + bkContArr[i] + "')\">\&nbsp;添加</a>"; } } }
```

--------------------------------

### Handle File Saving with FileSaver

Source: https://context7.com/zhuozhengsoft/jsp-pageoffice/llms.txt

Processes incoming document data on the server side, allowing for disk storage and custom result feedback to the client.

```jsp
<%@ page language="java"
         import="com.zhuozhengsoft.pageoffice.FileSaver"
         pageEncoding="utf-8" %>
<%
    // 创建FileSaver实例
    FileSaver fs = new FileSaver(request, response);

    // 获取文件名
    String fileName = fs.getFileName();

    // 获取文件大小
    int fileSize = fs.getFileSize();

    // 获取文件字节数组（用于保存到数据库）
    byte[] fileBytes = fs.getFileBytes();

    // 保存到服务器磁盘
    String savePath = request.getSession().getServletContext().getRealPath("doc/") + "/" + fileName;
    fs.saveToFile(savePath);

    // 设置自定义保存结果，返回给前端
    fs.setCustomSaveResult("ok");

    // 关闭FileSaver
    fs.close();
%>
```
Tokens:
Raw