Comparing 2 different excel files

Question

0.00/5 (No votes)

See more:

How to compare 2 excel files that have different structure? Which one better to solve this problem, using C# or SQL Server 2008 R2. Thank-you.

Posted 12-Jan-16 22:23pm

Member 12261253

Add a Solution

Comments

Jochen Arndt 13-Jan-16 4:37am

This is a problem of the compare algorithm. Once that is defined, it should be possible to implement that in any language (while SQL does not seem to be the best option).

Because we don't know the possible structures of your files and the comparison requirements, this can't be answered here.

DeDenker 13-Jan-16 5:39am

You also have the option of using PowerShell.
But like Jochem stated, please give some example structures for a better and complete answer

ZurdoDev 13-Jan-16 7:32am

Use a 3rd party tool designed to do that.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Answer 1 · 2016-01-13T22:13:00

C# is a better option than SQL for your question.
Since comparison usually tells you if 2 worksheets are the same or not, you must define what kind of differences you expect.

For Excel sheets comparison, I usually do in Excel with a VBA macro, the result being another sheet mapping the differences.

Sri Nivas (Vasu) · Answer 2 · 2016-01-13T20:01:00

Solution 2

check Compare the data in two excel sheets, using visual C#

Posted 13-Jan-16 20:01pm

Sri Nivas (Vasu)

Raja Naveed Aslam · Answer 3 · 2016-01-13T17:45:00

Solution 1

simply use vlookup formula in excel or import it in MSSQL server preform join.

Posted 13-Jan-16 17:45pm

Raja Naveed Aslam