Groovy Documentation

src.groovy.de.andreasschmitt.export.builder
Class ExcelBuilder

java.lang.Object
  groovy.lang.GroovyObjectSupport
      groovy.util.BuilderSupport
          src.groovy.de.andreasschmitt.export.builder.ExcelBuilder

class ExcelBuilder
extends groovy.util.BuilderSupport

author:
Andreas Schmitt This class implements a Groovy builder for creating Excel files. It uses JExcelApi under the hood to build the actual Excel files. The builder supports basic formatting and multiple sheets. Formulas and more advanced features are not supported yet. The following code snippet shows how to create Excel files using this builder: def builder = new ExcelBuilder() builder { workbook(outputStream: outputStream){ sheet(name: "Sheet1"){ format(name: "format1"){ font(name: "Arial", size: 10, bold: true, underline: "single", italic: true) } cell(row: 0, column: 0, value: "Hello1") cell(row: 0, column: 1, value: "Hello2") } sheet(name: "Sheet2"){ } } } builder.write()


Property Summary
java.lang.String format

java.util.Map formats

private static org.apache.commons.logging.Log log

jxl.write.WritableSheet sheet

jxl.write.WritableWorkbook workbook

 
Constructor Summary
ExcelBuilder()

 
Method Summary
protected java.lang.Object createNode(java.lang.Object name)

protected java.lang.Object createNode(java.lang.Object name, java.lang.Object value)

This method isn't implemented.

protected java.lang.Object createNode(java.lang.Object name, java.util.Map attributes)

This method is invoked when you invoke a method with a map of attributes e.g.

protected java.lang.Object createNode(java.lang.Object name, java.util.Map attributes, java.lang.Object value)

This method isn't implemented.

protected void setParent(java.lang.Object parent, java.lang.Object child)

void write()

Finish writing the document.

 
Methods inherited from class groovy.util.BuilderSupport
groovy.util.BuilderSupport#invokeMethod(java.lang.String), groovy.util.BuilderSupport#invokeMethod(java.lang.String, java.lang.Object), groovy.util.BuilderSupport#setProperty(java.lang.String, java.lang.Object), groovy.util.BuilderSupport#getProperty(java.lang.String), groovy.util.BuilderSupport#getMetaClass(), groovy.util.BuilderSupport#setMetaClass(groovy.lang.MetaClass), groovy.util.BuilderSupport#wait(long), groovy.util.BuilderSupport#wait(long, int), groovy.util.BuilderSupport#wait(), groovy.util.BuilderSupport#hashCode(), groovy.util.BuilderSupport#getClass(), groovy.util.BuilderSupport#equals(java.lang.Object), groovy.util.BuilderSupport#toString(), groovy.util.BuilderSupport#notify(), groovy.util.BuilderSupport#notifyAll()
 
Methods inherited from class groovy.lang.GroovyObjectSupport
groovy.lang.GroovyObjectSupport#setProperty(java.lang.String, java.lang.Object), groovy.lang.GroovyObjectSupport#getProperty(java.lang.String), groovy.lang.GroovyObjectSupport#invokeMethod(java.lang.String, java.lang.Object), groovy.lang.GroovyObjectSupport#getMetaClass(), groovy.lang.GroovyObjectSupport#setMetaClass(groovy.lang.MetaClass), groovy.lang.GroovyObjectSupport#wait(long), groovy.lang.GroovyObjectSupport#wait(long, int), groovy.lang.GroovyObjectSupport#wait(), groovy.lang.GroovyObjectSupport#hashCode(), groovy.lang.GroovyObjectSupport#getClass(), groovy.lang.GroovyObjectSupport#equals(java.lang.Object), groovy.lang.GroovyObjectSupport#toString(), groovy.lang.GroovyObjectSupport#notify(), groovy.lang.GroovyObjectSupport#notifyAll()
 
Methods inherited from class java.lang.Object
java.lang.Object#wait(long), java.lang.Object#wait(long, int), java.lang.Object#wait(), java.lang.Object#hashCode(), java.lang.Object#getClass(), java.lang.Object#equals(java.lang.Object), java.lang.Object#toString(), java.lang.Object#notify(), java.lang.Object#notifyAll()
 

Property Detail

format

java.lang.String format


formats

java.util.Map formats


log

private static org.apache.commons.logging.Log log


sheet

jxl.write.WritableSheet sheet


workbook

jxl.write.WritableWorkbook workbook


 
Constructor Detail

ExcelBuilder

ExcelBuilder()


 
Method Detail

createNode

protected java.lang.Object createNode(java.lang.Object name)


createNode

protected java.lang.Object createNode(java.lang.Object name, java.lang.Object value)
This method isn't implemented.


createNode

protected java.lang.Object createNode(java.lang.Object name, java.util.Map attributes)
This method is invoked when you invoke a method with a map of attributes e.g. cell(row: 0, column: 0, value: "Hello1"). It switches between different build actions such as creating the workbook, sheet, cells etc.
param:
name The name of the method which should be invoked e.g. cell
param:
attributes The map of attributes which have been supplied e.g. [row: 0, column: 0, value: "Hello1"]


createNode

protected java.lang.Object createNode(java.lang.Object name, java.util.Map attributes, java.lang.Object value)
This method isn't implemented.


setParent

protected void setParent(java.lang.Object parent, java.lang.Object child)


write

public void write()
Finish writing the document.


 

Groovy Documentation