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?
Compare 2 excel files including styles
Re: Compare 2 excel files including styles
Hi,
I'm afraid, there is no built-in code/action in Ranorex to compare excel files and their style. So using epplus (or similar 3rd party lib or code), is your best hope to achieve what you want.
I'm afraid, there is no built-in code/action in Ranorex to compare excel files and their style. So using epplus (or similar 3rd party lib or code), is your best hope to achieve what you want.
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
Ranorex explorer at Descartes Systems
Please add these details to your questions:
- Ranorex Snapshot. Learn how to create one >here<
- Ranorex xPath of problematic element(s)
- Ranorex version
- OS version
- HW configuration