joinexcelaction.java

利用poi插件和Java语言在web中实现excel的合并功能

package com.Control.join;

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

import org.apache.struts.action.Action;
//import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.dao.join.JoinExcelControl;
import com.dao.join.CombinationFileExcel;

public class JoinExcelAction extends Action {
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		//备份选择的数据库表
		String filename = request.getParameter("name");
//		JoinExcelControl objControl = new JoinExcelControl();
		CombinationFileExcel objControl=new CombinationFileExcel();
		try {
			objControl.combination("e:/template.xls",new String[] { "e:/file.xls",
					"e:/file1.xls", "e:/file2.xls" }, "e:/temp.xls",
					"e:/suited.xls",30);
			String realPath = request.getRealPath("\\"+"page");
			System.out.println(realPath);
			objControl.exceltoHTML("e:/suited.xls", "e:/suited.html");
			//Runtime.getRuntime().exec("cmd.exe /c start "+"e:\\suited.xls");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
			return mapping.findForward("success");
		
	}
}