cn.orionsec.kit.office.excel.split

Class ExcelColumnMultiSplit

java.lang.Object

cn.orionsec.kit.office.excel.split.ExcelColumnMultiSplit

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable

public class ExcelColumnMultiSplit
extends Object
implements SafeCloseable

excel 列拆分器 拆分多个文件一个sheet 不支持复杂类型 占用内存少 不支持流式读取 (流式只能读取一次) 流式请用 ExcelColumnSingleSplit

Since:

2020/9/8 18:36

Version:

1.0.0

Author:

Jiahang Li

Constructor Summary

Constructors

Constructor and Description
ExcelColumnMultiSplit(org.apache.poi.ss.usermodel.Workbook sourceWorkbook, int sourceSheetIndex)
ExcelColumnMultiSplit(org.apache.poi.ss.usermodel.Workbook sourceWorkbook, org.apache.poi.ss.usermodel.Sheet sourceSheet)
ExcelColumnMultiSplit(org.apache.poi.ss.usermodel.Workbook sourceWorkbook, String sourceSheetName)

Method Summary

Modifier and Type	Method and Description
void	close() 安全关闭
org.apache.poi.ss.usermodel.Sheet	getSourceSheet()
org.apache.poi.ss.usermodel.Workbook	getSourceWorkbook()
ExcelColumnMultiSplit	skip() 跳过头部一行
ExcelColumnMultiSplit	skip(int skip) 跳过头部多行
ExcelColumnMultiSplit	split(int[] columns, File file)
ExcelColumnMultiSplit	split(int[] columns, OutputStream out)
ExcelColumnMultiSplit	split(int[] columns, String file)
ExcelColumnMultiSplit	split(int[] columns, String[] headers, File file)
ExcelColumnMultiSplit	split(int[] columns, String[] headers, OutputStream out)
ExcelColumnMultiSplit	split(int[] columns, String[] headers, String file)
ExcelColumnMultiSplit	split(int[] columns, String[] headers, String password, File file)
ExcelColumnMultiSplit	split(int[] columns, String[] headers, String password, OutputStream out)
ExcelColumnMultiSplit	split(int[] columns, String[] headers, String password, OutputStream out, boolean close) 执行拆分
ExcelColumnMultiSplit	split(int[] columns, String[] headers, String password, String file)
ExcelColumnMultiSplit	split(int[] columns, String password, File file)
ExcelColumnMultiSplit	split(int[] columns, String password, OutputStream out)
ExcelColumnMultiSplit	split(int[] columns, String password, String file)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelColumnMultiSplit

public ExcelColumnMultiSplit(org.apache.poi.ss.usermodel.Workbook sourceWorkbook,
                             int sourceSheetIndex)

ExcelColumnMultiSplit

public ExcelColumnMultiSplit(org.apache.poi.ss.usermodel.Workbook sourceWorkbook,
                             String sourceSheetName)

ExcelColumnMultiSplit

public ExcelColumnMultiSplit(org.apache.poi.ss.usermodel.Workbook sourceWorkbook,
                             org.apache.poi.ss.usermodel.Sheet sourceSheet)

Method Detail

skip

public ExcelColumnMultiSplit skip()

跳过头部一行

Returns:

this

skip

public ExcelColumnMultiSplit skip(int skip)

跳过头部多行

Parameters:

skip - 行数

Returns:

this

split

public ExcelColumnMultiSplit split(int[] columns,
                                   File file)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String[] headers,
                                   File file)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String password,
                                   File file)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String[] headers,
                                   String password,
                                   File file)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String file)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String[] headers,
                                   String file)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String password,
                                   String file)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String[] headers,
                                   String password,
                                   String file)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   OutputStream out)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String[] headers,
                                   OutputStream out)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String password,
                                   OutputStream out)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String[] headers,
                                   String password,
                                   OutputStream out)

split

public ExcelColumnMultiSplit split(int[] columns,
                                   String[] headers,
                                   String password,
                                   OutputStream out,
                                   boolean close)

执行拆分

Parameters:

columns - 列

headers - 表头

password - 保护表格的密码

out - 目标路径

close - 是否关闭

Returns:

this

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

getSourceWorkbook

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

getSourceSheet

public org.apache.poi.ss.usermodel.Sheet getSourceSheet()