cn.orionsec.kit.office.excel.split

Class ExcelColumnSingleSplit

java.lang.Object

cn.orionsec.kit.office.excel.writer.BaseExcelWriteable

cn.orionsec.kit.office.excel.split.ExcelColumnSingleSplit

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable

public class ExcelColumnSingleSplit
extends BaseExcelWriteable

excel 列拆分器 拆分一个文件一个sheet 不支持复杂类型 占用内存少

Since:

2020/9/8 18:36

Version:

1.0.0

Author:

Jiahang Li

Field Summary

Fields

Modifier and Type	Field and Description
org.apache.poi.ss.usermodel.Sheet	sourceSheet source sheet
org.apache.poi.ss.usermodel.Sheet	targetSheet target sheet

Fields inherited from class cn.orionsec.kit.office.excel.writer.BaseExcelWriteable

workbook

Constructor Summary

Constructors

Constructor and Description
ExcelColumnSingleSplit(org.apache.poi.ss.usermodel.Workbook sourceWorkbook, org.apache.poi.ss.usermodel.Sheet sourceSheet, int... columns)

Method Summary

Modifier and Type	Method and Description
void	close() 安全关闭
int[]	getColumns()
org.apache.poi.ss.usermodel.Sheet	getSourceSheet()
org.apache.poi.ss.usermodel.Workbook	getSourceWorkbook()
org.apache.poi.ss.usermodel.Sheet	getTargetSheet()
org.apache.poi.ss.usermodel.Workbook	getTargetWorkbook()
ExcelColumnSingleSplit	header(String... headers) 设置表头
ExcelColumnSingleSplit	protect(String password) 保护表格
ExcelColumnSingleSplit	skip() 跳过头部一行
ExcelColumnSingleSplit	skip(int skip) 跳过头部多行
ExcelColumnSingleSplit	split() 执行拆分

Methods inherited from class cn.orionsec.kit.office.excel.writer.BaseExcelWriteable

getWorkbook, write, write, write, write, write, write, write

Methods inherited from class java.lang.Object

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

Field Detail

sourceSheet

public org.apache.poi.ss.usermodel.Sheet sourceSheet

source sheet

targetSheet

public org.apache.poi.ss.usermodel.Sheet targetSheet

target sheet

Constructor Detail

ExcelColumnSingleSplit

public ExcelColumnSingleSplit(org.apache.poi.ss.usermodel.Workbook sourceWorkbook,
                              org.apache.poi.ss.usermodel.Sheet sourceSheet,
                              int... columns)

Method Detail

skip

public ExcelColumnSingleSplit skip()

跳过头部一行

Returns:

this

skip

public ExcelColumnSingleSplit skip(int skip)

跳过头部多行

Parameters:

skip - 行数

Returns:

this

header

public ExcelColumnSingleSplit header(String... headers)

设置表头

Parameters:

headers - 文件的表头

Returns:

ignore

split

public ExcelColumnSingleSplit split()

执行拆分

Returns:

this

protect

public ExcelColumnSingleSplit protect(String password)

保护表格

Parameters:

password - password

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

Overrides:

close in class BaseExcelWriteable

getSourceWorkbook

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

getSourceSheet

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

getTargetWorkbook

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

getTargetSheet

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

getColumns

public int[] getColumns()