导入依赖
<!-- Excel导入导出插件 -->
<dependency>
<groupId>com.wuwenze</groupId>
<artifactId>ExcelKit</artifactId>
<version>2.0.71</version>
</dependency>
工具类
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.HSSFColor;
import org.springframework.http.MediaType;
import javax.servlet.http.HttpServletResponse;
import java.net.URLEncoder;
import java.nio.charset.Charset;
import java.util.ArrayList;
public class ExcelFileGeneratorUtil {
private final int SPLIT_COUNT = 1000;
private ArrayList fieldName = null;
private ArrayList fieldData = null;
private HSSFWorkbook workBook = null;
public ExcelFileGeneratorUtil(ArrayList fieldName, ArrayList fieldData) {
this.fieldName = fieldName;
this.fieldData = fieldData;
}
public HSSFWorkbook createWorkbook() {
workBo