Basic Excel currency format with Apache POI

by

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

More Related Contents:

  1. What does the statement Object[][] data = new Object [][] mean?
  2. Get Cell Value from Excel Sheet with Apache Poi
  3. Writing a large resultset to an Excel file using POI
  4. Best language to parse extremely large Excel 2007 files [closed]
  5. How to read Excel cell having Date with Apache POI?
  6. Apache POI add a Series name into LineChart
  7. Replacing a text in Apache POI XWPF
  8. Removing a row from an Excel sheet with Apache POI HSSF
  9. Apache POI autoSizeColumn Resizes Incorrectly
  10. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  11. How to get an Excel Blank Cell Value in Apache POI?
  12. Getting Exception(org.apache.poi.openxml4j.exception – no content type [M1.13]) when reading xlsx file using Apache POI?
  13. Password Protected Excel File
  14. Get the cell value as how it was presented in excel
  15. Trying to make simple PDF document with Apache poi
  16. Exception when writing to the xlsx document several times using apache poi 3.7
  17. Apache-POI sorting rows in excel
  18. how to add a picture to a .docx document with Apache POI XWPF in java
  19. Creating a Table of Contents for a XWPFDocument with page numbers’ indication
  20. Java POI : How to read Excel cell value and not the formula computing it?
  21. How to convert HSSFWorkbook to XSSFWorkbook using Apache POI?
  22. Convert Word to HTML with Apache POI
  23. apache POI java.lang.NoClassDefFoundError: org/apache/commons/compress/archivers/zip/ZipFile
  24. How can I change charts generated by apache poi to not use smoothed lines and show empty cells as gaps?
  25. Can’t Set Fill Color Apache POI Excel Workbook
  26. How to avoid java.lang.NoSuchMethodError: org.apache.poi.util.IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;) in Apache POI
  27. Make column read-only using apache poi
  28. How can I access password protected Excel workbook in Java using POI api
  29. Insert picture in word document
  30. java.lang.OutOfMemoryError: Java heap space while reading excel with Apache POI

Leave a Comment