Compare two excel sheets for delta differences

[Jatin Gundabathula]

Hi Team,

We have used import excel sheet feature to load data into our database. so user can re-upload many times same excel. is there any way we can identify to track only changes in the excel or updated columns and rows? or is there any way we can compare two same type of workbook objects for differences to identify 

updates or modifications and load those data into our database rather than loading all the data.

Please let me know if you need more information on the same. need this info ASAP

we use below code to load data into datatable C#

List<DataTable> allWorksheets = new List<DataTable>();

currentFile as stream 

IApplication application = excelEngine.Excel;

application.DefaultVersion = ExcelVersion.Excel2016;

IWorkbook workbook = application.Workbooks.Open(currentFile);

                   foreach (var sheet in workbook.Worksheets)

                    {

                        sheet.UsedRangeIncludesFormatting = false;

                        allWorksheets.Add(sheet.ExportDataTable(sheet.UsedRange,

                            ExcelExportDataTableOptions.ColumnNames |

                            ExcelExportDataTableOptions.ComputedFormulaValues));

                    }

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Jatin, 

Greetings from Syncfusion. 

Syncfusion XlsIO do not have support to track the changes made in the file. We have logged a feature report for this and will consider to implement in any of our upcoming releases. You can track the status of feature report through following feedback link. 

Track Status: https://www.syncfusion.com/feedback/2637/track-changes-support  

Regards, 

Keerthi. 

[Jatin Gundabathula]

Hi,

If this is the case than do we have any option where i can get only latest or updated rows do we have any flag for rows or cell something like updated datetime so that when i convert stream into Datatable will only get updated records based on timestamp.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Jatin, 

Thanks for the update.  

As of now, we do not have support to achieve your requirement but, we will like to know in detail about the use-case. We have created a new support incident under your direct-trac account. 

Regards, 

Keerthi. 

[Jatin Gundabathula]

Hi Keerthi,

I don't see any Incident created can you please provide me the link for it