StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POIs there anywhere a Java library available that supports exactly the format strings of Excel?
text
Body
copied!<p>For a Java application that drags data together from some sources and does some calculation itself, we want to offer users the possibility to use their own format strings, and would prefer the format string syntax they know from <a href="http://office.microsoft.com/en-us/excel-help/number-format-codes-HP005198679.aspx" rel="noreferrer">Excel</a> (e. g. <code>"$ "#,###.,0</code>) which happens to be the same used in <a href="http://msdn.microsoft.com/en-us/library/0c899ak8.aspx" rel="noreferrer">.net</a> and <a href="http://msdn.microsoft.com/en-us/library/ms146084.aspx" rel="noreferrer">Analysis Services</a>.</p> <p>The closest thing to use that I found in Java is <a href="http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/" rel="noreferrer">DecimalFormat</a> which lacks some of the features (e. g. thousands and millions formatting by putting the thousands separator at the end, the floating point numbers NaN and infinity are displayed differently, etc., and probably depending on locale, there will be some additional small differences.</p> <p>For now, just the numeric formatting would suffice. Maybe date and string formatting will become a requirement in future.</p> <p>Is there a library, or would we have to develop that ourselves?</p> <p>I cannot imagine we are the only ones who have this issue.</p> <p>POI as suggested by Noel M does not seem to offer a solution. Any other ideas?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload