Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hash value are not same

 
Umesh Kilkile
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Rob Spoor
Sheriff
Pie
Posts: 20495
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
To be even more precise, xlsx is a ZIP file with several XML files (and one binary file, xl\printerSettings\printerSettings1.bin) in it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic