• Post Reply Bookmark Topic Watch Topic
  • New Topic

Excel file processing issue in Java  RSS feed

 
Norman Meister
Ranch Hand
Posts: 52
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using "jxl-2.6.9". The "excel_original.xls" on processing column B "bis", the values "00:15:00" is read as 12:15, next value "00:30:00" as 12:30 and so. This is wrong, the time value should have been read as it is. "00:15:00" as "00:15:00" and so on.

The "excel_original.xls" i received directly from the supplier as attached in the mailbox. The system picks the attachment and processes it incorrectly. But when I "locally open and save" the file and manually process it, the system treats it correctly. Something changes in the format of the file when I locally save it without even making any change.

The changed file version is "excel_changed.xls". The file size increases when I locally save it. The contents are exactly the same in both the files.

Can someone suggest the reason for this behavior?

thanks.

I have asked the same question http://www.javaprogrammingforums.com/whats-wrong-my-code/45615-excel-file-processing-issue-java.html#post183909 at this forum as well, but no answer. Also you will find on this other forum page the excel files attached. I could not attach them here.

 
fred rosenberger
lowercase baba
Bartender
Posts: 12563
49
Chrome Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I cannot answer your question, but thank you for being forthright about your other posting. Have a cow!!!
 
Liutauras Vilda
Sheriff
Posts: 4921
334
BSD
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Norman Meister wrote:the values "00:15:00" is read as 12:15, next value "00:30:00" as 12:30 and so
Not sure too, but something probably got to do with 12 hour clock (AM/PM) and 24 hour clock... Googling, I might will find something.
 
Liutauras Vilda
Sheriff
Posts: 4921
334
BSD
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are not alone. This poster experiencing the same and particularly with JExcelApi.
 
Liutauras Vilda
Sheriff
Posts: 4921
334
BSD
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It seems that guy didn't find direct solution too. Taking in consideration that I don't know nothing about your processing, think if you could add 12 to your output hours (00 would require to treat differently), in most cases should work.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!