com.jidesoft.hssf

Class HssfTableUtils.DefaultCellValueConverter

java.lang.Object

com.jidesoft.hssf.HssfTableUtils.DefaultCellValueConverter

All Implemented Interfaces:

ValueConverter, HssfTableUtils.CellValueConverter

Enclosing class:

HssfTableUtils

public static class HssfTableUtils.DefaultCellValueConverter
extends Object
implements HssfTableUtils.CellValueConverter

Converts the cell value in a table to the value that will be written to Excel cell.

Constructor Summary

Constructors

Constructor and Description
HssfTableUtils.DefaultCellValueConverter()

Method Summary

Methods

Modifier and Type	Method and Description
Object	convert(JTable table, Object value, int rowIndex, int columnIndex) Converts the value to the value you want to set in the csv file.
int	getDataFormat(JTable table, Object value, int rowIndex, int columnIndex) Gets the data format for the value.

Methods inherited from class java.lang.Object

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

Constructor Detail

HssfTableUtils.DefaultCellValueConverter

public HssfTableUtils.DefaultCellValueConverter()

Method Detail

convert

public Object convert(JTable table,
             Object value,
             int rowIndex,
             int columnIndex)

Description copied from interface: ValueConverter

Converts the value to the value you want to set in the csv file.

Specified by:

convert in interface ValueConverter

Parameters:

table - the table

value - the value in the table

rowIndex - the row index of the value

columnIndex - the column index of the value

Returns:

the converted value.

getDataFormat

public int getDataFormat(JTable table,
                Object value,
                int rowIndex,
                int columnIndex)

Description copied from interface: HssfTableUtils.CellValueConverter

Gets the data format for the value. The formats are defined in POI's HSSF. Available formats are

0, "General"
1, "0"
2, "0.00"
3, "#,##0"
4, "#,##0.00"
5, "($#,##0_);($#,##0)"
6, "($#,##0_);[Red]($#,##0)"
7, "($#,##0.00);($#,##0.00)"
8, "($#,##0.00_);[Red]($#,##0.00)"
9, "0%"
0xa, "0.00%"
0xb, "0.00E+00"
0xc, "# ?/?"
0xd, "# ??/??"
0xe, "m/d/yy"
0xf, "d-mmm-yy"
0x10, "d-mmm"
0x11, "mmm-yy"
0x12, "h:mm AM/PM"
0x13, "h:mm:ss AM/PM"
0x14, "h:mm"
0x15, "h:mm:ss"
0x16, "m/d/yy h:mm"

// 0x17 - 0x24 reserved for international and undocumented 0x25, "(#,##0_);(#,##0)"

0x26, "(#,##0_);[Red](#,##0)"

0x27, "(#,##0.00_);(#,##0.00)"

0x28, "(#,##0.00_);[Red](#,##0.00)"

0x29, "_(*#,##0_);_(*(#,##0);_(* \"-\"_);_(@_)"

0x2a, "_($*#,##0_);_($*(#,##0);_($* \"-\"_);_(@_)"

0x2b, "_(*#,##0.00_);_(*(#,##0.00);_(*\"-\"??_);_(@_)"

0x2c, "_($*#,##0.00_);_($*(#,##0.00);_($*\"-\"??_);_(@_)"

0x2d, "mm:ss"

0x2e, "[h]:mm:ss"

0x2f, "mm:ss.0"

0x30, "##0.0E+0"

0x31, "@" - This is text format.

0x31 "text" - Alias for "@"

If you need to access the HSSFWorkbook instance used during this exporting process, you can get it using table.getClientProperty("HssfTableUtils.HSSFWorkbook").

Specified by:

getDataFormat in interface HssfTableUtils.CellValueConverter

Parameters:

table - the table

value - the value in the table

rowIndex - the row index of the value

columnIndex - the column index of the value

Returns:

the data format as defined above. -1 if you don't care and use the default format.