用jxl模板生成xls文件，并插入图片

最新推荐文章于 2021-11-29 14:30:54 发布

君山玉

最新推荐文章于 2021-11-29 14:30:54 发布

阅读量1.6k

点赞数

文章标签： excel jxl 模板文件

本文链接：https://blog.csdn.net/www520507/article/details/77043993

版权

本文介绍了如何利用jxl库，根据模板生成包含图片的xls文件。在maven配置后，设置模板文件并在特定单元格添加批注，需要注意jxl只支持xls格式且图片必须为png。

摘要由CSDN通过智能技术生成

近段时间做了个用jxl模板生成xls文件，并在文件中增加图片。具体方法如下

一.maven配置：

<dependency>
	<groupId>net.sourceforge.jexcelapi</groupId>
	<artifactId>jxl</artifactId>
	<version>2.6.12</version>
</dependency>
		
<dependency>
	<groupId>org.jxls</groupId>
	<artifactId>jxls</artifactId>
	<version>2.2.8</version>
</dependency>
<dependency>
	<groupId>org.jxls</groupId>
	<artifactId>jxls-poi</artifactId>
	<version>1.0.7</version>
</dependency>

二.创建基本类：Employee和EmployeePrintDto和EmployeeRelationPrintDto

public class EmployeePrintDto {
	private String deadlineDay;
	private String money;
	private String name;
	private String gender;
	private String id_0;
	private String id_1;
	private String id_2;
	private String id_3;
	private String id_4;
	private String id_5;
	private String id_6;
	private String id_7;
	private String id_8;
	private String id_9;
	private String id_10;
	private String id_11;
	private String id_12;
	private String id_13;
	private String id_14;
	private String id_15;
	private String id_16;
	private String id_17;
	
	private String phone;
	private String addr;
	private String marryStatus;
	private String company;
	private String comAddr;
	private String position;
	private String hy_account;
	private String com_phone;
	
   private List<EmployeeRelationPrintDto> crs = new ArrayList<EmployeeRelationPrintDto>();
}

public class EmployeeRelationPrintDto {
	private String relation_name;

	private String relation;

	private String relation_pho;
}
public class Employee{
    
    private Long id;
    private String no;
    private String name;
    private Byte gender;
    private String identityCard;
    private String identityAddr;
    private String phone;
    private String marryStatus;
    private String companyName;
    private String companyAddr;
    private String companyPhone;
    private String position;
    private String hyAccount;
    private Byte status;
    private Date joinTime;
    private String positiveTime;
    private String contractType;
    private String bankName;
    private String bankAccount;
    private String email;
}