Basic Excel currency format with Apache POI

I'm able to get cells to format as Dates, but I've been unable to get cells to format as currency... Anyone have an example of how to create a style to get this to work? My code below show the styles I'm creating... the styleDateFormat works like a champ while styleCurrencyFormat has no affect on the cell.

private HSSFWorkbook wb;
private HSSFCellStyle styleDateFormat = null;
private HSSFCellStyle styleCurrencyFormat = null;

......

public CouponicsReportBean(){
 wb = new HSSFWorkbook();
 InitializeFonts();

}

public void InitializeFonts()
{
 styleDateFormat = wb.createCellStyle();
 styleDateFormat.setDataFormat(HSSFDataFormat.getBuiltinFormat("m/d/yy"));


    styleCurrencyFormat = wb.createCellStyle();
    styleCurrencyFormat.setDataFormat(HSSFDataFormat.getBuiltinFormat("$#,##0.00"));

}

From stackoverflow

• After digging through the documentation a bit more, I found the answer:

  http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFDataFormat.html

  Just need to find an appropriate pre-set format and supply the code.

   styleCurrencyFormat.setDataFormat((short)8); //8 = "($#,##0.00_);[Red]($#,##0.00)"
  

  Here are more examples: http://www.roseindia.net/java/poi/setDataFormat.shtml

  Mike C. : Thanks for posting this!