java excel设置单元格格式为会计专用，货币单位HKD

HSSFCellStyle currencyDecimalStyle = wb.createCellStyle();
		HSSFDataFormat format = wb.createDataFormat();
		currencyDecimalStyle.setDataFormat(format.getFormat("_(\"HKD\"* #,##0.00_);_(\"HKD\"* (#,##0.00);_(\"HKD\"* \"-\"??_);_(@_)"));
		currencyDecimalStyle.setFont(bodyFont);
		currencyDecimalStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);


writeAmountData(row, (short) 3, totalAmountByPayitemKey, currencyDecimalStyle);

public void writeAmountData(HSSFRow row, short cellnum, Object value, HSSFCellStyle cellStyle) {
		Double amount = new Double(value.toString());
		double amountDouble = amount.doubleValue();
		if (amountDouble < 0) {
			amountDouble = amountDouble * -1;
		}

		HSSFCell cell = row.createCell(cellnum);
		cell.setCellValue(amountDouble);
		cell.setCellStyle(cellStyle);
		cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
	}

下载excel效果图：