wood burning stoves 2.0*
The moose likes Java in General and the fly likes Hash value are not same Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Hash value are not same" Watch "Hash value are not same" New topic

Hash value are not same

Umesh Kilkile

Joined: Mar 31, 2010
Posts: 11

I've two Excel files with same data. One is in Excel 2003 (.xls) format and other one is in Excel 2007 (.xlsx) format. I've generated one way hash using SHA-1 algorithm. But the hash value of Excel 2003 files is not same as the hash value of Excel 2007 file.

What might be the problem.

Thank You,

Umesh Kilkile
Nawapunth Manusitthipol

Joined: Aug 14, 2009
Posts: 14
xls is a binary format while xlsx is an xml based format so even if they contain the same data, their hash are not the same.

Middle path.
Rob Spoor

Joined: Oct 27, 2005
Posts: 19655

To be even more precise, xlsx is a ZIP file with several XML files (and one binary file, xl\printerSettings\printerSettings1.bin) in it.

How To Ask Questions How To Answer Questions
I agree. Here's the link: http://aspose.com/file-tools
subject: Hash value are not same
Similar Threads
Conditional Formatting in POI
Export excel using java
Reduce Excel XML file size
How to convert .xls to .xlsx and vice versa using Apache POI api
How to export data in excel