This is the jsp code:
<%@ page language="java" %>
<%@ page import="org.apache.poi.hssf.usermodel.*" %>
<%@ page import="java.io.PrintWriter" %>
<%@ page import="java.io.OutputStream" %>
<%@ page import="poi2.POIExample" %>
<%@ taglib prefix="json" uri="
http://www.atg.com/taglibs/json" %>
<jsp:useBean id="example" class="poi2.POIExample"/>
<html>
<head>Testing Page</head>
<h1>HI</h1>
<body>
<% POIExample obj = new POIExample();
%>
<json:object>
<json:property name="col" value="${
obj.name}"/>
</json:object>
<json:object>
<json:property name="outer" value="foo"/>
<json:object name="inner">
<json:property name="innerProp1" value="val1"/>
<json:property name="innerProp2" value="val2"/>
<json:object name="inner2">
<json:property name="inner2Prop1" value="in2p1"/>
<json:property name="inner2Prop2" value="in2p2"/>
</json:object>
</json:object>
</json:object>
</body>
</html>
n the java code is:(the "name" variable)
package poi2;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import java.io.PrintWriter;
import java.lang.Exception;
import java.util.Iterator;
/**
* A simple POI example of opening an Excel spreadsheet
*/
public class POIExample {
public String name;
public static void main( String args[] ) {
POIExample p = new POIExample();
p.read();
}
public void read(){
try {
InputStream input =
POIExample.class.getResourceAsStream( "qa.xls" );
POIFSFileSystem fs = new POIFSFileSystem( input );
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
// Iterate over each row in the sheet
Iterator rows = sheet.rowIterator();
HSSFRow row = (HSSFRow) rows.next();
System.out.println( "Row #" + row.getRowNum() );
// Iterate over each cell in the row and print out the
cell's content
Iterator cells = row.cellIterator();
HSSFCell cell = (HSSFCell) cells.next();
System.out.println( "Cell #" +
cell.getCellNum() );
name = cell.getRichStringCellValue().toString();
}catch ( Exception ex ) {
ex.printStackTrace();