cn.orionsec.kit.office.excel.merge

Class ExcelMerge

java.lang.Object

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

cn.orionsec.kit.office.excel.merge.ExcelMerge

All Implemented Interfaces:

SafeCloseable, Closeable, AutoCloseable

public class ExcelMerge
extends BaseExcelWriteable

excel 行合并器 不支持复杂操作

Since:

2020/9/9 1:07

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
ExcelMerge()
ExcelMerge(org.apache.poi.ss.usermodel.Workbook sourceWorkbook, org.apache.poi.ss.usermodel.Sheet sourceSheet)

Method Summary

Modifier and Type	Method and Description
org.apache.poi.ss.usermodel.Sheet	getSourceSheet()
org.apache.poi.ss.usermodel.Workbook	getSourceWorkbook()
ExcelMerge	height(int height) 行高
ExcelMerge	merge(org.apache.poi.ss.usermodel.Sheet sheet) 执行合并
ExcelMerge	protect(String password) 保护表格
ExcelMerge	skip() 跳过行
ExcelMerge	skip(int skip) 跳过多行
ExcelMerge	skipRows() 跳过一行合并sheet
ExcelMerge	skipRows(int skip) 跳过多行合并sheet
ExcelMerge	width(int width) 设置默认行宽
ExcelMerge	width(int column, int width) 设置行宽

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

close, 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

ExcelMerge

public ExcelMerge()

ExcelMerge

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

Method Detail

skip

public ExcelMerge skip()

跳过行

Returns:

this

skip

public ExcelMerge skip(int skip)

跳过多行

Parameters:

skip - skip

Returns:

this

skipRows

public ExcelMerge skipRows()

跳过一行合并sheet

Returns:

this

skipRows

public ExcelMerge skipRows(int skip)

跳过多行合并sheet

Parameters:

skip - skip

Returns:

this

width

public ExcelMerge width(int column,
                        int width)

设置行宽

Parameters:

column - 列索引

width - 行宽

Returns:

this

width

public ExcelMerge width(int width)

设置默认行宽

Parameters:

width - 行宽

Returns:

this

height

public ExcelMerge height(int height)

行高

Parameters:

height - 行高

Returns:

this

merge

public ExcelMerge merge(org.apache.poi.ss.usermodel.Sheet sheet)

执行合并

Parameters:

sheet - 合并sheet

Returns:

this

protect

public ExcelMerge protect(String password)

保护表格

Parameters:

password - password

Returns:

this

getSourceWorkbook

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

getSourceSheet

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