使用Jxls前需先在pom.xml文件中引入Jxls的依赖
<dependency>
<groupId>org.jxls</groupId>
<artifactId>jxls</artifactId>
<version>2.11.0</version>
</dependency>
<dependency>
<groupId>org.jxls</groupId>
<artifactId>jxls-poi</artifactId>
<version>2.11.0</version>
</dependency>
<dependency>
<groupId>org.jxls</groupId>
<artifactId>jxls-jexcel</artifactId>
<version>1.0.9</version>
</dependency>
第一步:构建UserModel类
import lombok.Data;
@Data
public class UserModel {
private String name;
private String sex;
private Integer age;
private String address;
}
第二步:构建JxlsUtil工具类
import lombok.extern.slf4j.Slf4j;
import org.jxls.common.Context;
import org.jxls.transform.Transformer;
import org.jxls.transform.poi.PoiTransformer;
import org.jxls.util.JxlsHelper;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Slf4j
public class JxlsUtil {
/**
* 使用Jxls引擎渲染
*/
public static void exportExcel(InputStream is, OutputStream os, Map<String, Object> map) thro