• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Tim Cooke
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Frank Carver
  • Henry Wong
  • Ron McLeod
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Himai Minh

Excel file processing issue in Java

 
Ranch Hand
Posts: 52
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.

 
lowercase baba
Posts: 13069
67
Chrome Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I cannot answer your question, but thank you for being forthright about your other posting. Have a cow!!!
 
Marshal
Posts: 8382
594
Mac OS X VI Editor BSD Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Marshal
Posts: 8382
594
Mac OS X VI Editor BSD Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You are not alone. This poster experiencing the same and particularly with JExcelApi.
 
Liutauras Vilda
Marshal
Posts: 8382
594
Mac OS X VI Editor BSD Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
This tiny ad is suggesting that maybe she should go play in traffic.
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic