cn.orionsec.kit.office.excel.split

Class ExcelRowSplit

java.lang.Object

cn.orionsec.kit.office.support.SplitTargetGenerator

cn.orionsec.kit.office.excel.split.ExcelRowSplit

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable

public class ExcelRowSplit
extends SplitTargetGenerator

excel 行拆分器 能拆分多个文件一个sheet 不支持复杂类型

Since:

2020/8/21 16:01

Version:

1.0.0

Author:

Jiahang Li

Field Summary

Fields

Modifier and Type	Field and Description
org.apache.poi.ss.usermodel.Sheet	sheet sheet

Fields inherited from class cn.orionsec.kit.office.support.SplitTargetGenerator

autoClose, currentOutputStream, currentTargetIndex, generatorBaseName, generatorNameSuffix, generatorPathDir, suffix, targets

Constructor Summary

Constructors

Constructor and Description
ExcelRowSplit(org.apache.poi.ss.usermodel.Sheet sheet, int limit)

Method Summary

Modifier and Type	Method and Description
ExcelRowSplit	columns(int... columns) 设置读取的列
ExcelRowSplit	columnSize(int columnSize) 设置列数 用于设置列宽
int	getLimit()
org.apache.poi.ss.usermodel.Sheet	getSheet()
ExcelRowSplit	header(String... header) 设置表头
ExcelRowSplit	protect(String password) 保护表格
ExcelRowSplit	skip() 跳过头部一行
ExcelRowSplit	skip(int skip) 跳过头部多行
ExcelRowSplit	split() 执行拆分

Methods inherited from class cn.orionsec.kit.office.support.SplitTargetGenerator

autoClose, close, generatorOutputStream, hasNext, next, target, target, target, targetPath, targetPath

Methods inherited from class java.lang.Object

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

Field Detail

sheet

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

sheet

Constructor Detail

ExcelRowSplit

public ExcelRowSplit(org.apache.poi.ss.usermodel.Sheet sheet,
                     int limit)

Method Detail

protect

public ExcelRowSplit protect(String password)

保护表格

Parameters:

password - password

Returns:

this

skip

public ExcelRowSplit skip()

跳过头部一行

Returns:

this

skip

public ExcelRowSplit skip(int skip)

跳过头部多行

Parameters:

skip - 行数

Returns:

this

columns

public ExcelRowSplit columns(int... columns)

设置读取的列

Parameters:

columns - 列

Returns:

this

columnSize

public ExcelRowSplit columnSize(int columnSize)

设置列数 用于设置列宽

Parameters:

columnSize - 列数

Returns:

this

header

public ExcelRowSplit header(String... header)

设置表头

Parameters:

header - 表头

Returns:

ignore

split

public ExcelRowSplit split()

执行拆分

Returns:

this

getSheet

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

getLimit

public int getLimit()