cn.orionsec.kit.office.csv.convert.adapter

Class ExcelAdapter

java.lang.Object

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

cn.orionsec.kit.office.csv.convert.adapter.ExcelAdapter

All Implemented Interfaces:

Adaptable<ExcelAdapter>, SafeCloseable, Closeable, AutoCloseable

public class ExcelAdapter
extends BaseExcelWriteable
implements Adaptable<ExcelAdapter>, SafeCloseable

csv -> excel 文本适配器

Since:

2020/9/18 2: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
ExcelAdapter(CsvArrayReader reader)
ExcelAdapter(CsvExt csvExt)

Method Summary

Modifier and Type	Method and Description
ExcelAdapter	bufferLine(int bufferLine) 设置 读取行缓冲区
void	close() 关闭workbook
ExcelAdapter	forNew() 适配为新对象
CsvArrayReader	getReader()
org.apache.poi.ss.usermodel.Sheet	getSheet()
ExcelAdapter	header(String... header) 设置Excel表头
ExcelAdapter	skip() 跳过一行
ExcelAdapter	skip(int i) 跳过行多

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

ExcelAdapter

public ExcelAdapter(CsvExt csvExt)

ExcelAdapter

public ExcelAdapter(CsvArrayReader reader)

Method Detail

bufferLine

public ExcelAdapter bufferLine(int bufferLine)

设置 读取行缓冲区

Parameters:

bufferLine - 缓冲区行数

Returns:

this

skip

public ExcelAdapter skip()

跳过一行

Returns:

this

skip

public ExcelAdapter skip(int i)

跳过行多

Parameters:

i - 行

Returns:

this

header

public ExcelAdapter header(String... header)

设置Excel表头

Parameters:

header - 头

Returns:

this

forNew

public ExcelAdapter forNew()

Description copied from interface: Adaptable

适配为新对象

Specified by:

forNew in interface Adaptable<ExcelAdapter>

Returns:

N

close

public void close()

关闭workbook

Specified by:

close in interface SafeCloseable

Specified by:

close in interface Closeable

Specified by:

close in interface AutoCloseable

Overrides:

close in class BaseExcelWriteable

getSheet

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

getReader

public CsvArrayReader getReader()