wood burning stoves 2.0*
The moose likes Java in General and the fly likes how To compare to excel Files using java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "how To compare to excel Files using java" Watch "how To compare to excel Files using java" New topic
Author

how To compare to excel Files using java

anilellendula kumar
Ranch Hand

Joined: Jul 12, 2005
Posts: 43
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

Joined: Jan 10, 2002
Posts: 61103
    
  66

Not a JSP question, so moving off to Java in General (intermediate).


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Layne Lund
Ranch Hand

Joined: Dec 06, 2001
Posts: 3061
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


Java API Documentation
The Java Tutorial
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41621
    
  55
Jakarta POI is an excellent library that makes it easy to read and write Excel files (amongst other formats).


Ping & DNS - my free Android networking tools app
 
wood burning stoves
 
subject: how To compare to excel Files using java