I used DataFormatter to convert it to a String. But it returns MM/DD/YY and not MM/DD/YYYY I need in MM/DD/YYYY. Did not find the correct method of this in DataFormatter.
Thanks and Regards, Vijay Inani +919765000940 On Fri, Apr 10, 2015 at 2:42 PM, Nick Burch-2 [via Apache POI] < [email protected]> wrote: > On Thu, 9 Apr 2015, vijayinani wrote: > > they are same. i.e. in excel it shows as MM/DD/YYYY. But thru code its > > reading incorrectly in US. > > > > My code is simple: > > > > if (DateUtil.isCellDateFormatted(cell)) > > data.append(cell); > > Use DataFormatter to convert it to a string, that will preserve the > formatting rules. Calling toString() on a cell will not > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [hidden email] > <http:///user/SendEmail.jtp?type=node&node=5718477&i=0> > For additional commands, e-mail: [hidden email] > <http:///user/SendEmail.jtp?type=node&node=5718477&i=1> > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://apache-poi.1045710.n5.nabble.com/Reading-date-from-excel-file-for-different-locations-tp5718475p5718477.html > To unsubscribe from Reading date from excel file for different locations, > click > here > <http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5718475&code=dmlqYXlpbmFuaUBnbWFpbC5jb218NTcxODQ3NXwxNzk3MDE3NzMx> > . > NAML > <http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-date-from-excel-file-for-different-locations-tp5718475p5718479.html Sent from the POI - User mailing list archive at Nabble.com.
