File	Date	Author	Commit
.settings	2016-08-02	Dominique De Munck	[8fc1db] First generate difference file
bin	2016-08-19	Dominique De Munck	[c3f20f] better comments
src	2016-08-19	Dominique De Munck	[c3f20f] better comments
testFiles	2016-04-27	Dominique De Munck	[c63e54] Better handling of Formula Errors;
.classpath	2016-08-19	Dominique De Munck	[c3f20f] better comments
.project	2016-04-06	Dominique De Munck	[5f6e65] Initial commit
CompareExcel-HiMem.exe	2016-08-19	Dominique De Munck	[c3f20f] better comments
CompareExcel.exe	2016-08-19	Dominique De Munck	[c3f20f] better comments
CompareExcel.jar	2016-08-19	Dominique De Munck	[c3f20f] better comments
README.txt	2016-08-02	Dominique De Munck	[8fc1db] First generate difference file
exportCompare.ant.xml	2016-04-27	Dominique De Munck	[c63e54] Better handling of Formula Errors;
launch4j-DynamicHeapSize.cfg.xml	2016-04-06	Dominique De Munck	[5f6e65] Initial commit
launch4j.cfgHi.xml	2016-04-06	Dominique De Munck	[5f6e65] Initial commit

Read Me

GENERAL

This tool was developed for comparing Excel files, on a cell by cell base.
It is suited for large files with lots of numbers, like UNFCCC reporting files.

Main (gui) class:

leefmilieu.brussels.tools.gui.CompareExcelFilesGui

See HELP FILE for more information -> CompareExcelHelp.html

RUNNING


Run the jar, specifying a max. heap size. For very large files, it may be necessary to use larger heap sizes (try the maximum which gives no errors on your system, eg. 1224):<br>
java -Xmx1224m -jar CompareExcel.jar [fullpath/src-file.xlsx] [fullpath/compare-file.xlsx] [sheetname]

BUILDING

* exportCompare.ant.xml -> Eclipse generated ant build file for generating runnable ShowLinks.jar. 
Modify folders paths before running.


* launch4j-*.cfg.xml: Configuration files for my system to make .exe files with Launch4j, different memory options.
Modify folders paths before running.

DEPENDENCIES:

The generated Jar file contains all library classes.
You can download them seperatly and load them as a library inside Eclipse:

-Java 1.8
-Apache POI 3.12
-Apache Commons IO 2.4
-Apache Commons Lang
(-XLSX-Streamer 0.2.8 for possible extension for very large xlsx files)