限定符和类型 | 类和说明 |
---|---|
protected static class |
ExcelUtilBase.PoiWriter |
构造器和说明 |
---|
ExcelUtilBase() |
限定符和类型 | 方法和说明 |
---|---|
static void |
addWaterMark(org.apache.poi.xssf.usermodel.XSSFWorkbook wb,
org.apache.poi.xssf.usermodel.XSSFSheet sheet,
String waterMark) |
static void |
commonExportExcel(ExcelParam excelParam) |
static void |
commonExportExcel2(ExcelParamAbstract excelParamAbstract) |
static Date |
dateConvertFormat(String dateStr)
String类型日期转为Date类型
|
static Object |
getAttrVal(Object obj,
String att,
Class<?> attType) |
static List<String> |
getList(Class<org.apache.poi.ss.formula.functions.T> clazz) |
static List<String> |
getList(String keyValue) |
static Map<String,String> |
getMap(Class<org.apache.poi.ss.formula.functions.T> clazz) |
static Map<String,Object> |
getMap(Object obj) |
static Map<String,String> |
getMap(String keyValue) |
static List |
getResult(ExcelParam excelParam) |
static void |
getValue(org.apache.poi.ss.usermodel.Cell cell,
Object obj,
String attr,
Class attrType,
int row,
int col,
Object key) |
static void |
setter(Object obj,
String att,
Object value,
Class<?> type,
int row,
int col,
Object key) |
static void |
templateWrite(ExcelParam excelParam) |
public static Map<String,String> getMap(Class<org.apache.poi.ss.formula.functions.T> clazz) throws NoSuchFieldException
clazz
- NoSuchFieldException
public static Map<String,Object> getMap(Object obj)
obj
- NoSuchFieldException
public static List<String> getList(Class<org.apache.poi.ss.formula.functions.T> clazz) throws NoSuchFieldException
clazz
- NoSuchFieldException
public static List getResult(ExcelParam excelParam) throws Exception
Exception
public static void addWaterMark(org.apache.poi.xssf.usermodel.XSSFWorkbook wb, org.apache.poi.xssf.usermodel.XSSFSheet sheet, String waterMark)
public static void commonExportExcel(ExcelParam excelParam) throws Exception
Exception
public static void commonExportExcel2(ExcelParamAbstract excelParamAbstract) throws Exception
Exception
public static void setter(Object obj, String att, Object value, Class<?> type, int row, int col, Object key) throws Exception
Exception
public static Object getAttrVal(Object obj, String att, Class<?> attType) throws Exception
Exception
public static void getValue(org.apache.poi.ss.usermodel.Cell cell, Object obj, String attr, Class attrType, int row, int col, Object key) throws Exception
cell
- obj
- attr
- attrType
- row
- col
- key
- Exception
public static Date dateConvertFormat(String dateStr) throws ParseException
dateStr
- Exception
ParseException
public static void templateWrite(ExcelParam excelParam)
Copyright © 2020. All Rights Reserved.