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)

Share Article : CSV, how to avoid crappy auto-format in Excel
Share/Save/Bookmark

0 comments:

Post a Comment