cn.orionsec.kit.office.excel

Class ExcelExt

java.lang.Object

cn.orionsec.kit.office.excel.ExcelExt

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable

public class ExcelExt
extends Object
implements SafeCloseable

excel 提取器

使用流式读取文件必须是 xlsx 文件

Since:

2020/4/6 12:51

Version:

1.0.0

Author:

Jiahang Li

Constructor Summary

Constructors

Constructor and Description
ExcelExt(File file)
ExcelExt(File file, boolean streaming)
ExcelExt(File file, String password)
ExcelExt(File file, String password, boolean streaming)
ExcelExt(InputStream in)
ExcelExt(InputStream in, boolean streaming)
ExcelExt(InputStream in, String password)
ExcelExt(InputStream in, String password, boolean streaming)
ExcelExt(InputStream in, String password, boolean streaming, boolean close)
ExcelExt(String file)
ExcelExt(String file, boolean streaming)
ExcelExt(String file, String password)
ExcelExt(String file, String password, boolean streaming)
ExcelExt(org.apache.poi.ss.usermodel.Workbook workbook)

Method Summary

Modifier and Type	Method and Description
ExcelArrayReader	arrayReader(int sheetIndex)
ExcelArrayReader	arrayReader(int sheetIndex, Consumer<String[]> consumer)
ExcelArrayReader	arrayReader(int sheetIndex, List<String[]> rows)
ExcelArrayReader	arrayReader(String sheetName)
ExcelArrayReader	arrayReader(String sheetName, Consumer<String[]> consumer)
ExcelArrayReader	arrayReader(String sheetName, List<String[]> rows)
<T> ExcelBeanReader<T>	beanReader(int sheetIndex, Class<T> targetClass)
<T> ExcelBeanReader<T>	beanReader(int sheetIndex, Class<T> targetClass, Consumer<T> consumer)
<T> ExcelBeanReader<T>	beanReader(int sheetIndex, Class<T> targetClass, List<T> rows)
<T> ExcelBeanReader<T>	beanReader(String sheetName, Class<T> targetClass)
<T> ExcelBeanReader<T>	beanReader(String sheetName, Class<T> targetClass, Consumer<T> consumer)
<T> ExcelBeanReader<T>	beanReader(String sheetName, Class<T> targetClass, List<T> rows)
void	close() 安全关闭
org.apache.poi.ss.usermodel.Workbook	getWorkbook()
boolean	isStreaming()
<T> ExcelLambdaReader<T>	lambdaReader(int sheetIndex, Consumer<T> consumer, Supplier<T> supplier)
<T> ExcelLambdaReader<T>	lambdaReader(int sheetIndex, List<T> rows, Supplier<T> supplier)
<T> ExcelLambdaReader<T>	lambdaReader(int sheetIndex, Supplier<T> supplier)
<T> ExcelLambdaReader<T>	lambdaReader(String sheetName, Consumer<T> consumer, Supplier<T> supplier)
<T> ExcelLambdaReader<T>	lambdaReader(String sheetName, List<T> rows, Supplier<T> supplier)
<T> ExcelLambdaReader<T>	lambdaReader(String sheetName, Supplier<T> supplier)
<K,V> ExcelMapReader<K,V>	mapReader(int sheetIndex)
<K,V> ExcelMapReader<K,V>	mapReader(int sheetIndex, Consumer<MutableMap<K,V>> consumer)
<K,V> ExcelMapReader<K,V>	mapReader(int sheetIndex, List<MutableMap<K,V>> rows)
<K,V> ExcelMapReader<K,V>	mapReader(String sheetName)
<K,V> ExcelMapReader<K,V>	mapReader(String sheetName, Consumer<MutableMap<K,V>> consumer)
<K,V> ExcelMapReader<K,V>	mapReader(String sheetName, List<MutableMap<K,V>> rows)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelExt

public ExcelExt(File file)

ExcelExt

public ExcelExt(File file,
                boolean streaming)

ExcelExt

public ExcelExt(File file,
                String password)

ExcelExt

public ExcelExt(File file,
                String password,
                boolean streaming)

ExcelExt

public ExcelExt(String file)

ExcelExt

public ExcelExt(String file,
                boolean streaming)

