Terminé

Small C# program to Compare CSV.

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)

Compétences : .NET, Programmation C#, Excel

en voir plus : compare csv, visual basic small count program, compare csv files, how to compare two columns in csv files using java, compare two csv files using c#, c# compare two files and show differences, compare two csv files for differences in c#, how to compare two large csv files, csv compare tool, c# code to compare two csv files, how to compare two csv files in java, small linux program, program compare csv file, compare csv xml, compare csv files using, program compare excel files, mysql compare csv type, program compare csv files, compare csv files vba, small project program

Concernant l'employeur :
( 0 commentaires ) Denmark

Nº du projet : #17581161

Décerné à:

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(223 Commentaires)
6.6

15 freelance font une offre moyenne de $163 pour ce travail

StormLion227

Hello I can start your project now. I can finish this job in 3~5 hours absolutely. I've read your job description carefully. I can write smart C# code that compare large CSV files absolutely. Thans.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(34 Commentaires)
7.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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(45 Commentaires)
5.7
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(53 Commentaires)
5.0
BestPartner4You

How are you,sir? I am quite interested in your project - 'Small C# program to Compare CSV.'. :) I am a ultimate software developer who has rich experience in this field. If you contact me, you and i will all be happy. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(8 Commentaires)
4.2
NayaPakistan

Hi there. I can make the mentioned program.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(9 Commentaires)
3.9
sergey4kim

Senior C# Expert! I have developed many programs using C# for +7 years. I am interested in your project. Thank you!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(11 Commentaires)
4.1
Valuesolutions

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)
3.8
djpeka

Hello. As a professional programmer, I'm up for this task. Just hit me up.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)
3.9
superbpartner

hello,dear. I have read all your requirements for 'Small C# program to Compare CSV.' and I fully understood it. I am confident and I am sure that I am able to finish this project. Please come in contact with me, so tha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(5 Commentaires)
3.2
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
2.6
aviwalimbe

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(2 Commentaires)
2.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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
1.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0