java的生成excel文件工具类

package com.mabo;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class Test {
    public static void main(String[] args) {
        Map> memberMap = getMember();
        String[] strArray = { "学号", "姓名", "年龄", "生日" };
        ExcelUtil.createExcel(memberMap, strArray,"D:/测试.xls");
    }

    
    private static Map> getMember() {
        List list = new ArrayList();
        Map> map = new HashMap>();
        SimpleDateFormat df = new SimpleDateFormat("yyyy-mm-dd");
        try {
            Member user1 = new Member(1, "姓名1", 18, df.parse("2002-10-16"));
            Member user2 = new Member(2, "姓名2", 20, df.parse("2000-08-19"));
            Member user3 = new Member(3, "姓名3", 25, df.parse("1995-11-22"));
            list.add(user1);
            list.add(user2);
            list.add(user3);
            for (int i = 0; i < list.size(); i++) {
                ArrayList members = new ArrayList();
                members.add(list.get(i).getCode() + "");
                members.add(list.get(i).getName());
                members.add(list.get(i).getAge() + "");
                members.add(df.format(list.get(i).getBirth()));
                map.put(list.get(i).getCode() + "", members);
            }
        } catch (ParseException e) {
            e.printStackTrace();
        }
        return map;
    }





}

测试

package com.mabo;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import java.io.FileOutputStream;
import java.util.List;
import java.util.Map;

public class ExcelUtil {
    public static void createExcel(Map> map, String[] strArray,String fileName) {
        // 创建一个webbook，对应一个Excel文件
        HSSFWorkbook wb = new HSSFWorkbook();
        // 在webbook中添加一个sheet,对应Excel文件中的sheet
        HSSFSheet sheet = wb.createSheet("sheet1");
        // 在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
        HSSFRow row = sheet.createRow(0);
        // 添加标题行
        HSSFCell cell = null;
        for (int i = 0; i < strArray.length; i++) {
            // 获取行内对应单元格
            cell = row.createCell(i);
            // 单元格赋值
            cell.setCellValue(strArray[i]);
        }

        // 写入实体数据，实际应用中这些数据从数据库得到,list中字符串的顺序必须和数组strArray中的顺序一致
        int i = 0;
        for (String str : map.keySet()) {
            // 除去标题行，遍历获取后面行号对象
            row = sheet.createRow(i + 1);
            // 获取要添加到单元格的集合数据
            List list = map.get(str);

            // 遍历当前行内所有单元格
            for (int j = 0; j < strArray.length; j++) {
                // 创建单元格，并设置值
                row.createCell(j).setCellValue(list.get(j));
            }
            // 第六步，将文件存到指定位置
            try {
                FileOutputStream fout = new FileOutputStream(fileName);
                wb.write(fout);
                fout.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
            i++;
        }
    }

}

相关maven依赖

    4.0.0

    org.example
    Mybatis
    1.0-SNAPSHOT

    
        8
        8
    
    
        
            org.mybatis
            mybatis
            3.5.2
        
        
            mysql
            mysql-connector-java
            5.1.49
        
        
            org.springframework
            spring-core
            5.3.7
        
        
            org.apache.poi
            poi
            3.17
        
        
            org.apache.poi
            poi-ooxml
            3.17
        
        
            org.apache.poi
            poi
            4.0.1
        
        
            org.apache.httpcomponents
            httpcore
            4.4.13
        
        
            org.apache.httpcomponents
            httpclient
            4.5.13