ExcelExt

public ExcelExt(String file,
                String password)

ExcelExt

public ExcelExt(String file,
                String password,
                boolean streaming)

ExcelExt

public ExcelExt(InputStream in)

ExcelExt

public ExcelExt(InputStream in,
                boolean streaming)

ExcelExt

public ExcelExt(InputStream in,
                String password)

ExcelExt

public ExcelExt(InputStream in,
                String password,
                boolean streaming)

ExcelExt

public ExcelExt(InputStream in,
                String password,
                boolean streaming,
                boolean close)

ExcelExt

public ExcelExt(org.apache.poi.ss.usermodel.Workbook workbook)

Method Detail

arrayReader

public ExcelArrayReader arrayReader(int sheetIndex)

arrayReader

public ExcelArrayReader arrayReader(String sheetName)

arrayReader

public ExcelArrayReader arrayReader(int sheetIndex,
                                    List<String[]> rows)

arrayReader

public ExcelArrayReader arrayReader(String sheetName,
                                    List<String[]> rows)

arrayReader

public ExcelArrayReader arrayReader(int sheetIndex,
                                    Consumer<String[]> consumer)

arrayReader

public ExcelArrayReader arrayReader(String sheetName,
                                    Consumer<String[]> consumer)

mapReader

public <K,V> ExcelMapReader<K,V> mapReader(int sheetIndex)

mapReader

public <K,V> ExcelMapReader<K,V> mapReader(String sheetName)

mapReader

public <K,V> ExcelMapReader<K,V> mapReader(int sheetIndex,
                                           List<MutableMap<K,V>> rows)

mapReader

public <K,V> ExcelMapReader<K,V> mapReader(String sheetName,
                                           List<MutableMap<K,V>> rows)

mapReader

public <K,V> ExcelMapReader<K,V> mapReader(int sheetIndex,
                                           Consumer<MutableMap<K,V>> consumer)

mapReader

public <K,V> ExcelMapReader<K,V> mapReader(String sheetName,
                                           Consumer<MutableMap<K,V>> consumer)

beanReader

public <T> ExcelBeanReader<T> beanReader(int sheetIndex,
                                         Class<T> targetClass)

beanReader

public <T> ExcelBeanReader<T> beanReader(String sheetName,
                                         Class<T> targetClass)

beanReader

public <T> ExcelBeanReader<T> beanReader(int sheetIndex,
                                         Class<T> targetClass,
                                         List<T> rows)

beanReader

public <T> ExcelBeanReader<T> beanReader(String sheetName,
                                         Class<T> targetClass,
                                         List<T> rows)

beanReader

public <T> ExcelBeanReader<T> beanReader(int sheetIndex,
                                         Class<T> targetClass,
                                         Consumer<T> consumer)

beanReader

public <T> ExcelBeanReader<T> beanReader(String sheetName,
                                         Class<T> targetClass,
                                         Consumer<T> consumer)

lambdaReader

public <T> ExcelLambdaReader<T> lambdaReader(int sheetIndex,
                                             Supplier<T> supplier)

lambdaReader

public <T> ExcelLambdaReader<T> lambdaReader(String sheetName,
                                             Supplier<T> supplier)

lambdaReader

public <T> ExcelLambdaReader<T> lambdaReader(int sheetIndex,
                                             List<T> rows,
                                             Supplier<T> supplier)

lambdaReader

public <T> ExcelLambdaReader<T> lambdaReader(String sheetName,
                                             List<T> rows,
                                             Supplier<T> supplier)

lambdaReader

public <T> ExcelLambdaReader<T> lambdaReader(int sheetIndex,
                                             Consumer<T> consumer,
                                             Supplier<T> supplier)

lambdaReader

public <T> ExcelLambdaReader<T> lambdaReader(String sheetName,
                                             Consumer<T> consumer,
                                             Supplier<T> supplier)

getWorkbook

public org.apache.poi.ss.usermodel.Workbook getWorkbook()

isStreaming

public boolean isStreaming()

close

public void close()

Description copied from interface: SafeCloseable

安全关闭

Specified by:

close in interface SafeCloseable

Specified by:

close in interface Closeable

Specified by:

close in interface AutoCloseable