JXLS系列-01-excel简单模板数据

最新推荐文章于 2024-06-26 14:49:00 发布

ycmy2017

最新推荐文章于 2024-06-26 14:49:00 发布

阅读量399

点赞数

CC 4.0 BY-SA版权

分类专栏： # Java小实战文章标签： java

本文链接：https://blog.csdn.net/ycmy2017/article/details/128644340

Java小实战专栏收录该内容

7 篇文章

订阅专栏

文章展示了如何在Java项目中利用jxls库处理Excel文件。首先列出了所需的pom依赖，包括jxls、jxls-poi和jxls-jexcel。接着，介绍了模板的准备，包含jx指令用于动态渲染。然后，提供了Java代码实现，创建了Employee类并模拟了数据，最后使用JxlsHelper处理模板和数据生成输出文件。

1-pom依赖


        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls</artifactId>
            <version>2.12.0</version>
        </dependency>


        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-poi</artifactId>
            <version>2.12.0</version>
        </dependency>

    
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-jexcel</artifactId>
            <version>1.0.9</version>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.24</version>
            <scope>provided</scope>
        </dependency>

2-模板准备

template1.xls

jx:area(lastCell="C3")；

jx:each(items="employeeList" var="employee" lastCell="C3")；

3-Java代码实现

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.math.BigDecimal;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Employee {

    private String name;
    private String birthDate;
    private BigDecimal payment;

}

import org.jxls.common.Context;
import org.jxls.util.JxlsHelper;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class ExcelTest01 {
    public static void main(String[] args) throws Exception{
        List<Employee> employeeList = new ArrayList<>();
        Employee employee1 = new Employee( "张三", "2010-01-02",new BigDecimal("20100102.12"));
        Employee employee2 = new Employee( "李四", "2011-01-03",new BigDecimal("20110103.03"));
        Employee employee3 = new Employee( "王五", "2012-01-04",new BigDecimal("20120104.25"));
        employeeList.add(employee1);
        employeeList.add(employee2);
        employeeList.add(employee3);
        InputStream is = new FileInputStream("D:/001/template1.xls");
        OutputStream os = new FileOutputStream("D:/001/out1.xls");
        Context context = new Context();
        context.putVar("employeeList", employeeList);
        JxlsHelper.getInstance().processTemplate(is, os, context);
        os.close();
        is.close();
    }
}