package?com.demo.action;

import?java.awt.Color;

import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?org.apache.struts2.ServletActionContext;
import?org.apache.struts2.interceptor.ServletRequestAware;
import?org.apache.struts2.interceptor.ServletResponseAware;

import?com.opensymphony.xwork2.ActionSupport;
import?com.zhuozhengsoft.pageoffice.BorderstyleType;
import?com.zhuozhengsoft.pageoffice.FileSaver;
import?com.zhuozhengsoft.pageoffice.OpenModeType;
import?com.zhuozhengsoft.pageoffice.PageOfficeCtrl;
import?com.zhuozhengsoft.pageoffice.excelwriter.Cell;
import?com.zhuozhengsoft.pageoffice.excelwriter.Sheet;
import?com.zhuozhengsoft.pageoffice.excelwriter.Workbook;

/**
?*?
?*?@ClassName:?ExcelDemo
?*?@Description:?TODO
?*?@author?vivid
?*?@date?2016-3-24?下午1:22:55
?*?
?*/
@SuppressWarnings（“serial“）
public?class?ExcelDemo?extends?ActionSupport?implements?ServletRequestAware
		ServletResponseAware?{

	private?HttpServletRequest?request;
	private?HttpServletResponse?response;
	private?String?message?=?““;

	public?void?setServletRequest（HttpServletRequest?request）?{
		this.request?=?request;
	}

	public?void?setServletResponse（HttpServletResponse?response）?{
		this.response?=?response;
	}

	public?String?getMessage（）?{
		return?message;
	}

	//?此處只簡單的實現了Excel文件的在線編輯和保存，
	//?動態填充單元格、提交單元格等其他功能的實現請參考通過JSP編寫的示例
	public?String?openexcel（）?throws?Exception?{
		PageOfficeCtrl?poCtrl1?=?new?PageOfficeCtrl（
				ServletActionContext.getRequest（））;
		poCtrl1.setServerPage（“poserver.do“）;?//?此行必須

		poCtrl1.setCaption（“操作Excel文檔“）;
		//設置邊框的類型
		poCtrl1.setBorderstyle（BorderstyleType.BorderThin）;
		//設置邊框的顏色
		poCtrl1.setBorderColor（Color.blue）;
		
		//?代表一個Excel文檔，用來讀取用戶輸入到Excel表格中的數據填充Excel表格
		Workbook?workbook?=?new?Workbook（）;
		//?參數為要打開的Excel文件中的Sheet表單的名稱
		Sheet?sheet?=?workbook.openSheet（“Sheet1“）;
		//?獲取sheet名稱
		String?name?=?sheet.getName（）;
		System.out.println（“--------“?+?name）;
		//?打開指定的單元格（“B4”單元格），并返回?Cell?對象
		Cell?B4?=?sheet.openCell（“B4“）;
		//?給單元格賦值
		B4.setValue（“B產品“）;
		//?設置單元格前景色
		B4.setForeColor（Color.green）;
		
		
		//?打開指定的表格，并返回?Table?對象
		//?Table?XXX?=sheet.openTable（“XXX“）;
		

		//?提交單元格數據
		//?B4.setSubmitName（“pname“）;

		poCtrl1.setWriter（workbook）;
		//?工具欄
		poCtrl1.addCustomToolButton（“保存“?“SaveDocument（）“?1）;
		poCtrl1.addCustomToolButton（“-“?““?0）;
		poCtrl1.addCustomToolButton（“打印“?“ShowPrintDlg（）“?6）;
		poCtrl1.addCustomToolButton（“-“?““?0）;
		poCtrl1.addCustomToolButton（“全屏切換“?“SetFullScreen（）“?4）;
		poCtrl1.addCustomToolButton（“-“?““?0）;
		poCtrl1.addCustomToolButton（“加蓋印章“?“AddSeal（）“?5）;
		poCtrl1.addCustomToolButton（“手寫簽批“?“AddHandSign（）“?5）;
		poCtrl1.addCustomToolButton（“驗證印章“?“VerifySeal（）“?5）;
		//?設置保存頁
		poCtrl1.setSaveFilePage（“saveexcel.action“）;
		//?打開文件
		poCtrl1.webOpen（“doc/test.xls“?OpenModeType.xlsNormalEdit?“張三“）;
		po

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????834??2016-03-24?09:09??demo\pageOfficeDemo\.classpath

?????文件???????1047??2016-03-24?09:09??demo\pageOfficeDemo\.project

?????文件????????503??2016-03-24?09:09??demo\pageOfficeDemo\.settings\.jsdtscope

?????文件?????????73??2016-03-24?09:18??demo\pageOfficeDemo\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2016-03-24?09:09??demo\pageOfficeDemo\.settings\org.eclipse.jdt.core.prefs

?????文件????????496??2016-03-24?09:09??demo\pageOfficeDemo\.settings\org.eclipse.wst.common.component

?????文件????????345??2016-03-24?09:09??demo\pageOfficeDemo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2016-03-24?09:09??demo\pageOfficeDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2016-03-24?09:09??demo\pageOfficeDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????4703??2016-03-28?11:13??demo\pageOfficeDemo\build\classes\com\demo\action\ExcelDemo.class

?????文件???????8248??2016-03-28?11:56??demo\pageOfficeDemo\build\classes\com\demo\action\WordDemo.class

?????文件???????1447??2016-03-25?15:17??demo\pageOfficeDemo\build\classes\struts.xml

?????文件???????4036??2016-03-28?11:13??demo\pageOfficeDemo\src\com\demo\action\ExcelDemo.java

?????文件???????8457??2016-03-28?11:56??demo\pageOfficeDemo\src\com\demo\action\WordDemo.java

?????文件???????1447??2016-03-25?15:17??demo\pageOfficeDemo\src\struts.xml

?????文件???????1022??2016-03-28?09:51??demo\pageOfficeDemo\WebContent\autoInsert.jsp

?????文件???????1193??2016-03-28?11:59??demo\pageOfficeDemo\WebContent\createWord.jsp

?????文件??????44544??2016-03-25?14:42??demo\pageOfficeDemo\WebContent\doc\template.doc

?????文件??????29184??2016-03-24?09:10??demo\pageOfficeDemo\WebContent\doc\test.doc

?????文件????1054187??2016-03-25?14:32??demo\pageOfficeDemo\WebContent\doc\test.pdf

?????文件??????16896??2016-03-24?09:10??demo\pageOfficeDemo\WebContent\doc\test.xls

?????文件???????2077??2016-03-24?09:18??demo\pageOfficeDemo\WebContent\editexcel.jsp

?????文件???????1932??2016-03-24?09:54??demo\pageOfficeDemo\WebContent\editword.jsp

?????文件????????861??2016-03-28?10:08??demo\pageOfficeDemo\WebContent\href.jsp

?????文件???????1376??2016-03-28?09:34??demo\pageOfficeDemo\WebContent\index.jsp

?????文件?????????39??2016-03-24?09:09??demo\pageOfficeDemo\WebContent\meta-INF\MANIFEST.MF

?????文件???????2862??2016-03-25?14:35??demo\pageOfficeDemo\WebContent\openPDF.jsp

?????文件????????478??2016-03-25?17:54??demo\pageOfficeDemo\WebContent\savefile.jsp

?????文件????????999??2016-03-25?15:11??demo\pageOfficeDemo\WebContent\saveMaker.jsp

?????文件??????57779??2016-03-24?09:09??demo\pageOfficeDemo\WebContent\WEB-INF\lib\commons-fileupload-1.2.1.jar

............此處省略33個文件信息