使用jxls按模板导出excel数据

最新推荐文章于 2023-06-15 23:23:04 发布

Coder_Jiang

最新推荐文章于 2023-06-15 23:23:04 发布

阅读量1.5k

点赞数

分类专栏： Java

本文链接：https://blog.youkuaiyun.com/coderjiang/article/details/27354387

版权

Java 专栏收录该内容

49 篇文章

订阅专栏

public class StyleRowSample {
    private static String templateFileName = "/templates/rowstyle.xls";
    private static String destFileName = "build/rowstyle_output.xls";

    public static void main(String[] args) throws IOException, ParsePropertyException, InvalidFormatException {
        if (args.length >= 2) {
            templateFileName = args[0];
            destFileName = args[1];
        }
        Department department = new Department("IT");
        Calendar calendar = Calendar.getInstance();
        calendar.set(1970, 12, 2);
        Date d1 = calendar.getTime();
        calendar.set(1980, 2, 15);
        Date d2 = calendar.getTime();
        calendar.set(1976, 7, 20);
        Date d3 = calendar.getTime();
        calendar.set(1968, 5, 6);
        Date d4 = calendar.getTime();
        calendar.set(1978, 8, 17);
        Date d5 = calendar.getTime();
        department.addEmployee(new Employee("Elsa", 28, 1500, 0.15, d1));
        department.addEmployee(new Employee("Oleg", 32, 2300, 0.25, d3));
        department.addEmployee(new Employee("Neil", 34, 2500, 0.00, d4));
        department.addEmployee(new Employee("Maria", 34, 1700, 0.15, d5));
        department.addEmployee(new Employee("John", 35, 2800, 0.20, d2));
        Map beans = new HashMap();
        beans.put("department", department);
        XLSTransformer transformer = new XLSTransformer();
        transformer.registerRowProcessor(new StyleRowProcessor("department.staff"));
        transformer.transformXLS(StyleRowSample.class.getResource(templateFileName).getPath(), beans, destFileName);
    }

}