C# app to compare two excel files

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.

Fähigkeiten: .NET, Excel

Mehr darüber Compare 2 files excel, perl excel compare files, excel compare files generate, c# programming, .net, microsoft excel, 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

Über den Arbeitgeber:
( 0 Bewertungen ) India

Projekt-ID: #12190023

38 Freelancer bieten im Durchschnitt $110 für diesen Job


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 Tagen
(60 Bewertungen)

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 Mehr

$83 USD in 0 Tagen
(25 Bewertungen)
$45 USD in 2 Tagen
(11 Bewertungen)

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 Mehr

$155 USD in 3 Tagen
(12 Bewertungen)

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 Mehr

$100 USD in 6 Tagen
(19 Bewertungen)
$77 USD in 3 Tagen
(5 Bewertungen)

A proposal has not yet been provided

$35 USD in 1 Tag
(10 Bewertungen)

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 Tagen
(3 Bewertungen)

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 Mehr

$200 USD in 2 Tagen
(4 Bewertungen)

Hello, The kind of small tool that you need can be solved faster and easily with a Excel VBA macro. After pressing a button the standard Browse window appears in order to choose the first file and then again for the Mehr

$60 USD in 3 Tagen
(12 Bewertungen)

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

$40 USD in 2 Tagen
(5 Bewertungen)

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 Tagen
(2 Bewertungen)

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 Mehr

$100 USD in 7 Tagen
(4 Bewertungen)

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 Mehr

$30 USD in 3 Tagen
(2 Bewertungen)

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. Mehr

$200 USD in 3 Tagen
(2 Bewertungen)

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 Mehr

$111 USD in 3 Tagen
(1 Bewertung)

A proposal has not yet been provided

$111 USD in 4 Tagen
(0 Bewertungen)

Hi. We are ready to start the project Development after checking out the project details We are a Genuine Website, Mobile Application Design & Development Company with 5 year’s experience. Our Professionals have worke Mehr

$133 USD in 3 Tagen
(0 Bewertungen)

I have developped a number of C# applications using the EPPlus .net library ([login to view URL] )for working directly wih .xlsx/.xlsm files (but note not .xls). For this task I will use my own C#.Net Rapid Ap Mehr

$120 USD in 2 Tagen
(0 Bewertungen)
$30 USD in 5 Tagen
(0 Bewertungen)