i need to compare 2 huge excel worksheets and i am right now doing that by cell by cell comparison.
I initially tried to do ImportDataTable() on the 2 worksheets and then merge() and GetChanges() on the 2 data tables. This is giving too many false positives.
I wonder if you have a lightweight API to compare two worksheets?
We have LightCells APIs but it is mainly used to insert data cell by cell into the worksheets (one sheet at a time) without creating the complete data model or streaming the whole data/contents, see the document for your reference if it gives you some help:
Currently, we do not support to read template files or data so you can only fill up or create huge spreadsheets on the fly.
Well, I think you have to compare cell by cell value for the sheet (in the workbook(s)) by using your own code with Aspose.Cells APIs. It may take some time to finish the process but you have to do this after all.