Thursday, September 6, 2012
CSV, how to avoid crappy auto-format in Excel
Output date as a String as following
"=\""+$F{dd/mm/yyyy date}+ "\"" (in jasper)
"=""01/01/2012""" (finally following will be generated)
Subscribe to:
Post Comments (Atom)
CSV, how to avoid crappy auto-format in Excel
0 comments:
Post a Comment