Class HSSFDataFormat
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 "@"
- Author:
- Andrew C. Oliver (acoliver at apache dot org), Shawn M. Laubach (slaubach at apache dot org)
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic StringgetBuiltinFormat(short index) get the format string that matches the given format indexstatic shortgetBuiltinFormat(String format) get the format index that matches the given format stringstatic ListgetFormat(short index) get the format string that matches the given format indexshortget the format index that matches the given format string.static intget the number of builtin and reserved builtinFormats
-
Constructor Details
-
HSSFDataFormat
Construncts a new data formatter. It takes a workbook to have access to the workbooks format records.- Parameters:
workbook- the workbook the formats are tied to.
-
-
Method Details
-
getBuiltinFormats
-
getBuiltinFormat
get the format index that matches the given format stringAutomatically converts "text" to excel's format string to represent text.
- Parameters:
format- string matching a built in format- Returns:
- index of format or -1 if undefined.
-
getFormat
get the format index that matches the given format string. Creates a new format if one is not found. Aliases text to the proper format.- Parameters:
format- string matching a built in format- Returns:
- index of format.
-
getFormat
get the format string that matches the given format index- Parameters:
index- of a format- Returns:
- string represented at index of format or null if there is not a format at that index
-
getBuiltinFormat
get the format string that matches the given format index- Parameters:
index- of a built in format- Returns:
- string represented at index of format or null if there is not a builtin format at that index
- Throws:
ArrayOutOfBoundsException- when the index exceeds the number of builtin formats.
-
getNumberOfBuiltinBuiltinFormats
public static int getNumberOfBuiltinBuiltinFormats()get the number of builtin and reserved builtinFormats- Returns:
- number of builtin and reserved builtinFormats
-