Modifier and Type | Field and Description |
---|---|
static 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 String |
ZEROS |
Constructor and Description |
---|
XlsDataSetWriter() |
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 void |
setDateCell(org.apache.poi.ss.usermodel.Cell cell,
Date value,
org.apache.poi.ss.usermodel.Workbook workbook) |
protected void |
setNumericCell(org.apache.poi.ss.usermodel.Cell cell,
BigDecimal value,
org.apache.poi.ss.usermodel.Workbook workbook) |
void |
write(IDataSet dataSet,
OutputStream out)
Write the specified dataset to the specified Excel document.
|
public static final String ZEROS
public static final String DATE_FORMAT_AS_NUMBER_DBUNIT
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.public void write(IDataSet dataSet, OutputStream out) throws IOException, DataSetException
IOException
DataSetException
protected static org.apache.poi.ss.usermodel.CellStyle createDateCellStyle(org.apache.poi.ss.usermodel.Workbook workbook)
protected void setDateCell(org.apache.poi.ss.usermodel.Cell cell, Date value, org.apache.poi.ss.usermodel.Workbook workbook)
protected void setNumericCell(org.apache.poi.ss.usermodel.Cell cell, BigDecimal value, org.apache.poi.ss.usermodel.Workbook workbook)
protected org.apache.poi.ss.usermodel.Workbook createWorkbook()
Copyright © 2002–2016. All rights reserved.