Field Detail

• protected static final java.util.Map LINK_OPTIONS

• protected final java.util.Map<java.lang.Object, java.lang.Integer> columnIndexes

• protected java.util.Map defaultOptions

• protected final org.apache.poi.xssf.usermodel.XSSFSheet sheet

• protected final CellStyleBuilder styleBuilder

• protected final org.apache.poi.xssf.usermodel.XSSFWorkbook workbook

Constructor Detail

• CreatesCells(org.apache.poi.xssf.usermodel.XSSFSheet sheet, java.util.Map defaultOptions, java.util.Map<java.lang.Object, java.lang.Integer> columnIndexes, CellStyleBuilder styleBuilder)

Method Detail

• org.apache.poi.xssf.usermodel.XSSFCell cell()

  Creates a new blank cell

  Returns:

  The native cell

• org.apache.poi.xssf.usermodel.XSSFCell cell(java.lang.Object value)

  Creates a new cell and assigns a value

  Parameters:

  value - The value to assign

  Returns:

  The native cell

• org.apache.poi.xssf.usermodel.XSSFCell cell(java.lang.Object value, java.util.Map style)

  Creates a new cell with a value and style

  Parameters:

  value - The value to assign

  style - The cell style options

  Returns:

  The native cell

• org.apache.poi.xssf.usermodel.XSSFCell column(java.lang.String value, java.lang.Object id, java.util.Map style = null)

  Creates a header cell

  Parameters:

  value - The cell value

  id - The cell identifer

  style - The cell style

  Returns:

  The native cell

• void defaultStyle(java.util.Map options)

  Sets the default styles to use for the given row or column

  Parameters:

  options - The style options

• org.apache.poi.xssf.usermodel.XSSFCell formula(java.lang.String formulaString, java.util.Map style)

  Assigns a formula to a new cell

  Parameters:

  formulaString - The formula

  style - The cell style

  Returns:

  The native cell

• org.apache.poi.xssf.usermodel.XSSFCell formula(java.lang.String formulaString)

  Assigns a formula to a new cell

  Parameters:

  formulaString - The formula

  Returns:

  The native cell

• org.apache.poi.xssf.usermodel.XSSFCell formula(@groovy.lang.DelegatesTo(strategy = Closure.DELEGATE_FIRST, value = CellFinder) groovy.lang.Closure callable)

  Assigns a formula to a new cell

  Parameters:

  callable - The return value will be assigned to the cell formula. The closure delegate contains helper methods to get references to other cells.

  Returns:

  The native cell

• org.apache.poi.xssf.usermodel.XSSFCell formula(java.util.Map style, @groovy.lang.DelegatesTo(strategy = Closure.DELEGATE_FIRST, value = CellFinder) groovy.lang.Closure callable)

  Assigns a formula to a new cell

  Parameters:

  style - The cell style

  callable - The return value will be assigned to the cell formula. The closure delegate contains helper methods to get references to other cells.

  Returns:

  The native 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)

• @java.lang.Deprecated org.apache.poi.xssf.usermodel.XSSFCell link(java.lang.Object value, java.lang.String address, int linkType)

  Creates a cell with a hyperlink

  deprecated:

  Use link

  Parameters:

  value - The cell value

  address - The link address

  linkType - 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_FILE

  Returns:

  The native cell

• 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

  Parameters:

  value - The cell value

  address - The link address

  linkType - 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#FILE

  Returns:

  The native cell

• org.apache.poi.xssf.usermodel.XSSFCell link(java.lang.Object value, @groovy.lang.DelegatesTo(strategy = Closure.DELEGATE_FIRST, value = CellFinder) groovy.lang.Closure callable)

  Creates a cell with a hyperlink to another cell in the document

  Parameters:

  value - The cell value

  callable - The closure to build the link

  Returns:

  The native cell

• void merge(java.util.Map style, groovy.lang.Closure callable)

  Merges cells

  Parameters:

  style - Default styles for merged cells

  callable - To build cell data

• void merge(groovy.lang.Closure callable)

  Merges cells

  Parameters:

  callable - To build cell data

• void merge(java.lang.Object value, java.lang.Integer count, java.util.Map style = null)

  Merges cells

  Parameters:

  value - The cell content

  count - How many cells to merge

  style - Styling for the merged cell

• 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

  Parameters:

  num - The number of cells to skip