0

I'm using Apachi POI 3.9 to process excel sheet. I've set the cell value as "12/2/1990". But when i set the cell value as Java Date instance, it was not properly set. when i open the file i found cell's format has been changed to General. How Can i set Date values (MM/dd/yyyy)in a Cell as Excel Date ??

JToddler
  • 790
  • 1
  • 6
  • 16
  • 1
    Did you try following the [Creating Date Cells Tutorial on the Apache POI website](http://poi.apache.org/spreadsheet/quick-guide.html#CreateDateCells)? If so, where did you get stuck? (Code might well help) – Gagravarr Apr 29 '13 at 21:22
  • finally i was able to resolve the problem. I didn't set date format in properly. that was the root cause. Thanks – JToddler May 01 '13 at 09:59
  • You can take look at this answer http://stackoverflow.com/questions/5794659/poi-how-do-i-set-cell-value-to-date-and-apply-default-excel-date-format – Ghada Dec 31 '14 at 14:10

0 Answers0