Spring 使用POI导出Excel并生成下拉选项

在开发中我们经常会用到生成excel，下面是spring项目前后端分离导出excel工具类，接口中直接引用即可。

首先引入poi-jar包：

		<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi</artifactId>
		    <version>3.14</version>
		</dependency>
		<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi-ooxml</artifactId>
		    <version>3.14</version>
		</dependency>

ExcelPoiUtil：

import java.util.List;

import org.apache.poi.hssf.usermodel.DVConstraint;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.CellRangeAddressList;

public class ExcelPoiUtil {

	/**
	 * 
	 * @param fileName 文件名称
	 * @param sheetName sheet页名称
	 * @param titleList 列名
	 * @param titleCodeList 列名对应的code
	 * @param parpamtsList 可选择参数列(需与列名一比一)
	 */
	public static HSSFWorkbook createExcel(String fileName,S