1、在pom.xml中导入相关依赖
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.17</version>
</dependency>
2、创建excel导出工具类
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.*;
import com.jfinal.plugin.activerecord.Record;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
public class ExcelUtil {
/**
* listData为数据库里查询出来的List<Record>对象
* @author wangjp
* @param listData
* @return
*/
public static File exportExcel(List<Record> listData) {
// 设置文件名
Date date = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd-HH-mm-ss");
String filename = "投资建议书导出列表" + dateFormat.format(date) + ".xls";
File file = new File(filename);
// 标题
Map<String, String> titleData = new LinkedHashMap<String, String>();// 标题,后面用到
titleData.put("inve