cn.orionsec.kit.office.excel.split

Class ExcelColumnMultiSheetSplit

java.lang.Object

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

cn.orionsec.kit.office.excel.split.ExcelColumnMultiSheetSplit

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable

public class ExcelColumnMultiSheetSplit
extends BaseExcelWriteable

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

Since:

2020/9/8 18:36

Version:

1.0.0

Author:

Jiahang Li

Field Summary

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

workbook

Constructor Summary

Constructors

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

Method Summary

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

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

Constructor Detail

ExcelColumnMultiSheetSplit

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

ExcelColumnMultiSheetSplit

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

ExcelColumnMultiSheetSplit

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

Method Detail

skip

public ExcelColumnMultiSheetSplit skip()

跳过头部一行

Returns:

this

skip

public ExcelColumnMultiSheetSplit skip(int skip)

跳过头部多行

Parameters:

skip - 行数

Returns:

this

split

public ExcelColumnMultiSheetSplit split(int... columns)

执行拆分

Parameters:

columns - 列

Returns:

this

split

public ExcelColumnMultiSheetSplit split(int[] columns,
                                        String[] headers)

执行拆分

Parameters:

columns - 列

headers - 表头

Returns:

this

split

public ExcelColumnMultiSheetSplit split(int[] columns,
                                        String password)

执行拆分

Parameters:

columns - 列

password - 保护表格的密码

Returns:

this

split

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

执行拆分

Parameters:

columns - 列

headers - 表头

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()

getSheetNum

public int getSheetNum()