Get Spreadsheet Running Quickly in JSP"

From Documentation
Line 98: Line 98:
 
<zssjsp:spreadsheet
 
<zssjsp:spreadsheet
 
id="myzss" src="/WEB-INF/hellozss.xlsx" width="100%"
 
id="myzss" src="/WEB-INF/hellozss.xlsx" width="100%"
height="800px" maxrows="200" maxcolumns="40" showSheetbar="true"/>
+
height="100%" maxrows="200" maxcolumns="40" showSheetbar="true"/>
 
</div>
 
</div>
 
</body>
 
</body>

Revision as of 04:45, 1 August 2013


Get Spreadsheet Running Quickly in JSP





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

The following sections tell you how to prepare an environment for working with Spreadsheet in JSP.

Prerequisites

Before developing a web application with Spreadsheet, you should prepare the following softwares:

  • Install JDK 1.5 or above
  • Install an application server
    • You can install any JavaEE application server you like. If you don't have one, Tomcat is a good choice.
  • Install a development tool.
    • In this book, we will use Eclipse as the default IDE to explain related setup.

Prepare a Project

Steps to Prepare an Eclipse Dynamic Web Project

To save your time from creating a project out of nothing, you could just download the sample project which is a ready-to-run Eclipse dynamic web project.

If you have to create a project by your own, you can follow the steps below:

  1. Create a dynamic web project
  2. Install Spreadsheet library
    1. Download ZK Spreadsheet component (binary). Choose "Free Evaluation Downloads" from product page or licensed EE from premium download.
    2. Extract the zip and copy those JAR files under /dist/lib and /dist/lib/ext to /WEB-INF/lib under your web project's root folder.
      Make sure zssjsp.jar existed under /WEB-INF/lib.
  3. Set up web.xml
    Please refer to Sample of web.xml and Sample of web.xml for Servlet 2.3 (For some web container which support Servlet 2.3 only (e.g. Tomcat 4.x)

Steps to Prepare a Maven Project

1. Create a Maven project.
You should set packaging to war.
We recommend you to create a project from an archetype, then you can skip step 3.
2. Setup Maven dependency.
First, you should setup zk maven repository. Notice that different edition has a different repository, and licensed products even require authentication.


Because this feature is only available in EE, you should add following dependencies:
<dependency>
	<groupId>org.zkoss.zk</groupId>
	<artifactId>zkmax</artifactId>
	<version>${zk.version}</version>
</dependency>
<dependency>
	<groupId>org.zkoss.zss</groupId>
	<artifactId>zssex</artifactId>
	<version>${zss.version}</version>
</dependency>
<dependency>
    <groupId>org.zkoss.zss</groupId>
    <artifactId>zssjsp</artifactId>
    <version>${zss.version}</version>
</dependency>
  • If ${zss.version} is 3.0.0 or above, ${zk.version} should be 6.5.2.

You can reference the pom.xml in our example project to verify your own pom.xml.

3. Set up web.xml.
Please refer to Sample of web.xml and Sample of web.xml for Servlet 2.3 (For some web container which support Servlet 2.3 only (e.g. Tomcat 4.x)

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:

  1. Create a simple Excel file or use the sample file in our example project. Put the file under your web application's root folder.
  2. 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="zssjsp" uri="http://www.zkoss.org/jsp/zss"%>
<div width="100%" style="height: 100%;">
	<zssjsp:spreadsheet
	id="myzss" src="/WEB-INF/hellozss.xlsx" width="100%"
	height="100%" maxrows="200" maxcolumns="40" showSheetbar="true"/>
</div>
</body>
</html>
  • Line 8: The head tag generates ZK required JS and CSS.
  • Line 11: Declare a taglib before using Spreadsheet JSP tag is necessary.
  • Line 13: Use spreadsheet JSP tag with prefix you specified previously.

Now, deploy the project to your application server and visit index.jsp to see if you can see the Spreadsheet.