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

how To compare to excel Files using java

 
anilellendula kumar
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,


How To comapre two Excel sheets using java and difference of two excel sheets should write in log file where the difference in the two file


i.e log file contains the difference of two excel , want which API supports these comparison and wat is the process to compare
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64631
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not a JSP question, so moving off to Java in General (intermediate).
 
Layne Lund
Ranch Hand
Posts: 3061
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think Java is the right tool for such a job. If you have a small number of files to compare, you should be able to do this in Excel itself. If you have a large number of files, or you just want to automate it, VB or VBA would probably be much more suited to the task since they integrate well with Excel.

Layne
 
Ulf Dittmer
Rancher
Pie
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jakarta POI is an excellent library that makes it easy to read and write Excel files (amongst other formats).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic