cn.hutool.poi.excel

Class RowUtil

java.lang.Object

cn.hutool.poi.excel.RowUtil

public class RowUtil
extends Object

Excel中的行Row封装工具类

Since:

4.0.7

Author:

looly

Constructor Summary

Constructors

Constructor and Description
RowUtil()

Method Summary

Modifier and Type	Method and Description
static org.apache.poi.ss.usermodel.Row	getOrCreateRow(org.apache.poi.ss.usermodel.Sheet sheet, int rowIndex) 获取已有行或创建新行
static List<Object>	readRow(org.apache.poi.ss.usermodel.Row row, CellEditor cellEditor) 读取一行
static void	writeRow(org.apache.poi.ss.usermodel.Row row, Iterable<?> rowData, StyleSet styleSet, boolean isHeader) 写一行数据

Methods inherited from class java.lang.Object

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

Constructor Detail

RowUtil

public RowUtil()

Method Detail

getOrCreateRow

public static org.apache.poi.ss.usermodel.Row getOrCreateRow(org.apache.poi.ss.usermodel.Sheet sheet,
                                                             int rowIndex)

获取已有行或创建新行

Parameters:

sheet - Excel表

rowIndex - 行号

Returns:

Row

Since:

4.0.2

readRow

public static List<Object> readRow(org.apache.poi.ss.usermodel.Row row,
                                   CellEditor cellEditor)

读取一行

Parameters:

row - 行

cellEditor - 单元格编辑器

Returns:

单元格值列表

writeRow

public static void writeRow(org.apache.poi.ss.usermodel.Row row,
                            Iterable<?> rowData,
                            StyleSet styleSet,
                            boolean isHeader)

写一行数据

Parameters:

row - 行

rowData - 一行的数据

styleSet - 单元格样式集，包括日期等样式

isHeader - 是否为标题行