Small C# program to Compare CSV.

Completed Posted 5 years ago Paid on delivery
Completed 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)

.NET C# Programming Excel

Project ID: #17581161

About the project

10 proposals Remote project Active 5 years ago

Awarded to:

mrbrave

Hi, Using LINQ, the function I create will be fast in processing. The function I create can easily perform the files larger then couple of GB. I have good experience of working with Excel and CSV file for loopin More

$190 USD in 3 days
(269 Reviews)
6.8

10 freelancers are bidding on average $163 for this job

urmate

Dear Sir/Madam I've excellent C# programming skills and knowledge. I can provide an efficient, perfect, well documented development of your C# project according to 100% accuracy and requirements, with dedicated More

$155 USD in 3 days
(64 Reviews)
5.3
sonarkaushik

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

$155 USD in 3 days
(46 Reviews)
5.6
NayaPakistan

Hi there. I can make the mentioned program.

$250 USD in 5 days
(17 Reviews)
4.6
Valuesolutions

Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things

$155 USD in 3 days
(7 Reviews)
4.2
aviwalimbe

i have relevant experience in asp.net , i can do this job within some hours ,i will not disappoint you.

$111 USD in 4 days
(7 Reviews)
4.0
HarleyJohnson

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

$155 USD in 3 days
(1 Review)
1.8
GIRATOR

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.

$60 USD in 1 day
(0 Reviews)
0.0