com.lkx.util

类 ExcelUtil

java.lang.Object

com.lkx.util.ExcelUtilBase

com.lkx.util.ExcelUtil

所有已实现的接口:

Serializable

public class ExcelUtil
extends ExcelUtilBase
implements Serializable

ClassName:ExcelUtil Function: excel快速读取、写入公共类 Date: 2019年7月12日 23:17:45

从以下版本开始:

JDK 1.8

版本:

V1.0 898

作者:

likaixuan

另请参阅:

序列化表格

嵌套类概要

从类继承的嵌套类/接口 com.lkx.util.ExcelUtilBase

ExcelUtilBase.PoiWriter

构造器概要

构造器

构造器和说明
ExcelUtil()

方法概要

限定符和类型	方法和说明
static void	exportExcel(String outFilePath, List<?> list, Class clazz) 导出Excel到指定磁盘位置
static void	exportExcel(String outFilePath, List<?> list, Class clazz, String headerName, String waterMark) 导出Excel到指定磁盘位置
static void	exportExcel(String outFilePath, String keyValue, List<?> list, Class clazz) 导出Excel到指定磁盘位置
static void	exportExcelOutputStream(ExcelParamAbstract excelParamAbstract)
static void	exportExcelOutputStream(javax.servlet.http.HttpServletResponse response, List<?> list, Class clazz)
static void	exportExcelOutputStream(javax.servlet.http.HttpServletResponse response, List<?> list, Class clazz, String fileName)
static void	exportExcelOutputStream(javax.servlet.http.HttpServletResponse response, List<?> list, Class clazz, String fileName, Boolean fileNameAsHeaderName)
static void	exportExcelOutputStream(javax.servlet.http.HttpServletResponse response, List<?> list, Class clazz, String fileName, String waterMark)
static void	exportExcelOutputStream(javax.servlet.http.HttpServletResponse response, String keyValue, List<?> list, Class clazz) 导出Excel到浏览器中
static void	exportExcelOutputStream(javax.servlet.http.HttpServletResponse response, String keyValue, List<?> list, Class clazz, String fileName)
static void	exportExcelOutputStream(javax.servlet.http.HttpServletResponse response, String keyValue, List<?> list, Class clazz, String fileName, Boolean fileNameAsHeaderName)
static <T> List<T>	readXls(byte[] buf, Class<T> clazz, int... rowNumIndex)
static <T> List<T>	readXls(byte[] buf, Map map, Class<T> clazz, int... rowNumIndex) 使用流读取Excel
static <T> List<T>	readXls(String filePath, Class clazz) 本地通过注解匹配属性和表头
static <T> List<T>	readXls(String filePath, Class clazz, int... rowNumIndex) 本地通过注解匹配属性和表头
static <T> List<T>	readXls(String filePath, Map map, Class clazz) 本地读取
static void	templateWrite(javax.servlet.http.HttpServletResponse response, String templatePath, Object obj, String fileName)
static void	templateWrite(javax.servlet.http.HttpServletResponse response, String templatePath, String outFilePath, Object obj)

从类继承的方法 com.lkx.util.ExcelUtilBase

addWaterMark, commonExportExcel, commonExportExcel2, dateConvertFormat, getAttrVal, getList, getList, getMap, getMap, getMap, getResult, getValue, setter, templateWrite

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

ExcelUtil

public ExcelUtil()

方法详细资料

readXls

public static <T> List<T> readXls(String filePath,
                                  Map map,
                                  Class clazz)
                           throws Exception

本地读取

抛出:

Exception

readXls

public static <T> List<T> readXls(String filePath,
                                  Class clazz)
                           throws Exception

本地通过注解匹配属性和表头

抛出:

Exception

readXls

public static <T> List<T> readXls(String filePath,
                                  Class clazz,
                                  int... rowNumIndex)
                           throws Exception

本地通过注解匹配属性和表头

抛出:

Exception

readXls

public static <T> List<T> readXls(byte[] buf,
                                  Map map,
                                  Class<T> clazz,
                                  int... rowNumIndex)
                           throws Exception

使用流读取Excel

参数:

字节流 -

map -

clazz -

rowNumIndex -

返回:

抛出:

Exception

readXls

public static <T> List<T> readXls(byte[] buf,
                                  Class<T> clazz,
                                  int... rowNumIndex)
                           throws Exception

抛出:

Exception

exportExcel

public static void exportExcel(String outFilePath,
                               String keyValue,
                               List<?> list,
                               Class clazz)
                        throws Exception

导出Excel到指定磁盘位置

抛出:

Exception

exportExcel

public static void exportExcel(String outFilePath,
                               List<?> list,
                               Class clazz)
                        throws Exception

导出Excel到指定磁盘位置

抛出:

Exception

exportExcel

public static void exportExcel(String outFilePath,
                               List<?> list,
                               Class clazz,
                               String headerName,
                               String waterMark)
                        throws Exception

导出Excel到指定磁盘位置

抛出:

Exception

exportExcelOutputStream

public static void exportExcelOutputStream(javax.servlet.http.HttpServletResponse response,
                                           String keyValue,
                                           List<?> list,
                                           Class clazz)
                                    throws Exception

导出Excel到浏览器中

参数:

response -

keyValue -

list -

clazz -

抛出:

Exception

exportExcelOutputStream

public static void exportExcelOutputStream(javax.servlet.http.HttpServletResponse response,
                                           String keyValue,
                                           List<?> list,
                                           Class clazz,
                                           String fileName)
                                    throws Exception

抛出:

Exception

exportExcelOutputStream

public static void exportExcelOutputStream(javax.servlet.http.HttpServletResponse response,
                                           String keyValue,
                                           List<?> list,
                                           Class clazz,
                                           String fileName,
                                           Boolean fileNameAsHeaderName)
                                    throws Exception

抛出:

Exception

exportExcelOutputStream

public static void exportExcelOutputStream(javax.servlet.http.HttpServletResponse response,
                                           List<?> list,
                                           Class clazz)
                                    throws Exception

抛出:

Exception

exportExcelOutputStream

public static void exportExcelOutputStream(javax.servlet.http.HttpServletResponse response,
                                           List<?> list,
                                           Class clazz,
                                           String fileName)
                                    throws Exception

抛出:

Exception

exportExcelOutputStream

public static void exportExcelOutputStream(javax.servlet.http.HttpServletResponse response,
                                           List<?> list,
                                           Class clazz,
                                           String fileName,
                                           String waterMark)
                                    throws Exception

抛出:

Exception

exportExcelOutputStream

public static void exportExcelOutputStream(ExcelParamAbstract excelParamAbstract)
                                    throws Exception

抛出:

Exception

exportExcelOutputStream

public static void exportExcelOutputStream(javax.servlet.http.HttpServletResponse response,
                                           List<?> list,
                                           Class clazz,
                                           String fileName,
                                           Boolean fileNameAsHeaderName)
                                    throws Exception

抛出:

Exception

templateWrite

public static void templateWrite(javax.servlet.http.HttpServletResponse response,
                                 String templatePath,
                                 String outFilePath,
                                 Object obj)

templateWrite

public static void templateWrite(javax.servlet.http.HttpServletResponse response,
                                 String templatePath,
                                 Object obj,
                                 String fileName)