 |
|
|
|
|
|
The following assumes that the information in your Excel files is (at least partly) organized as tables. Selecting Rows or Columns (vertical=rows, horizontal=columns) indicates your file is indeed organized as tables. This is used to decide if rows (or columns) have shifted because of an added extra line. As a result the table properties group becomes visible. Supplying the correct values in this group will enable the comparison process to give better information. Instead of simply returning any cell with a different value, it can now also tell that some lines were added (or removed).
If we press now [Compare] we get much more useful reports (as compared to Comparing Excel files using ranges ). The Analysis Report reduced the information to 4 lines. The Visualization Report shows the original data in the table and what the changes are. Added rows have a blue mark. Removed rows a red mark. Changed values show the previous value in yellow.
Analysis Report:
| Missing row | C:\projects\agora\VB6\code\ExcelCompare\TestFiles\FileNew.xls!SheetWithTable!A11:E11(11) | ||
| Missing row | C:\projects\agora\VB6\code\ExcelCompare\TestFiles\FileNew.xls!SheetWithTable!A10:E10(10) | ||
| Different value | SheetWithTable!D3 | 20 | 19 |
| Missing row | C:\projects\agora\VB6\code\ExcelCompare\TestFiles\FilePrevious.xls!SheetWithTable!A8:E8(7) | ||
Visualization Report
Rows 1 - 77 ( - Row added - Row removed)
| A | B | C | D | E | |
|
1 |
Product ID | Product Name | Quantity Per Unit | Unit Price | Units In Stock |
| 2 | 1 | Chai | 10 boxes x 20 bags | 18 | 39 |
| 3 | 2 | Chang | 24 - 12 oz bottles | 20 19 | 17 |
| 4 | 3 | Aniseed Syrup | 12 - 550 ml bottles | 10 | 13 |
| 5 | 4 | Chef Anton's Cajun Seasoning | 48 - 6 oz jars | 22 | 53 |
| 6 | 5 | Chef Anton's Gumbo Mix | 36 boxes | 21.35 | 0 |
| 7 | 6 | Grandma's Boysenberry Spread | 12 - 8 oz jars | 25 | 120 |
| 8 | 7 | Uncle Bob's Organic Dried Pears | 12 - 1 lb pkgs. | 30 | 15 |
| 8 | 8 | Northwoods Cranberry Sauce | 12 - 12 oz jars | 40 | 6 |
| 9 | 9 | Mishi Kobe Niku | 18 - 500 g pkgs. | 97 | 29 |
| 10 | 10 | Ikura | 12 - 200 ml jars | 31 | 31 |
| 11 | 11 | Queso Cabrales | 1 kg pkg. | 21 | 22 |
Note: differences between rows / columns in the order in which they are placed are ignored (considered inessential).
Compare Excel Files Examples :
Comparing tables in worksheets
Comparing Excel files using code
Comparing Excel files using ranges
Comparing Excel worksheets
Comparing multiple ranges in Excel worksheets
Compare Excel Files
Secure Payment Options
| Number of licenses/units | Individual price |
| 1-4 | USD: 69.00 |
| 5-9 | USD: 49.00 |
| From10 | USD: 43.00 |
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $65.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft