com.jidesoft.hssf
Interface HssfTableUtils.CellValueConverter

All Superinterfaces:

ValueConverter

All Known Implementing Classes:

HssfTableUtils.ContextSensitiveCellValueConverter, HssfTableUtils.DefaultCellValueConverter

Enclosing class:

HssfTableUtils

public static interface HssfTableUtils.CellValueConverter
extends ValueConverter

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

Method Summary

int	getDataFormat(JTable table, Object value, int rowIndex, int columnIndex) Gets the data format for the value.

Methods inherited from interface com.jidesoft.grid.ValueConverter

convert

Method Detail

getDataFormat

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

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").

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.