Aspose.Cells compare and highlight row data

Aspose.Total Product Family
1

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 ~
Jodeenm

2

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

3

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.
thanks

4

@jodeenm,

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.