文件名称:excel导入导出工具
文件大小:9KB
文件格式:JAR
更新时间:2017-10-20 08:26:22
java excel export import util
export excel:
1-step:use @ExcelField(lableName="sex") on POJO's field
2-setp: use ExcelUtil's static method export(Class> clazz,List> list,OutputStream os).
if need convert the POJO field's value,you make create class implement ExcelConvert.
and @ExcelField(lableName="sex",covertClass=SexConvert.class)
import excel:
make sure excel cell's title equals class field's name.
if need convert the excel cell value,you make create class implement ExcelConvert.
and put map,the key is field's name,value is ExcelConvert implement instance.
call the static method:
leadingIn(Class> clazz,InputStream in)
leadingIn(Class> clazz,Map