org.nutz.integration.json4excel

类 J4E

java.lang.Object

org.nutz.integration.json4excel.J4E

public class J4E
extends Object

根据json配置文件, 读取或导出excel文件

作者:

pw

方法概要

限定符和类型	方法和说明
static <T> boolean	appendExcel(File excel, List<T> dataList, J4EConf j4eConf)
static String	cellValue(org.apache.poi.ss.usermodel.Cell c, J4EColumn jcol)
static <T> List<T>	fromExcel(InputStream in, Class<T> objClz, J4EConf j4eConf) 解析输入流, 按照j4eConf中的配置, 读取后返回objClz类型的数量列表
static <T> List<T>	fromSheet(org.apache.poi.ss.usermodel.Sheet sheet, Class<T> objClz, J4EConf j4eConf, boolean onlyHeader)
static org.apache.poi.ss.usermodel.Sheet	getSheet(org.apache.poi.ss.usermodel.Workbook wb, Class<?> objClz, J4EConf j4eConf)
static org.apache.poi.ss.usermodel.Workbook	loadExcel(InputStream in) 读取excel文件, 返回wb对象, 如果读取发生错误, 返回null
static <T> boolean	matchExcel(InputStream in, Class<T> objClz)
static <T> T	rowValue(org.apache.poi.ss.usermodel.Row row, J4EConf j4eConf, org.nutz.lang.Mirror<T> mc)
static boolean	saveExcel(OutputStream out, org.apache.poi.ss.usermodel.Workbook wb) 保存excel文件, 返回保存是否成功
static <T> boolean	toExcel(File excel, List<T> dataList, J4EConf j4eConf)
static <T> boolean	toExcel(OutputStream out, List<T> dataList, J4EConf j4eConf) 将给定的数据列表datalist, 按照j4eConf中的配置, 输出到out
static <T> boolean	toExcel(org.apache.poi.ss.usermodel.Workbook wb, OutputStream out, List<T> dataList, J4EConf j4eConf)

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

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

方法详细资料

toExcel

public static <T> boolean toExcel(OutputStream out,
                                  List<T> dataList,
                                  J4EConf j4eConf)

将给定的数据列表datalist, 按照j4eConf中的配置, 输出到out

参数:

out - 输出流

objClz - 转换后的对象Class, 对应一行数据

j4eConf - 转换配置(非必须, 可自动生成)

返回:

是否转换并写入成功

toExcel

public static <T> boolean toExcel(File excel,
                                  List<T> dataList,
                                  J4EConf j4eConf)

appendExcel

public static <T> boolean appendExcel(File excel,
                                      List<T> dataList,
                                      J4EConf j4eConf)

toExcel

public static <T> boolean toExcel(org.apache.poi.ss.usermodel.Workbook wb,
                                  OutputStream out,
                                  List<T> dataList,
                                  J4EConf j4eConf)

fromExcel

public static <T> List<T> fromExcel(InputStream in,
                                    Class<T> objClz,
                                    J4EConf j4eConf)

解析输入流, 按照j4eConf中的配置, 读取后返回objClz类型的数量列表

参数:

in - 输入流

objClz - 转换后的对象Class, 对应一行数据

j4eConf - 转换配置(非必须, 可自动生成)

返回:

数据列表

fromSheet

public static <T> List<T> fromSheet(org.apache.poi.ss.usermodel.Sheet sheet,
                                    Class<T> objClz,
                                    J4EConf j4eConf,
                                    boolean onlyHeader)

matchExcel

public static <T> boolean matchExcel(InputStream in,
                                     Class<T> objClz)

rowValue

public static <T> T rowValue(org.apache.poi.ss.usermodel.Row row,
                             J4EConf j4eConf,
                             org.nutz.lang.Mirror<T> mc)

cellValue

public static String cellValue(org.apache.poi.ss.usermodel.Cell c,
                               J4EColumn jcol)

getSheet

public static org.apache.poi.ss.usermodel.Sheet getSheet(org.apache.poi.ss.usermodel.Workbook wb,
                                                         Class<?> objClz,
                                                         J4EConf j4eConf)

loadExcel

public static org.apache.poi.ss.usermodel.Workbook loadExcel(InputStream in)

读取excel文件, 返回wb对象, 如果读取发生错误, 返回null

参数:

excel -

返回:

saveExcel

public static boolean saveExcel(OutputStream out,
                                org.apache.poi.ss.usermodel.Workbook wb)

保存excel文件, 返回保存是否成功

参数:

out -

wb -

返回: