A base class used to create cells
| Modifiers | Name | Description |
|---|---|---|
protected static java.util.Map |
LINK_OPTIONS |
|
protected java.util.Map<java.lang.Object, java.lang.Integer> |
columnIndexes |
|
protected java.util.Map |
defaultOptions |
|
protected org.apache.poi.xssf.usermodel.XSSFSheet |
sheet |
|
protected CellStyleBuilder |
styleBuilder |
|
protected org.apache.poi.xssf.usermodel.XSSFWorkbook |
workbook |
| Constructor and description |
|---|
CreatesCells
(org.apache.poi.xssf.usermodel.XSSFSheet sheet, java.util.Map defaultOptions, java.util.Map<java.lang.Object, java.lang.Integer> columnIndexes, CellStyleBuilder styleBuilder) |
| Type | Name and description |
|---|---|
org.apache.poi.xssf.usermodel.XSSFCell |
cell()Creates a new blank cell |
org.apache.poi.xssf.usermodel.XSSFCell |
cell(java.lang.Object value)Creates a new cell and assigns a value |
org.apache.poi.xssf.usermodel.XSSFCell |
cell(java.lang.Object value, java.util.Map style)Creates a new cell with a value and style |
org.apache.poi.xssf.usermodel.XSSFCell |
column(java.lang.String value, java.lang.Object id, java.util.Map style = null)Creates a header cell |
void |
defaultStyle(java.util.Map options)Sets the default styles to use for the given row or column |
org.apache.poi.xssf.usermodel.XSSFCell |
formula(java.lang.String formulaString, java.util.Map style)Assigns a formula to a new cell |
org.apache.poi.xssf.usermodel.XSSFCell |
formula(java.lang.String formulaString)Assigns a formula to a new cell |
org.apache.poi.xssf.usermodel.XSSFCell |
formula(groovy.lang.Closure callable)Assigns a formula to a new cell |
org.apache.poi.xssf.usermodel.XSSFCell |
formula(java.util.Map style, groovy.lang.Closure callable)Assigns a formula to a new cell |
protected CellRangeBorderStyleApplier |
getBorderStyleApplier(org.apache.poi.ss.util.CellRangeAddress range, org.apache.poi.xssf.usermodel.XSSFSheet sheet) |
protected int |
getMergeIndex() |
protected org.apache.poi.ss.util.CellRangeAddress |
getRange(int start, int end) |
protected org.apache.poi.xssf.usermodel.XSSFCell |
handleLink(org.apache.poi.xssf.usermodel.XSSFCell cell, java.lang.String address, org.apache.poi.common.usermodel.HyperlinkType linkType) |
org.apache.poi.xssf.usermodel.XSSFCell |
link(java.lang.Object value, java.lang.String address, int linkType)Creates a cell with a hyperlink |
org.apache.poi.xssf.usermodel.XSSFCell |
link(java.lang.Object value, java.lang.String address, org.apache.poi.common.usermodel.HyperlinkType linkType)Creates a cell with a hyperlink |
org.apache.poi.xssf.usermodel.XSSFCell |
link(java.lang.Object value, groovy.lang.Closure callable)Creates a cell with a hyperlink to another cell in the document |
void |
merge(java.util.Map style, groovy.lang.Closure callable)Merges cells |
void |
merge(groovy.lang.Closure callable)Merges cells |
void |
merge(java.lang.Object value, java.lang.Integer count, java.util.Map style = null)Merges cells |
protected org.apache.poi.xssf.usermodel.XSSFCell |
nextCell() |
protected void |
performMerge(java.util.Map style, groovy.lang.Closure callable) |
protected void |
setStyle(java.lang.Object value, org.apache.poi.xssf.usermodel.XSSFCell cell, java.util.Map options) |
void |
skipCells(int num)Skips cells |
| Methods inherited from class | Name |
|---|---|
class java.lang.Object |
java.lang.Object#wait(long, int), java.lang.Object#wait(long), java.lang.Object#wait(), java.lang.Object#equals(java.lang.Object), java.lang.Object#toString(), java.lang.Object#hashCode(), java.lang.Object#getClass(), java.lang.Object#notify(), java.lang.Object#notifyAll() |
Creates a new blank cell
Creates a new cell and assigns a value
value - The value to assignCreates a new cell with a value and style
value - The value to assignstyle - The cell style optionsCreates a header cell
value - The cell valueid - The cell identiferstyle - The cell styleSets the default styles to use for the given row or column
options - The style optionsAssigns a formula to a new cell
formulaString - The formulastyle - The cell styleAssigns a formula to a new cell
formulaString - The formulaAssigns a formula to a new cell
callable - The return value will be assigned to the cell formula. The closure delegate contains helper methods to get references to other cells.Assigns a formula to a new cell
style - The cell stylecallable - The return value will be assigned to the cell formula. The closure delegate contains helper methods to get references to other cells.Creates a cell with a hyperlink
value - The cell valueaddress - The link addresslinkType - The type of link. One of org.apache.poi.common.usermodel.Hyperlink#LINK_URL, org.apache.poi.common.usermodel.Hyperlink#LINK_EMAIL, org.apache.poi.common.usermodel.Hyperlink#LINK_FILECreates a cell with a hyperlink
value - The cell valueaddress - The link addresslinkType - The type of link. One of org.apache.poi.common.usermodel.HyperlinkType#URL, org.apache.poi.common.usermodel.HyperlinkType#EMAIL, org.apache.poi.common.usermodel.HyperlinkType#FILECreates a cell with a hyperlink to another cell in the document
value - The cell valuecallable - The closure to build the linkMerges cells
style - Default styles for merged cellscallable - To build cell dataMerges cells
callable - To build cell dataMerges cells
value - The cell contentcount - How many cells to mergestyle - Styling for the merged cellSkips cells
num - The number of cells to skip