Forum Stats

  • 3,875,722 Users
  • 2,266,954 Discussions
  • 7,912,318 Comments

Discussions

Importing from excel doesn't work on date fields

2»

Answers

  • sect55
    sect55 Member Posts: 1,108 Bronze Badge
    I looked at the format of the "pay date" columan and the category is not "custom" but "date" with type "03/14/01" and locale "English (United States)".
  • vasan_kps
    vasan_kps Member Posts: 174
    Re-verified the xls you sent to me. The cell format indeed belongs to the category "Custom" and the Type is "mm/dd/yy;@".
  • vasan_kps
    vasan_kps Member Posts: 174
    Incidentally, I noticed that I don't see a date format "03/14/01". The closest that I can see is 03/14/98! I am using excel 2000 9.0.3821 SR-1 to open the file. Can you let me know which version of EXCEL was used to create this file. I am observing that the underlying POI library is not even being able to open this file!
  • sect55
    sect55 Member Posts: 1,108 Bronze Badge
    I am using excel 2003 (11.8307.8221) SP3

    In Excel 2003 it is using Date not Custom.
  • vasan_kps
    vasan_kps Member Posts: 174
    This needs a bit more investigation on the underlying POI library that is used to read and write xls file format. I need to study the extent of support for excel 2003 provided by latest POI library. If it does support 2003 then and a lot of testing needs to be done before it can be absorbed into the product. I'll keep the post updated with my findings.
  • vasan_kps
    vasan_kps Member Posts: 174
    Verified that POI 3.5 library is able to handle the processing of files in excel 2003 format. However the library needs to be integrated with the product and tested thoroughly for its overall impact on the product before it can be absorbed into the product stack. Hence POI 3.5 can be integrated into the product only post 2.1 release.
This discussion has been closed.