Compare 2 excel files including styles
Posted: Wed Feb 20, 2019 12:25 pm
Hi,
I have 2 excel files that I want to compare. The comparison will include:
1. The text of each cell.
2. The format/style of each cell.
The file can be very small (~10 rows) and very large (~200k rows)
I was thinking about 2 ways to do it:
1. Using the epplus library to open the excel files and compare it cell by cell. The disadvantage is that it requires a lot of code and I miss some properties.
2. Copy to clipboard the all excel content and paste it as HTML in code. The disadvantage - large excel files can produce a large string in memory which may cause an out-of-memory exception.
Is there a built-in or simpler way to compare 2 excel files?
I have 2 excel files that I want to compare. The comparison will include:
1. The text of each cell.
2. The format/style of each cell.
The file can be very small (~10 rows) and very large (~200k rows)
I was thinking about 2 ways to do it:
1. Using the epplus library to open the excel files and compare it cell by cell. The disadvantage is that it requires a lot of code and I miss some properties.
2. Copy to clipboard the all excel content and paste it as HTML in code. The disadvantage - large excel files can produce a large string in memory which may cause an out-of-memory exception.
Is there a built-in or simpler way to compare 2 excel files?