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)
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
14 freelance font une offre moyenne de $164 pour ce travail
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.
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
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
Senior C# Expert! I have developed many programs using C# for +7 years. I am interested in your project. Thank you!
Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things
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
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 Plus
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.