org.dromara.hutool.poi.excel.cell

Class MergedCell

java.lang.Object

org.dromara.hutool.poi.excel.cell.MergedCell

public class MergedCell
extends Object

合并单元格封装

Since:

6.0.0

Author:

Looly

Constructor Summary

Constructors

Constructor and Description
MergedCell(org.apache.poi.ss.usermodel.Cell first, org.apache.poi.ss.util.CellRangeAddress range) 构造

Method Summary

Modifier and Type	Method and Description
org.apache.poi.ss.usermodel.Cell	getFirst() 获取第一个单元格，即左上角的单元格
org.apache.poi.ss.util.CellRangeAddress	getRange() 获取合并单元格范围
static MergedCell	of(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.util.CellRangeAddress range) 创建MergedCell
static MergedCell	of(org.apache.poi.ss.usermodel.Cell cell, int rowCount, int columnCount) 创建MergedCell
MergedCell	setCellStyle(org.apache.poi.ss.usermodel.CellStyle cellStyle) 设置单元格样式
MergedCell	setValue(Object value) 设置单元格值

Methods inherited from class java.lang.Object

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

Constructor Detail

MergedCell

public MergedCell(org.apache.poi.ss.usermodel.Cell first,
                  org.apache.poi.ss.util.CellRangeAddress range)

构造

Parameters:

first - 第一个单元格，即左上角的单元格

range - 合并单元格范围

Method Detail

of

public static MergedCell of(org.apache.poi.ss.usermodel.Cell cell,
                            int rowCount,
                            int columnCount)

创建MergedCell

Parameters:

cell - 第一个单元格，即左上角的单元格

rowCount - 占用行数

columnCount - 占用列数

Returns:

MergedCell

of

public static MergedCell of(org.apache.poi.ss.usermodel.Cell cell,
                            org.apache.poi.ss.util.CellRangeAddress range)

创建MergedCell

Parameters:

cell - 第一个单元格，即左上角的单元格

range - 合并单元格范围

Returns:

MergedCell

getFirst

public org.apache.poi.ss.usermodel.Cell getFirst()

获取第一个单元格，即左上角的单元格

Returns:

Cell

getRange

public org.apache.poi.ss.util.CellRangeAddress getRange()

获取合并单元格范围

Returns:

CellRangeAddress

setCellStyle

public MergedCell setCellStyle(org.apache.poi.ss.usermodel.CellStyle cellStyle)

设置单元格样式

Parameters:

cellStyle - 单元格样式

Returns:

this

setValue

public MergedCell setValue(Object value)

设置单元格值

Parameters:

value - 值

Returns:

this