What is new:
-fixed bug preventing comparision of tables that have spaces in column names
Compare two tables created with MS Excel and create result table containing rows from first table that have or haven`t equivalent in second table according to given criteria.
To use Compare Sheets:
- You need to prepare data before to pass it to Compare Sheet
- create new .xls file
- in sheet1 and sheet2 paste data you want to compare keeping column header rows. Check TestBook.xls file to see how data in sheet1 and sheet2 must looks like.
- save file and exit excel
- Open prepared file in Compare Sheet. Data in sheet1 is loaded and displayed as table1 and data in sheet2 is loaded and displayed as table2
- Select reference field by selecting column name for table1 and table2
- Select criteria to be used for comparing tables(sheets)
- Type name of result sheet or check auto check box
- If you want result to be placed in new file fill result file field. If you leave result file field empty result will be placed in source file in sheet named according to your entry in step 5
- Click on compare button to compare tables/sheets
Note:
- data in column you use to compare tables must be homogeneous ( of same type - all numbers or all text, but not both).
- reference filed columns of both tables must be of same data type - both numbers or both text
- it is recommended to convert columns containing formulas to text before to compare data
Tested on Windows 7, and works in same way as on any other windows OS.
You do not need MS Excel or any other software that opens MS Excel files in order to use Compare Sheets.
You can review comparison result by opening file in Compare Sheets and selecting sheet containing result.
What´s new in version 1.1.2:
- fixed problem that prevents comparision of tables that have spaces in names and names of fields