org.dbunit.dataset.excel

Class XlsDataSetWriter

java.lang.Object

org.dbunit.dataset.excel.XlsDataSetWriter

public class XlsDataSetWriter
extends java.lang.Object

Writes an IDataSet to an XLS file or OutputStream.

Since:

2.4.0

Version:

$Revision$ $Date$

Author:

gommma (gommma AT users.sourceforge.net), Last changed by: $Author$

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	DATE_FORMAT_AS_NUMBER_DBUNIT A special format pattern used to create a custom DataFormat which marks Date values that are stored via POI to an XLS file.
static java.lang.String	ZEROS

Constructor Summary

Constructors

Constructor and Description
XlsDataSetWriter()

Method Summary

Modifier and Type	Method and Description
protected static org.apache.poi.ss.usermodel.CellStyle	createDateCellStyle(org.apache.poi.ss.usermodel.Workbook workbook)
protected org.apache.poi.ss.usermodel.Workbook	createWorkbook()
protected static org.apache.poi.ss.usermodel.CellStyle	findCellStyle(org.apache.poi.ss.usermodel.Workbook workbook, java.lang.Short formatCode, java.util.Map<java.lang.Short,org.apache.poi.ss.usermodel.CellStyle> map)
protected static java.util.Map<java.lang.Short,org.apache.poi.ss.usermodel.CellStyle>	findWorkbookCellStyleMap(org.apache.poi.ss.usermodel.Workbook workbook)
protected static org.apache.poi.ss.usermodel.CellStyle	getCellStyle(org.apache.poi.ss.usermodel.Workbook workbook, short formatCode)
protected void	setDateCell(org.apache.poi.ss.usermodel.Cell cell, java.util.Date value, org.apache.poi.ss.usermodel.Workbook workbook)
protected void	setNumericCell(org.apache.poi.ss.usermodel.Cell cell, java.math.BigDecimal value, org.apache.poi.ss.usermodel.Workbook workbook)
void	write(IDataSet dataSet, java.io.OutputStream out) Write the specified dataset to the specified Excel document.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ZEROS

public static final java.lang.String ZEROS

See Also:

Constant Field Values

DATE_FORMAT_AS_NUMBER_DBUNIT

public static final java.lang.String DATE_FORMAT_AS_NUMBER_DBUNIT

A special format pattern used to create a custom DataFormat which marks Date values that are stored via POI to an XLS file. Note that it might produce problems if a normal numeric value uses this format pattern incidentally.

See Also:

Constant Field Values

Constructor Detail

XlsDataSetWriter

public XlsDataSetWriter()

Method Detail

write

public void write(IDataSet dataSet,
                  java.io.OutputStream out)
           throws java.io.IOException,
                  DataSetException

Write the specified dataset to the specified Excel document.

Throws:

java.io.IOException

DataSetException

createDateCellStyle

protected static org.apache.poi.ss.usermodel.CellStyle createDateCellStyle(org.apache.poi.ss.usermodel.Workbook workbook)

getCellStyle

protected static org.apache.poi.ss.usermodel.CellStyle getCellStyle(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                    short formatCode)

findWorkbookCellStyleMap

protected static java.util.Map<java.lang.Short,org.apache.poi.ss.usermodel.CellStyle> findWorkbookCellStyleMap(org.apache.poi.ss.usermodel.Workbook workbook)

findCellStyle

protected static org.apache.poi.ss.usermodel.CellStyle findCellStyle(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                     java.lang.Short formatCode,
                                                                     java.util.Map<java.lang.Short,org.apache.poi.ss.usermodel.CellStyle> map)

setDateCell

protected void setDateCell(org.apache.poi.ss.usermodel.Cell cell,
                           java.util.Date value,
                           org.apache.poi.ss.usermodel.Workbook workbook)

setNumericCell

protected void setNumericCell(org.apache.poi.ss.usermodel.Cell cell,
                              java.math.BigDecimal value,
                              org.apache.poi.ss.usermodel.Workbook workbook)

createWorkbook

protected org.apache.poi.ss.usermodel.Workbook createWorkbook()