commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rupert Wood">
Subject [CSV] Wish: format-specific date generation
Date Tue, 22 Apr 2014 11:22:16 GMT
Hi -


It would be useful if printing a Java Date or Calendar to a CSVFormat.EXCEL
CSVPrinter would generate output that Excel recognises as a date-and-time.
For example the following


    PrintWriter outputWriter = new PrintWriter(new

    CSVPrinter printer = new CSVPrinter(outputWriter, CSVFormat.EXCEL);   

    printer.print(new Date());   




outputs the raw Date.toString()


    Tue Apr 22 12:06:42 BST 2014


which Excel only treats as a string. (It will recognise e.g. yyyy/mm/dd as a
date but I wouldn't know where to look for a definitive set of formats it
will consume.) Ditto probably printing Calendar.getInstance(), or the new
Java 8 LocalDate etc. classes.


One argument against though is then the library perhaps ought to do the
reverse, i.e. spot that it has been passed a date in and construct a Date
class for the value at parse time which may be expensive and often


Thanks for your consideration. Happy to raise a JIRA 'Wish' ticket if this
seems reasonable.




  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message