webexcelaction.java

《j2ee开发全程实录》随书源码

package com.cownew.PIS.tools.web;

import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

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

import jxl.Sheet;
import jxl.Workbook;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.cownew.ctk.io.ResourceUtils;

public class WebExcelAction extends Action
{

	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception
	{
		WebExcelForm excelForm = (WebExcelForm) form;
		List sheetList = new ArrayList();
		InputStream inputStream = null;

		try
		{
			inputStream = excelForm.getFile().getInputStream();
			Workbook wb = Workbook.getWorkbook(inputStream);
			for (int i = 0, n = wb.getNumberOfSheets(); i < n; i++)
			{
				Sheet sheet = wb.getSheet(i);
				sheetList.add(sheet);
			}
		} finally
		{
			ResourceUtils.close(inputStream);
		}
		
		request.setAttribute("sheetList",sheetList);

		return mapping.getInputForward();
	}

}