C# app to compare two excel files

Closed

Description

A C# application to run on Windows XP or Vista to compare 2 MS excel files or csv files and generate a report showing discrepancies between the files.

The user should be able to select the two files stored on the system that the app is running on and then save the resulting report as an excel file with a name of their choice.

Each source excel or csv file will have a column with the header 'sku' and a column with the header 'qty'. The sku is the unique identifier, and the discrepancies should be in the qty column, however both files may not have all the same sku numbers. The resulting report should differentiate between three types of discrepancies. Type 1 is when the sku is present in both files but the qty is different. Type 2 is when the sku is present in the first file but not the second. Type 3 is when the sku is present in the second file but not the first. The final report will display this with three columns: 'sku','qty_1','qty_2'. The qty_1 and qty_2 columns will be populated with the value 'N/A' when the sku was not present in either the first or second source file, respectively.

Skills: .NET, Excel

See more: Compare 2 files excel, perl excel compare files, excel compare files generate, compare names files excel, vlookup compare files excel, excel compare files, write mongolian language excel files asp net app, excel compare app, compare files excel vba, macros excel compare files difference, export retail pro inventory files excel, excel macros create text files excel, excel web app, excel macro format phone numbers, plotting csv files excel

Project ID: #12190023

39 freelancers are bidding on average $111 for this job

macroPOL

Hello, I am Excel and VBA expert. Why do you want it in C#? I can do it but in VBA (macro in excel). Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$88 USD in 2 days
(51 Reviews)
5.3
doublebc

Hello, I have a lot of experience with C# and would be interested in helping you with this project. I actually already created the application and a video demo. You can go to the link below to view the video. htt More

$83 USD in 0 days
(24 Reviews)
4.6
jayamsoft

Hi, We are experienced programmer with more than 5 years of development experience here. We have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases li More

$155 USD in 3 days
(12 Reviews)
4.3
iqmax99

Hi I would like to work with you on this application. In fact I got most of the code ready from a previous project. If you are interested please contact me for details. EK B.Sc., MCP, MCAD, MCT(Microsoft Certified More

$100 USD in 6 days
(16 Reviews)
3.5
aanvikm

Hello, I have a similar application already created to compare 2 csv files. I can tweak to make this work. Thanks Aanvik

$155 USD in 3 days
(3 Reviews)
3.1
Iamtuheedakram

Hey i can do this job since i am expert in scrapping and automation. i have more than 3 years of work experience in this field. i will provide you with the app that will do the comparison. and will work accordingly to More

$200 USD in 2 days
(3 Reviews)
3.0
kandarpbhesaniya

A proposal has not yet been provided

$35 USD in 1 day
(3 Reviews)
3.1
senseoverflow

hi, i can implement this task for you. i have an experience in creating ui apps. why do they use 100 chars padding)))

$111 USD in 3 days
(2 Reviews)
2.3
$45 USD in 2 days
(6 Reviews)
3.0
p9technologies

Dear friend, I have 14+ years of experience in developing applications for windows and web platform using Microsoft technologies. I can build a Windows application that can prompt for excel input and provide output More

$100 USD in 7 days
(4 Reviews)
2.6
amirgull

Hello sir, I have vast experience of building applications on .Net, Hope you look forward to work with me. Thanks!

$40 USD in 2 days
(3 Reviews)
1.8
victorcastro

Hi, I'm already working in your project , I've done something similiar before and I really think can help you with it. So I'll sending you soon proof of my work in order to discuss price. You're welcomed to contact me. More

$200 USD in 3 days
(2 Reviews)
1.6
$100 USD in 5 days
(3 Reviews)
1.2
admin845

Hi, I am an expert in .Net with overall 10+ years of experience in designing and developing software. I have gone through you requirement and can deliver this project with high quality. As I am starting my caree More

$30 USD in 3 days
(1 Review)
1.0
$77 USD in 3 days
(1 Review)
0.8
mrchambers

I have developped a number of C# applications using the EPPlus .net library (http://epplus.codeplex.com/ )for working directly wih .xlsx/.xlsm files (but note not .xls). For this task I will use my own C#.Net Rapid Ap More

$120 USD in 2 days
(0 Reviews)
0.0
TheReaperCooL

Hey there! If you choose me, then I'll make this for you, but first I'll need 2 sample files for testing purposes. Also I'm new, and if you choose me, and I finish the job, then you get what you need, and I get g More

$111 USD in 3 days
(0 Reviews)
0.0
msampsell

A proposal has not yet been provided

$111 USD in 4 days
(0 Reviews)
0.0
$30 USD in 5 days
(0 Reviews)
0.0
emospy

I've made a lot of tasks like this in my projects. The task is simple and fun and I already have the code and the user interface ready. The user interface consists of three textboxes (containing the selected file nam More

$30 USD in 1 day
(0 Reviews)
0.0