• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to compare two excel sheets data using java code?  RSS feed

 
Sajith Gowda
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can anyone please guide me on this ?
Currently i am using a macro to do this job but it will take too much of time if there is large number of data in both the sheets.
So i hope java can do better job here.

Thanks in advance.
 
Keith Lynn
Ranch Hand
Posts: 2409
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try POI
 
fred rosenberger
lowercase baba
Bartender
Posts: 12565
49
Chrome Java Linux
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what exactly do you mean by "compare"? by some measures, simply calling "diff" might do it, or looking at the date/time stamp of the files.

Please try to TellTheDetails so everyone knows how best to help you.
 
Sajith Gowda
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Keith Lynn wrote:Try POI


Thanks Keith.. Got a breakthrough!! Will keep updating the progress
 
Sajith Gowda
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
fred rosenberger wrote:what exactly do you mean by "compare"? by some measures, simply calling "diff" might do it, or looking at the date/time stamp of the files.

Please try to TellTheDetails so everyone knows how best to help you.



Hi Fred,

Thank you very much.

Working with POI for this issue. Will inform if get stuck!!!
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!