Closed

Build Excel importer in C#.net

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

53 freelancers are bidding on average $195 for this job

customizedata

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
(203 Reviews)
7.2
HussienSharaf

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)
7.0
vano101

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
(755 Reviews)
7.2
khp31

======> 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
(46 Reviews)
6.5
mehta2010

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
(60 Reviews)
6.7
vbhavesh448

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
(24 Reviews)
5.9
paskal77

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)
6.0
ReyanshN

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)
6.0
Artopix

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
(21 Reviews)
5.7
lightingdavid

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)
6.0
eramitjain9

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
(16 Reviews)
5.6
kusal77

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
(18 Reviews)
5.3
desconit

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

$225 CAD in 7 days
(17 Reviews)
5.3
mkmomy

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
(49 Reviews)
5.6
carlosperezit

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)
5.6
shobhitpundir

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
(13 Reviews)
4.9
xutao650

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
(35 Reviews)
5.0
Victorier006

hello,how are you. i read your bid carefully. i am C#, .Net expert and have full experience for 7 years. C#, .Net is my top skill and my interested skill. I can provide most quality and high fast. if you want to succes More

$150 CAD in 7 days
(7 Reviews)
4.9
nddungha

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)
4.8
deepthi2889

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
(18 Reviews)
4.7