cn.orionsec.kit.office.excel.copy

Class SheetCopier

java.lang.Object

cn.orionsec.kit.office.excel.copy.SheetCopier

public class SheetCopier
extends Object

拷贝Sheet 只能拷贝简单的对象 拷贝的列宽有些许差异 Streaming不适用

Since:

2020/6/4 12:03

Version:

1.0.0

Author:

Jiahang Li

Constructor Summary

Constructors

Constructor and Description
SheetCopier(org.apache.poi.ss.usermodel.Workbook sourceWorkbook, org.apache.poi.ss.usermodel.Workbook targetWorkbook, org.apache.poi.ss.usermodel.Sheet sourceSheet, org.apache.poi.ss.usermodel.Sheet targetSheet)

Method Summary

Modifier and Type	Method and Description
SheetCopier	column(int column) 设置列数 用于设置列宽
void	copy() copy
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()

Methods inherited from class java.lang.Object

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

Constructor Detail

SheetCopier

public SheetCopier(org.apache.poi.ss.usermodel.Workbook sourceWorkbook,
                   org.apache.poi.ss.usermodel.Workbook targetWorkbook,
                   org.apache.poi.ss.usermodel.Sheet sourceSheet,
                   org.apache.poi.ss.usermodel.Sheet targetSheet)

Method Detail

copy

public void copy()

copy

column

public SheetCopier column(int column)

设置列数 用于设置列宽

Parameters:

column - 列数

Returns:

this

getSourceWorkbook

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

getTargetWorkbook

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

getSourceSheet

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

getTargetSheet

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