com.gitee.cliveyuan.tools.data

Class ExcelHelper<T>

java.lang.Object

com.gitee.cliveyuan.tools.data.TableAbstract

com.gitee.cliveyuan.tools.data.ExcelHelper<T>

public class ExcelHelper<T>
extends TableAbstract

Excel 帮助类

Since:

1.0

Author:

clive Created on 2018/07/25

Constructor Summary

Constructors

Constructor and Description
ExcelHelper()

Method Summary

Modifier and Type	Method and Description
File	generate(String[] headers, Collection<T> data, String filePath) 生成EXCEL
File	generate(String[] headers, Collection<T> data, String filePath, ExcelType excelType) 生成EXCEL
List<T>	parse(String excelPath, boolean skipFirstRow, Class<T> clazz) 解析EXCEL
Map<String,List<T>>	parse(String excelPath, Class<T> clazz) 解析EXCEL (解析所有sheet) map key 为sheetName, value为数据
List<T>	parse(String excelPath, int skipRowNo, Class<T> clazz) 解析EXCEL (只解析第一个sheet)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelHelper

public ExcelHelper()

Method Detail

generate

public File generate(String[] headers,
                     Collection<T> data,
                     String filePath)
              throws ExcelException

生成EXCEL

Parameters:

headers - 抬头 (要与数据中的属性顺序和数量对应)

data - 数据

filePath - 导出的文件路径

Throws:

ExcelException

generate

public File generate(String[] headers,
                     Collection<T> data,
                     String filePath,
                     ExcelType excelType)

生成EXCEL

Parameters:

headers - 抬头 (要与数据中的属性顺序和数量对应)

data - 数据

filePath - 导出的文件路径

excelType - 导出文件格式

Returns:

导出的文件

parse

public List<T> parse(String excelPath,
                     boolean skipFirstRow,
                     Class<T> clazz)
              throws ExcelException

解析EXCEL

Parameters:

excelPath - excel绝对路径 (支持xlsx和xls)

skipFirstRow - 是否跳过首行

clazz - 类

Throws:

ExcelException

parse

public List<T> parse(String excelPath,
                     int skipRowNo,
                     Class<T> clazz)
              throws ExcelException

解析EXCEL (只解析第一个sheet)

Parameters:

excelPath - excel绝对路径 (支持xlsx和xls)

skipRowNo - 跳过前n行

clazz - 类

Throws:

ExcelException

parse

public Map<String,List<T>> parse(String excelPath,
                                 Class<T> clazz)
                          throws ExcelException

解析EXCEL (解析所有sheet) map key 为sheetName, value为数据

Parameters:

excelPath -

clazz -

Throws:

ExcelException