导出Excel

1.样式如下：

2.工具类代码如下：

package com.jeeplus.modules.test.one.dialog.web;

import com.google.common.reflect.TypeToken;
import com.google.gson.Gson;
import com.jeeplus.modules.test.one.dialog.entity.LeaveForm1;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFPalette;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.io.InputStream;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * excel工具类
 * @author NS08
 *
 */
public class ExcelUtils {

	/**
	 * 
	 * titile:表头 par: 表头对应参数名 list:数据 fileName:导出文件名
	 * 
	 */
	@SuppressWarnings("deprecation")
	public static void export(Object[] title, Object[] par, List<LeaveForm1> list, String fileName, HttpServletResponse response) {
		try {
			int titleLen = title.length ;
			/*if (title.length != par.length) {
				throw new Exception("表头数和参数长度必须一致");