src/com/sys/plugin/doc/JXLWriteUtil.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.sys.plugin.doc;

import java.io.File;
import java.io.OutputStream;
import java.lang.reflect.Method;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletResponse;

import com.sys.log.LogFactory;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class JXLWriteUtil<T> {
	
	private String fullFilePath;
	private WritableWorkbook wk = null;
	private Map hmSheet = new HashMap(); 
	private OutputStream out = null;
	
	private JXLWriteUtil(String fullFilePath) {
		this.setFullFilePath(fullFilePath);
		this.createWorkbook();
	}
	
	private JXLWriteUtil(String filePath, String fileName) {
		this.setFullFilePath(filePath +  File.separator + fileName);
		this.createWorkbook();
	}
	
	private JXLWriteUtil(HttpServletResponse response) {
		try {
			response.setContentType("application/xls");
			response.setCharacterEncoding("UTF-8");
			response.setHeader("Content-Disposition", "attach; filename=\""
					+ URLEncoder.encode("File", "UTF-8") + ".xls\"");
			this.out = response.getOutputStream();
		} catch (Exception e) {
			LogFactory.getLogger().error(e.getMessage());
		}
	}
	
	public static JXLWriteUtil getInstance(String filePath, String fileName) {
		return new JXLWriteUtil(filePath,fileName);
	}
	
	public static JXLWriteUtil getInstance(String fullFilePath) {
		return new JXLWriteUtil(fullFilePath);
	}
	
	private WritableWorkbook createWorkbook() {
		if(wk == null) {
			try {
				if(out == null) {