Build Excel importer in

We need a C# class library to be developed to import the Excel file into the database.

The requirements are as follows:

>Validate the excel files for all the columns.

>Application Server wouldn't have microsoft excel installed on the server, so create the class library that can read excel file independently.

>Read the records from the excel and match with existing records in the database. If match found then enter the records from excel as child records in the related tables. If it doesn't match then create the parent record in the database and then enter the records from excel as child records in the related tables.

Sample excel file and DB schema will be provided later.

Skills: .NET, C# Programming, Excel, Microsoft SQL Server

See more: build excel pread sheets, build excel pivot table, converting dat files excel files using net, contact importer asp net, excel worksheet buyerseller net sheets, excel yield function net, write excel file datatable net, email contact importer asp net, implementing excel yield function net, dll excel sheet creation net 208, build outlook 2007 plugin net, user excel dynamic tables net, build excel vba functions, sample excel sheet inventory net change, contact importer yahoogmailhotmail net, excel compare program net, aspnet build excel pivot table, build travel booking software net

About the Employer:
( 0 reviews ) Toronto, Canada

Project ID: #20092224

47 freelancers are bidding on average $198 for this job


I have already created a C# based application that reads excel and saves in sql database -->Will use Closed XML so that excel will not need to be installed where this application runs -->Please provide validation deta More

$225 CAD in 7 days
(208 Reviews)

HI, I have a .net program that can read XLS files and upload into SQL server DB, I will customize it to do the matching and creation of parent records I can show u a demo for my program as soon as you contact me.

$1000 CAD in 7 days
(36 Reviews)

Hello I have almost 10 years of experience with C# and Microsoft .NET Framework Also, I am familiar with various frameworks for working with Excel files even if Excel is not installed (without Excel automation) Pe More

$106 CAD in 3 days
(798 Reviews)

======> Full Stack Sr. Software Professional having 10+ years experience. <===== => Technology : Web Application Windows/Desktop Application => Skills .Net Core 2.0, Angular 6, Angular 5, An More

$250 CAD in 15 days
(47 Reviews)

Hi, I will be using EPP package along with [login to view URL] to create excel importer. And I will be using sql bulk copy to directly insert rows into database (Fastest and most efficient way). Bulkcopy is way better then cop More

$120 CAD in 2 days
(63 Reviews)

Hello, I can do the development that you require to import excel files to sql server implemented the rules and validations that you mention in the description. Contact by chat for more details. I have experience in s More

$100 CAD in 3 days
(80 Reviews)

Hello. Nice to meet you. I have good skills in ".NET, C# Programming, Excel, Microsoft SQL Server", so that i 'm very interest to your project. I have checked description of your project "" carefully and i can do th More

$250 CAD in 3 days
(100 Reviews)

Hello, Greetings from Techcognizant!!! I have read your needs very carefully and will be the best fit for your project as we are experts in .net, c#, SQL, Excel and will do it for you as per your needs which you have More

$200 CAD in 7 days
(27 Reviews)

Hi, I am a result- oriented, meticulous and innovative Web Developer with 15+ years of experience building various types of websites using .Net Technologies - Asp.Net Web forms, ASP, MVC, SQL Server, LINQ, JQuery and More

$200 CAD in 1 day
(15 Reviews)

Hi I am a Dedicated Senior .Net Developer/ Database Administrator and System Administrator with 20 years of experience in Web/ Windows and Android Developments, Administration, Project Management System analysis, and More

$198 CAD in 7 days
(23 Reviews)

Hi,   I'm a .Net Professional with 9+ years of experience in Analysis / Design / Development with Distributed Web-Based, Client-Server Applications, based on different Solution Architectures using .NET Framework 4.0 / More

$200 CAD in 7 days
(18 Reviews)

Hi I can develop the C# class library which provides class and functions to load and parse excel file and insert or update into database. I will use NPOI which allow us to read excel file without MS Excel installed. I More

$140 CAD in 7 days
(53 Reviews)

Hi there, I can build a c# class library for the excel data matching. We have a team of .net expert who can help you.I can create a free demo for you. Please ping me to discuss more.

$160 CAD in 7 days
(22 Reviews)

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$146 CAD in 7 days
(51 Reviews)

Hi There, I had earlier created similar logic which was with csv file. For excel we need to use third party plugin (there are several free plugins available) since MS Word will not be there on server. I believe in go More

$100 CAD in 7 days
(17 Reviews)

Hi, I have over 10 years of industry experience in C#,, SQL Server. I have developed applications in C# and which do the same task as require. Additionally, I also developed ETL process in SSIS to tran More

$225 CAD in 7 days
(19 Reviews)

Dear client, I can do this excel import project and create as an independent class library . And the user no need to install excel in their PC. I did similar solutions before. I have more than 8 years of experienc More

$130 CAD in 5 days
(55 Reviews)

Hi, I am a Full stack developer in Microsoft technologies. My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end (th More

$250 CAD in 5 days
(19 Reviews)

I have many experiences C# , MSSQL. I have done several projects similar as yours. I can show you my projects via chatting. I can complete your project successfully. Thanks.

$250 CAD in 7 days
(23 Reviews)

Hello I can build a program in .Net that read an excel file , Validate it and import to your database Could we chat for more details ?

$250 CAD in 7 days
(6 Reviews)