Hello.

If all the cells match, you can do a quick comparison. with a foreach. If some are different/missing, it will take longer.

Any other feature that may help, like styling?

For a task like this, it’s better to create a C# extension to handle the comparison — it’ll be easier and more efficient.

Hi @Sathwik Karamsetty

Using Advanced Excel, there’s a server cell that you can Find by value — you can use that feature and then apply the condition check accordingly. I shared the attachment as well

Thanks!

Hi @Sathwik Karamsetty ,

• Read File 2 rows one by one.
• Detect the header row by checking for expected column names or a pattern matching File 1 headers.
• Once the header row is found, use it as the starting point to extract and compare data with File.
• Using an Advanced Excel plugin to read File 2 rows.
• Implement a loop to scan rows until the header row is detected by matching column names.
• Then perform your compare logic based on the detected header.

Let me know if you need any help on this! 

Thanks!