addaction.java

如何用java语言从excel批量倒入

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package addexcel.action;

import java.util.*;
import javax.servlet.http.*;
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 addexcel.form.AddForm;
import hibernate.*;
import jxl.*;
import jxl.write.*;
import java.io.*;

/** 
 * MyEclipse Struts
 * Creation date: 06-18-2007
 * 
 * XDoclet definition:
 * @struts.action path="/add" name="addForm" scope="request"
 */
public class AddAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		AddForm addForm = (AddForm) form;
		TestDAO testDao=new TestDAO();
		List list=testDao.findAll();
		Iterator iterator=list.iterator();
		try {
			WritableWorkbook wwb=Workbook.createWorkbook(new File("c:\\aaa.xls"));//此处建立路径
			jxl.write.WritableSheet ws = wwb.createSheet("Sheet1", 0);//建立工作簿
			for(int i=0;i<list.size();i++)//i代表行
			{
				while(iterator.hasNext())
				{
					int j=0;//j代表列
					Test test=(Test)iterator.next();
					jxl.write.Label label1 = new jxl.write.Label(j, i, test.getDd());//建立第一列
					ws.addCell(label1);//放入工作簿
					j++;
					jxl.write.Label label2 = new jxl.write.Label(j, i, test.getCc());//建立第二列
					ws.addCell(label2);
					break;
				}
			}
			//写入Exel工作表
			wwb.write();
			//关闭Excel工作薄对象
			wwb.close();
			return mapping.findForward("success");
		} catch (Exception e) {
			e.printStackTrace();
			return mapping.findForward("false");
		}
	}
}