Find Jobs
Hire Freelancers

Build Excel importer in C#.net

$30-250 CAD

Closed
Posted almost 5 years ago

$30-250 CAD

Paid on delivery
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.
Project ID: 20092224

About the project

45 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
45 freelancers are bidding on average $198 CAD for this job
User Avatar
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 details.. All excel columns will be validated based upon the given rules before moving to database -->Criteria will be satisfied based upon the condition E.g new record or existing records (will have to look at the tables as excel file to discuss further about it) -->What is the deadline ? Looking forward to have a chat with you to discuss further.
$225 CAD in 7 days
5.0 (222 reviews)
7.4
7.4
User Avatar
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) Perhaps, one question - what is DB? Is it MySQL or MSSQL or something else? Thanks
$106 CAD in 3 days
4.9 (906 reviews)
7.5
7.5
User Avatar
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.
$1,000 CAD in 7 days
5.0 (36 reviews)
7.0
7.0
User Avatar
======> Full Stack Sr. Software Professional having 10+ years experience. <===== => Technology : Web Application Windows/Desktop Application => Skills .Net Core 2.0, Angular 6, Angular 5, Angular 4, Angular2, Angular Js, C# .Net, MVC , Entity Framework, EF Core, Bootstrap, HTML5, CSS3, Bootstrap 3/4, Typescript, Javascript, Jquery, ASPBOILERPLATE, ASP .net ZERO, Twilio, Kendo UI, Google API, WPF, WCF,WEBAPI, Telerik, DevExpress => Database Language MSSQL, Oracle, MySQL, postgresql, Microsoft Access => Reporting Langauge: SSRS, Crystal Reports, RDLC, Syncfusion View, Pivot, Chart Reports , DevExpress => Reports: MIS Reports, Chart Reports, Stock Reports, Inventory Reports. => Project management tool: Azure DevOps, GitHub,GitLab, SVN, Bitbucket, JIRA, Trello => IDE : Visual Studio Code, Visual Studio 2017, Visual Studio 2015, Visual Studio 2010, PHPDesigner, WAMP
$250 CAD in 15 days
5.0 (60 reviews)
6.8
6.8
User Avatar
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 Database Developments. Delivering quality solutions to business problems within scope, budget and tight schedules whilst meeting strict specifications, from project planning, estimating to delivery. Please See my profile and the Reviews I would like to discuss the project in details with you for a better understanding of the requirements. SKILLS AND ABILITIES • Web | Windows Developments | API | Web Services| Automation | WPF • Payment Gateway Integration | Rest API • Device / Hardware Integration | Machine Software / VOIP • Android Developments • .NET | C# | Vb.Net | ASP.Net | VBA | MACROS • SQL Server | MY SQL | EXCEL | MS ACCESS | PostgreSQL |Sybase • MVC| | Web Forms | Win Forms| Java scripts | JQuery | Json | Ajax • HTML | PHP | CSS | Bootstrap |Graphic Design • IIS | Windows Server | DNS | Server Security | Active Directory • Crystal Reports | iText Sharp | EPPlus | Smart XLS • XML | XLT | CSV APPLICATION DEVELOPMENTS • Web Applications / Windows Applications • E-POS System • iMail API integration • Sage / XERO Accounting Integration tool • Verifone / SumUp Terminal API • Google Map integration • IP / VOIP phone integration • Digital Notice Board
$198 CAD in 7 days
5.0 (34 reviews)
6.0
6.0
User Avatar
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 similar projects using VISUAL STUDIO, ADO NET EF, LINQ TO SQL SQL SERVER MY SQL, WEB API, WCF, C #, VB.net among others
$100 CAD in 3 days
5.0 (88 reviews)
6.1
6.1
User Avatar
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 JavaScript tools. I always try to provide quality work and plans projects and carries them out so that projects are completed ahead of schedule and under budget. I prefer having long term relationships with my clients and constantly available for support work as and when required. I have gone through the work description and I understood that i have to write libraries for importing data from excel in database, I did these types of work several times for my clients and I can do this very quickly. It will be a pleasure to work with you if you will given me the opportunity. Please provide me Sample excel file and DB schema, so I will complete this work as soon as possible. I’m looking forward to working with you! Thank you, Reyansh N
$200 CAD in 1 day
5.0 (18 reviews)
6.1
6.1
User Avatar
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 that well. I hope to work with you. Contact me please. Thank you. From Yang Li.
$250 CAD in 3 days
4.8 (100 reviews)
6.0
6.0
User Avatar
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
5.0 (22 reviews)
5.8
5.8
User Avatar
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$100 CAD in 5 days
4.9 (80 reviews)
5.6
5.6
User Avatar
I can do it by vb.net, I have experience in MS SQL server and VB.net more than 12 years. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.net and SQL server with all versions, Crystal reports, also expert in iis and Windows servers 2005, 2008, 2012… Other skills: Php, my sql , technical & Sage ACCPAC ERP support, SQL Replication,Excel vba and macros,Access vba, Microsoft office(Word, Excel, PowerPoint, Access). Best Regards. Khaled Alflah
$250 CAD in 4 days
5.0 (18 reviews)
5.5
5.5
User Avatar
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 good communication and usually, reply within minutes of ping from you. I'll wait for your ping on chat to discuss more on the project. I have more than 10 years of experience in developing .NET solutions with building small and big distributed high-load applications. I am a technologist at heart with the right intent and skillset to deliver high-quality and stable projects in web application and hybrid mobile application using new technologies. Regards, Shobhit Pundir
$100 CAD in 7 days
4.9 (28 reviews)
5.7
5.7
User Avatar
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
4.8 (53 reviews)
5.7
5.7
User Avatar
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 transfer data from different file sources like text, excel, csv to database. You task can be done both using C# and SSIS. However, if your data volume is big, I would like to suggest to do this task in SSIS (SQL Server Integration Services). SSIS is more robust and can transfer millions of rows in seconds. I look forward to hearing from you. Regards, Farooq
$225 CAD in 7 days
5.0 (19 reviews)
5.3
5.3
User Avatar
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 (through stored procedures). I have 7 years of experience as a full time software developer. Kindly contact me, lets discuss your requirements.
$250 CAD in 5 days
4.9 (23 reviews)
5.4
5.4
User Avatar
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
4.9 (23 reviews)
4.9
4.9
User Avatar
Hello my name is Fares, I can get it done perfectly as you want let's chat when you are online, Thanks
$140 CAD in 7 days
4.7 (21 reviews)
4.4
4.4
User Avatar
Hello Greetings for the day … !!! I am Mukesh and would like to put forward my candidature for your job opening. I have viewed your needs and found that you are looking for an ASP.NET,mvc,c# Angular developer. I’m very interested in your job post. I believe that my abilities would be perfect for your job. I am proficient in C#, ASP.NET, HTML/CSS, MS SSIS and SQL and have extensive experience with JavaScript, AJAX and vb.net. My attention to detail, communication and time management skills have proven beneficial to various software and systems development projects for business in such areas as healthcare, retail and logistics. Given a chance for an interview, I will be happy to discuss in detail about the requirement and assist you. I’m available for work 40 hrs/week. Looking forward to working with you soon. Regards, Mukesh
$140 CAD in 7 days
4.7 (7 reviews)
4.1
4.1
User Avatar
Hi, please consider chat with me. Software development experience: 2001 My development skills are mainly focused on Microsoft stack, Have been involved in projects with other tool chains as well. Languages: C/C++ 98, 11, 14, 17 C# Typescript/Javascript Objective-C/Swift Java SQL QBasic/VB/VB.NET Target Platforms: Windows Desktop: Win32, MFC/ATL, Winforms, WPF, UWP, WCF, .Net .Net Core Microsoft Azure/IIS: Asp.net, Asp.net core, Entity Framework, MsSqlServer, Sqlite, MySql, Azure Storage, Azure Computing, Azure Web Apps. iOS: Cocoa, Xamarin, Ionic, React Native Mac OS X: Cocoa, Carbon Android: Android SDK, Xamarin, Iconic, React Native Web Front-end: HTML, CSS, Angular, React, Vue, jQuery, Bootstrap Chrome/Firefox/Edge: extension api Network/Service Protocols: TCP/IP, UDP, HTTP, WebService(SOAP), Web/Restful API, WebSocket/SignalR General Knowledge: Windows OS, Inter-Process Communication, Multi-threading, Concurrent programming. Office Word, PowerPoint, Excel. I have the ability to deliver quality software solutions.
$199 CAD in 2 days
5.0 (7 reviews)
3.9
3.9
User Avatar
Hi there, We've reviewed the details of your project and we can create the library and project to read excel files and save the records in the said tables types. We've excellent skills in this sort of tasks. We've recently worked with NPI medical record files. Very similar task just the different technology. Let us know when you're online to discuss it further. Thank you!
$250 CAD in 5 days
3.8 (2 reviews)
4.5
4.5

About the client

Flag of CANADA
Toronto, Canada
0.0
0
Member since Sep 11, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.