Small C# program to Compare CSV.
$30-250 USD
Paid on delivery
I need a small program to compare a CSV file with an excel spreadsheet. The program has to be written in C# VS2017.
The user function
Via a file dialog, the user selects the master excel file and a file dialog to select the CSV file and then press a button "Compare".
Then the software loads the excel file and selects automatically the sheet with the name "PLC io liste". In the sheet the program as to use 6 columns and compare these data the CSV file 6 columns.
The sequence of the program needs to be like.
1. Load the two files
2. Start compare
3. Only look in the CSV file where the data "column1" is like the data in column name "Class" in the excel spreadsheet are equal.
4. Then the compare function starts to look in the column name "Class" from the excel spreadsheet if the data exist in the CSV file "column2". If there is a match then the program needs to check if CSV column4,5,7,8 are equal with the column name "MIT-Addr.", column name "Type", column name "Comment" and column name "Remark" from the excel spreadsheet if so then everything is good if not the program has to show in a data grid view where there is a difference.
5. If there is no match in point 4 then it also has to be shown in a data grid view.
The sample files are only small files the real ones can be up to 200 MB each.
Development needs to start asap :o)
Project ID: #17581161
About the project
10 freelancers are bidding on average $163 for this job
Sir, I am very able to code this progtam in C# to compare the the two .csx file accordingly as per requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. W More
Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things
i have relevant experience in asp.net , i can do this job within some hours ,i will not disappoint you.
I will do work for you in these programming languages C++ programming C programming Java Programming Python Programming And also you can order gig for these problems Introduction to Programming Programming F More
If you are interested not in program code for educational purposes but in result, I can do it fast with macros right in excel, without any external programs.