We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells compare and highlight row data

I have a log table that I would like to export to Excel and highlight differences between consecutive rows to mark transaction changes. For example,
1 Bob Smith
2 Bob Jones
3 Larry Jones

on 2nd row, the “Jones” would be highlighted
on 3rd row, the “Larry” would be highlighted
Is this possible?

Thanks for you help ~

Are you interested in stand-alone/back-end API to achieve this?

No, I have an existing .net mvc 4.7 application with a SQL Server backend using Entity Framework that I need to integrate this into.


Using Aspose.Cells, exporting datatable to Excel is possible via Cells.ImportData() method. Regarding comparing rows, there is no such feature in MS Excel either so you have to compare a row’s data with other row(s) by yourselves. (e.g., using Cell.StringValue attribute). To highlight specific cells having data, you may set background/fill color of the cell via Aspose.Cells APIs.

By the way, could you try using GroupDocs.Comarison API if it works for your needs.