Using Spreadsheet in JSP"
| Line 3: | Line 3: | ||
| + | __TOC__ | ||
{{ZSS EE}} | {{ZSS EE}} | ||
| Line 11: | Line 12: | ||
= Create and Run a JSP Project = | = Create and Run a JSP Project = | ||
| − | Follow instructions in [[ZK Spreadsheet Essentials 3 | + | Follow instructions in [[ZK Spreadsheet Essentials 3/Working with Spreadsheet/Setting Up Environment]] to create a "dynamic web project" or a "maven project" named '''myzssjsp'''. |
| − | + | This feature is only available in EE, so you should download EE version. (Free Evaluation Download or Premium Download). After you install ZK Spreadsheet library, make sure '''zssjsp.jar''' existed under <tt>/WEB-INF/lib</tt>. | |
| − | + | ||
| − | + | == Verify Your Project == | |
| + | After completing above steps, preparation for working with Spreadsheet and JSP is done. You can use a simple page to verify your preparation. Steps are as follows: | ||
| + | # Create a simple Excel file or use the sample file in our example project. Put the file under your web application's root folder. | ||
| + | # Create <tt>index.jsp</tt> with content below: | ||
| + | <source lang="xml"> | ||
| + | <%@ page language="java" contentType="text/html; charset=ISO-8859-1" | ||
| + | pageEncoding="ISO-8859-1"%> | ||
| + | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | ||
| + | <html> | ||
| + | <head> | ||
| + | <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> | ||
| + | <title>My First ZK Spreadsheet JSP application</title> | ||
| + | <zssjsp:head/> | ||
| + | </head> | ||
| + | <body> | ||
| + | <%@ taglib prefix="zss" uri="http://www.zkoss.org/jsp/zss"%> | ||
| + | <div width="100%" style="height: 100%;"> | ||
| + | <zss:spreadsheet | ||
| + | id="myzss" src="/WEB-INF/hellozss.xlsx" width="100%" | ||
| + | height="800px" maxrows="200" maxcolumns="40" showSheetbar="true"/> | ||
| + | </div> | ||
| + | </body> | ||
| + | </html> | ||
| + | </source> | ||
| + | |||
| + | Deploy the project to your application server and visit <tt>index.jsp</tt> to see if you can see the Spreadsheet. | ||
| − | |||
= usage in JSP = | = usage in JSP = | ||
Revision as of 09:10, 29 July 2013
Available in ZK Spreadsheet EE only
Download ZSS JSP Example Project
If you want to run ZK spreadsheet JSP demo in your local site, just [http:// download the example project WAR file] and deploy to your application server.
Create and Run a JSP Project
Follow instructions in ZK Spreadsheet Essentials 3/Working with Spreadsheet/Setting Up Environment to create a "dynamic web project" or a "maven project" named myzssjsp.
This feature is only available in EE, so you should download EE version. (Free Evaluation Download or Premium Download). After you install ZK Spreadsheet library, make sure zssjsp.jar existed under /WEB-INF/lib.
Verify Your Project
After completing above steps, preparation for working with Spreadsheet and JSP is done. You can use a simple page to verify your preparation. Steps are as follows:
- Create a simple Excel file or use the sample file in our example project. Put the file under your web application's root folder.
- Create index.jsp with content below:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>My First ZK Spreadsheet JSP application</title>
<zssjsp:head/>
</head>
<body>
<%@ taglib prefix="zss" uri="http://www.zkoss.org/jsp/zss"%>
<div width="100%" style="height: 100%;">
<zss:spreadsheet
id="myzss" src="/WEB-INF/hellozss.xlsx" width="100%"
height="800px" maxrows="200" maxcolumns="40" showSheetbar="true"/>
</div>
</body>
</html>
Deploy the project to your application server and visit index.jsp to see if you can see the Spreadsheet.