- 博客(0)
- 资源 (2)
- 收藏
- 关注
java编写根据模板导出excel
根据excel模板动态导出数据库数据
package text;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.UUID;
import javax.servlet.ServletContext;
import net.sf.jxls.transformer.XLSTransformer;
import org.apache.struts2.ServletActionContext;
import com.opensymphony.xwork2.ActionSupport;
public class TextAction extends ActionSupport {
/** */
private static final long serialVersionUID = 1L;
private String filename;
@SuppressWarnings("rawtypes")
public String export() throws Exception {
String templateFile = "18.xls";
// String sql = "select * from t_ry order by rybm";
// exportAndDownload(templateFile, DataBase.retrieve(sql));
List datas = new ArrayList();
@SuppressWarnings("unchecked")
HashMap map = new HashMap();
map.put("name", "1111");
datas.add(map);
exportAndDownload(templateFile, datas);
return SUCCESS;
}
@SuppressWarnings({ "rawtypes", "unchecked" })
public void exportAndDownload(String templateFile, List datas) {
try {
filename = UUID.randomUUID() + templateFile;
// FacesContext context = FacesContext.getCurrentInstance();
// ServletContext servletContext = (ServletContext)
// context.getExternalContext().getContext();
ServletContext servletContext = ServletActionContext
.getServletContext();
String path = servletContext.getRealPath("\\ExcelFile");
String srcFilePath = path + "\\template\\" + templateFile;
String destFilePath = path + "\\download\\" + filename;
Map beanParams = new HashMap();
beanParams.put("results", datas);
XLSTransformer transfer = new XLSTransformer();
transfer.transformXLS(srcFilePath, beanParams, destFilePath);
// Browser.execClientScript("window.location.href='../ExcelFile/downloadfile.jsp?filename="
// + destFile + "';");
} catch (Exception e) {
e.printStackTrace();
}
}
public String getFilename() {
return filename;
}
public void setFilename(String filename) {
this.filename = filename;
}
}
2011-09-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人