Completed export datatable to Excel with dropdown lists

We require that an datatable be exported to an excel worksheet using (VB or C#). This can use the Microsoft interop dll's

This exporter must create dropdown lists with data

Example dateable header

Title, Name, Surname, Gender, Date of Birth

The title and Gender columns need to be dropdown lists created from the application as they will be dynamic at the time of export

Data for Title

Mr, Mrs, Miss, Dr, Prof

Data for Gender

Male, Female

Sample Data: (in a datatable setup on app/form load)

Mr John Smith Male 19/03/2001

Miss Sally Person Female 22/08/1998

Prof Clever Cloggs Male 23/09/1990

This is a simple dataset, ours is allot bigger and the dropdowns are dynamic and are only be known at the time of export, so setting up a template workbook with dropdowns prepopulated will not suffice.

Skills: .NET, ASP.NET, C# Programming, VB.NET

See more: create drop down list in excel using c#, closedxml documentation, export datatable to excel .xlsx in c#, closedxml read excel, create a dropdown in excel programmatically using openxml, net write datatable excel, export datatable excel 2008, net component export datatable excel, asp net export datatable excel, export datatable excel net vbnet, asp net export data excel, export datatable excel asp net visual basic, export datatable excel visual basic net, asp net export datatable excel vb net, asp net vb export datatable excel, asp net vb net export datatable excel invoke application

About the Employer:
( 4 reviews ) Basingstoke, United Kingdom

Project ID: #19465457

Awarded to:


Dear client, I can write program to upload the to excel from reading from data table and make drop downs inside excel sheet. I have more than 8 years of experience in software development and web development u More

£95 GBP in 3 days
(60 Reviews)

54 freelancers are bidding on average £144 for this job


Hello, As an experienced developer and having sound knowledge in working with Microsoft interop, i am very much interested to do this project. One thing i am not clear, what is the use of the dropdowns of Titl More

£98 GBP in 2 days
(254 Reviews)

Hi! I have done it with the Interop and also without it. I would like to do this for you. I'm willing to do the first part today and show it to you without being awarded, just to prove to you that I'm the right pick More

£210 GBP in 4 days
(41 Reviews)

Dear Hiring Manager, I have 9+ years experience in .net platform , MVC , .net core and SQL Server I have built multiple projects based on .net and later using .net core sql server , entity framework , entityframework More

£225 GBP in 2 days
(33 Reviews)

Hello, I have 11+ years of web development experience in ASP.NET Core, ASP.NET MVC, ASP.NET Web forms(C#), Classic ASP, SQL Server, HTML5, CSS, jQuery, javascript, JSON and XML. I have handled similar projects. F More

£150 GBP in 10 days
(53 Reviews)

Very interesting requirements!! YOU NEED: An datatable be exported to an excel worksheet using (VB or C#) After reading the details - We feel that this should be doable. However, to give you an accur More

£150 GBP in 3 days
(18 Reviews)

Greetings! I am a .NET Developer having an extensive knowledge in building Web and Desktop Apps using C# and ASP.NET. I am readily available to start my work on this project. Please feel free to message me back so you More

£200 GBP in 2 days
(69 Reviews)

Hi, How are you My video portfolio: [login to view URL] I am rated in top 3% freelancers here on my .Net C# Programming skills. I make sure you get quality product because I don?t only complete require More

£125 GBP in 7 days
(31 Reviews)

Hello, I'm Abu Gosia. I'm interesting in your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

£194 GBP in 7 days
(111 Reviews)

Hello After reading over your application this looks like a perfect fit for my skills sets .I am Experienced full stack developer.I am immediately available for this [login to view URL] in MVC,C# ,Web Services, SOAP More

£135 GBP in 7 days
(55 Reviews)

Hello Sir, I've read your requirements very carefully, and I understand that you need to export the data displayed in a datatable to an excel sheet, I understand that some values are displayed in dynamic dropdown list More

£100 GBP in 3 days
(40 Reviews)

Hi Nice to meet you. I'm expert specially .net mvc. No problem to export datatable as excel. If you want sqlserver, I can use entityframework for that. Thanks for read. Regards Lian

£100 GBP in 3 days
(39 Reviews)

Hi there! I am interested. I have done this type of task before but using pure .Net library. Using the Office Interop on server based application such as ASP.Net website is not recommended. Please let me know if y More

£75 GBP in 4 days
(118 Reviews)

I can do this task by using OpenXML lib to generate exel file with dropdown. If openxml cannot do, I can use excel interoperate to done it.

£55 GBP in 3 days
(66 Reviews)

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

£118 GBP in 3 days
(23 Reviews)

Hello, Im very much interested to work on this. I have more than 10 years of experience in .NET and also have experience Interop dlls. Also i will recommend to see best options to build on this like Openoffice, etc More

£80 GBP in 3 days
(70 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

£220 GBP in 5 days
(12 Reviews)

I will create this export feature for you which will also create a dropdown list in excel. Programmer with more than 10 years of development experience here. I have handled production applications with various More

£75 GBP in 3 days
(37 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 GBP in 7 days
(18 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

£133 GBP in 10 days
(31 Reviews)

Hello i am ready to help you to convert the datatable to excel sheet using c# (forms or mvc) i can start now waiting your answer Thank you

£53 GBP in 1 day
(54 Reviews)