This discussion is archived
0 Replies Latest reply: Jul 29, 2013 2:20 AM by user541023 - oracle RSS

Cannot Compare two files(any type) in openscript

user541023 - oracle Newbie
Currently Being Moderated

Hi

I'm trying to compare two excel sheets using open-script. I wrote the following code

 

File file1 = new File(

  "C:\\Users\\hnariset\\DDownloads\\OATS Downloads\\Plan_V_Actual_Summary_-_Platform.xls");

  File file2 = new File(

  "C:\\Users\\hnariset\\DDownloads\\OATS Downloads\\Plan_V_Actual_Summary_-_Platform(1).xls");

  boolean filesSame = FileUtils.contentEquals(file1, file2);

if (filesSame) {

  JOptionPane.showMessageDialog(null, "Files have same contents.");

  System.exit(0);

  } else {

  JOptionPane.showMessageDialog(null,"Files have different contents.");

  System.exit(0);

  }

 

But this is giving me (filesSame=) false always,even if the two files are same.(I made a copy of one sheet manually in the folder and compared the two).This is happening for every type of file.

 

I tried to see the error and printed the differences.The problem,I found, is in reading the files.It's reading in some language I can't understand.

How to rectify this error using the same function or write a new function to know exactly the error(read in normal language)??

 

Regards

Harsha

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points