| Package | Description |
|---|---|
| com.gitee.cliveyuan.tools.data | |
| com.gitee.cliveyuan.tools.exception |
| Modifier and Type | Method and Description |
|---|---|
File |
ExcelHelper.generate(String[] headers,
Collection<T> data,
String filePath)
生成EXCEL
|
List<T> |
ExcelHelper.parse(String excelPath,
boolean skipFirstRow,
Class<T> clazz)
解析EXCEL
|
Map<String,List<T>> |
ExcelHelper.parse(String excelPath,
Class<T> clazz)
解析EXCEL
(解析所有sheet)
map key 为sheetName, value为数据
|
List<T> |
ExcelHelper.parse(String excelPath,
int skipRowNo,
Class<T> clazz)
解析EXCEL
(只解析第一个sheet)
|
| Modifier and Type | Method and Description |
|---|---|
static ExcelException |
ExcelException.dataConvertError() |
static ExcelException |
ExcelException.excelReadError() |
static ExcelException |
ExcelException.failToGenerateExcel() |
static ExcelException |
ExcelException.failToMkdirs() |
static ExcelException |
ExcelException.failToParseExcel() |
static ExcelException |
ExcelException.failToReadSheet() |
static ExcelException |
ExcelException.notSupport(String extension) |
Copyright © 2020. All rights reserved.