import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.nio.charset.Charset;
import java.util.ArrayList;
import java.util.List;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;
/**
* TODO
* 动态生成多个Excel文件,并打ZIP包下载
*/
public class TestUtil {
/*
动态生产多个Excel文件
*/
private List getFileList() {
List fileList = new ArrayList<>();
for (int i = 0; i < 5; i++) {
Workbook workbook = new HSSFWorkbook();
Sheet sheet = workbook.createSh