xyz.proteanbear.template

类 PbPOIExcelTemplate

java.lang.Object

xyz.proteanbear.template.PbPOIExcelTemplate

public class PbPOIExcelTemplate
extends Object

The tools is created for easy use of Apache POI. This tool is used for reading and writing in Excel.

作者:

ProteanBear

构造器概要

构造器

构造器和说明
PbPOIExcelTemplate()

方法概要

限定符和类型	方法和说明
List<?>	readFrom(File excelFile, Class<?> returnClass) Read excel file and write to list of T class
PbPOIExcelTemplate	setTitleLine(int titleLine) Set excel title line's number(start from 0).Default is 0.
Object	valueOf(org.apache.poi.ss.usermodel.Cell cell) return cell's value object
void	writeTo(File excelFile, List<?>... data) Writes the specified data list to an Excel file.
void	writeTo(FileSuffix fileSuffix, OutputStream outputStream, List<?>... data) Writes the specified data list to an Excel file.

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

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

构造器详细资料

PbPOIExcelTemplate

public PbPOIExcelTemplate()

方法详细资料

readFrom

public List<?> readFrom(File excelFile,
                        Class<?> returnClass)
                 throws IOException,
                        org.apache.poi.openxml4j.exceptions.InvalidFormatException,
                        NoSuchMethodException,
                        IllegalAccessException,
                        InvocationTargetException,
                        InstantiationException,
                        ParseException

Read excel file and write to list of T class

参数:

excelFile - The file .xls or .xlsx

returnClass - the class type when return

返回:

the object list of `returnClass`

抛出:

IOException - io exception

org.apache.poi.openxml4j.exceptions.InvalidFormatException - invalid format

NoSuchMethodException - no such method

IllegalAccessException - illegal access exception

InvocationTargetException - invocation target exception

InstantiationException - instantiation error

ParseException - parse error

writeTo

public void writeTo(File excelFile,
                    List<?>... data)
             throws IOException

Writes the specified data list to an Excel file.

参数:

excelFile - the excel file

data - the specified data list.Multiple sets of data to generate multiple sheets.

抛出:

IOException - io exception

writeTo

public void writeTo(FileSuffix fileSuffix,
                    OutputStream outputStream,
                    List<?>... data)
             throws IOException

Writes the specified data list to an Excel file.

参数:

fileSuffix - File's suffix

outputStream - Output stream

data - the specified data list.Multiple sets of data to generate multiple sheets.

抛出:

IOException - io exception

valueOf

public Object valueOf(org.apache.poi.ss.usermodel.Cell cell)

return cell's value object

参数:

cell - Excel

返回:

Object,eg. String/Double/Date/Boolean/null

setTitleLine

public PbPOIExcelTemplate setTitleLine(int titleLine)

Set excel title line's number(start from 0).Default is 0.

参数:

titleLine - start calculate from not null row

返回:

return object self