class ExcelWriterInMemory extends ExcelWriterBase
This excel writer is in memory, thus slower than the ExcelWriter, but it supports pivot tables and formula evaluations.
- Alphabetic
- By Inheritance
- ExcelWriterInMemory
- ExcelWriterBase
- AnyRef
- Any
- Hide All
- Show All
- Public
- Protected
Instance Constructors
- new ExcelWriterInMemory(existingWorkbook: Option[XSSFWorkbook] = None)
- existingWorkbook
an optional existing XSSFWorkbook.
Value Members
- final def !=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- final def ##: Int
- Definition Classes
- AnyRef → Any
- final def ==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- def addPivot(sheetName: String, filterColumns: List[String], colColumns: List[String], rowColumns: List[String], valueColumns: List[(DataConsolidateFunction, String, String)], createInSheet: Option[String] = None, pivotRowOffset: Int = 0, pivotCollOffset: Int = 0): Unit
Adds a pivot table to an existing sheet
Adds a pivot table to an existing sheet
- sheetName
name
- filterColumns
list of filter names - must be in the header of the sheet
- colColumns
list of column names - must be in the header of the sheet
- rowColumns
list of filter row names - must be in the header of the sheet
- valueColumns
a triplet of an aggregation function, a column name and a format. For formatting see https://stackoverflow.com/questions/319438/basic-excel-currency-format-with-apache-poi or use a custom format from excel
- def addPivotWithIndexes(sheetName: String, filterColumns: List[Int], colColumns: List[Int], rowColumns: List[Int], valueColumns: List[(DataConsolidateFunction, Int, String)], createInSheet: Option[String] = None, pivotRowOffset: Int = 0, pivotCollOffset: Int = 0): Unit
Adds a pivot table to an existing sheet
Adds a pivot table to an existing sheet
- sheetName
name
- filterColumns
list of filter indexes
- colColumns
list of column indexes
- rowColumns
list of filter row indexes
- valueColumns
a triplet of an aggregation function, an index and a format. For formatting see https://stackoverflow.com/questions/319438/basic-excel-currency-format-with-apache-poi or use a custom format from excel
- final def asInstanceOf[T0]: T0
- Definition Classes
- Any
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @HotSpotIntrinsicCandidate() @native()
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def equals(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef → Any
- val existingWorkbook: Option[XSSFWorkbook]
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @HotSpotIntrinsicCandidate() @native()
- def hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @HotSpotIntrinsicCandidate() @native()
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @HotSpotIntrinsicCandidate() @native()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @HotSpotIntrinsicCandidate() @native()
- def save(outputStream: OutputStream): Unit
Writes the workbook to an output location.
Writes the workbook to an output location.
- outputStream
The stream the workbook is written to.
- Definition Classes
- ExcelWriterBase
- final def synchronized[T0](arg0: => T0): T0
- Definition Classes
- AnyRef
- def toString(): String
- Definition Classes
- AnyRef → Any
- final def wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException]) @native()
- final def wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- def workbook: XSSFWorkbook
- Definition Classes
- ExcelWriterInMemory → ExcelWriterBase
- def writeSheet(name: String, content: List[Array[String]]): Unit
Writes the given content to a new sheet with given name.
Writes the given content to a new sheet with given name.
- name
The name of the sheet to write.
- content
The rows of content to write.
- Definition Classes
- ExcelWriterBase
- def writeSheet(name: String, csv: CSVReader): Unit
Writes the content read from a csv source to a new sheet with given name.
Writes the content read from a csv source to a new sheet with given name.
- name
The name of the sheet to write.
- csv
The reader for the csv source.
- Definition Classes
- ExcelWriterBase
- def writeSheet(file: FileContent): Unit
Writes the content of a file to new sheet named with the file name.
Writes the content of a file to new sheet named with the file name.
- file
The file to write.
- Definition Classes
- ExcelWriterBase
- def writeSheetMatch(name: String, header: Iterable[String], content: Iterable[Product]): Unit
Writes the given content to a new sheet with given name and header.
Writes the given content to a new sheet with given name and header. Supports all case classes as content.
- name
The name of the sheet to write.
- header
The header of the new sheet
- content
The rows of content to write.
- def writeSheetMatchAny(name: String, header: Iterable[String], content: Iterable[Iterable[Any]]): Unit
Writes the given content to a new sheet with given name and header.
Writes the given content to a new sheet with given name and header. Supports types
Double,
Int, Boolean and String.
- name
The name of the sheet to write.
- header
The header of the new sheet
- content
The rows of content to write.
- def writeSheetMatchProduct[T](name: String, content: Iterable[Product])(implicit arg0: scala.reflect.api.JavaUniverse.TypeTag[T]): Unit
Writes the given content to a new sheet with given name.
Writes the given content to a new sheet with given name. Supports all case classes and automatically defines a header from the class fields.
- name
The name of the sheet to write.
- content
The rows of content to write.
- Definition Classes
- ExcelWriterBase
- def writeSheetMatchTypes(name: String, content: List[Array[Any]]): Unit
Writes the given content to a new sheet with given name.
Writes the given content to a new sheet with given name. Supports types
Double,
Int, Boolean and String.
- name
The name of the sheet to write.
- content
The rows of content to write.
- Definition Classes
- ExcelWriterBase
- def writeValue(row: Row, value: Any, col: Int): Any
- Attributes
- protected
- Definition Classes
- ExcelWriterBase
Deprecated Value Members
- def finalize(): Unit
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.Throwable]) @Deprecated
- Deprecated
(Since version 9)