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
- All
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( ... ) @native() @HotSpotIntrinsicCandidate()
-
final
def
eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
def
equals(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
- val existingWorkbook: Option[XSSFWorkbook]
-
final
def
getClass(): Class[_]
- Definition Classes
- AnyRef → Any
- Annotations
- @native() @HotSpotIntrinsicCandidate()
-
def
hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @native() @HotSpotIntrinsicCandidate()
-
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
- @native() @HotSpotIntrinsicCandidate()
-
final
def
notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @HotSpotIntrinsicCandidate()
-
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( ... )
-
final
def
wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... ) @native()
-
final
def
wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
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. Int }}} Double }}}
- 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. Int }}} Double }}}
- 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