【Java开源代码栏目提醒】:网学会员,鉴于大家对Java开源代码十分关注,论文会员在此为大家搜集整理了“WebExcelAction.java”一文,供大家参考学习!
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();
}
}
上一篇:
WebEndServiceLocator.java
下一篇:
关于大学英语教学