Programatically populate an Excel spreadsheet using C# -- Office Automation is allowed.

This project involves programatically populating an Excel spreadsheet. The solution must be a console application written in C# that reads the data from an input file, opens and populates a Excel template file I have provided, and then saves the results in another Excel file. The template file contains a significant number of fields, but I only need help populating the fields that involve pressing a button on the spreadsheet. The solution may use Office Automation although I would prefer a solution that did not (however, I realize it may be extremely difficult to populate the spreadsheet without automation). I have enclosed a zip file containing a Word doc describing the requirements in detail, the template file, a sample output file that I generated manually to provide an example of what the resulting spreadsheet should be like, along with the data I used to manually create the file.

Note that the template spreadsheet contains buttons that run macros that allow additional data to be inputted so in your solution so your solution will most likely need to programatically click those buttons. For example, if the input data contains two "Deferred Maintenance" items, your program would need to click the "Add Deferred Maintenance" button to make the second Deferred Maintenance row visible so that the data can be added . Please read the attached requirements doc for more information.

Note that this project originally required that Office Automation could not be used however I have since dropped that requirement,

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

See more: create excel file in c# using interop, c# excel library, c# create excel file programmatically, create xlsx file in c#, create excel file in c# from datatable, create excel file in c# without using interop, create and save excel file in c#, excel workbook c#, office staff salary list excel spreadsheet, write excel files mfc microsoft office spreadsheet, reports using office automation windows form application, using excel spreadsheet data mining, online form populate excel spreadsheet, excel spreadsheet automation website, populate excel spreadsheet folder, excel spreadsheet automation, populate sales excel spreadsheet, populate excel spreadsheet data outlook email, download web page existing excel spreadsheet using vbscript, payroll spreadsheet using excel

About the Employer:
( 8 reviews ) Sacramento, United States

Project ID: #17767954

Awarded to:


Hi! The Office Automation probably wont be needed since the macro routine names are available, hence, the workflow of each button can be simulated by calling the right method. As a suggestion, an alternative solution More

$180 USD in 5 days
(34 Reviews)

31 freelancers are bidding on average $225 for this job


Hello! This is vibrant webtech and I was glad to see that you're looking for help for project Programatically populate an Excel spreadsheet using C#. I've delivered more than 400 + projects in the last 5 years and More

$250 USD in 4 days
(262 Reviews)

hi. I have 5+ years of experience in C#. I have worked a lot with Excel files from C# programs. I have done similar projects, filling Excel sheet with data. here's video demo of one: ---( [login to view URL] More

$250 USD in 5 days
(70 Reviews)

Hi, I read your post with interest and I can handle it. I have developed many Windows desktop applications in various fields including Office Automation. Especially I have a very rich experience in business system de More

$222 USD in 1 day
(40 Reviews)

Hey!! I have checked your attached Zip and Doc file and Highly interested to get started on this project. I am C# Developer having 6 Years experience in analysis and development of client/server, windows and we More

$500 USD in 10 days
(37 Reviews)

Hello, I am experienced exce/c#l expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$222 USD in 3 days
(78 Reviews)

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. ok. Willing to take up your project. Thank you, Regards.

$250 USD in 3 days
(60 Reviews)

phd in computer science having seven years of experience in Excel development using c# and. net.

$250 USD in 1 day
(37 Reviews)

I have more than 10 years of experience in professional .NET software development for both web and desktop and databases (generally MS SQL) Also I have an experience in developing large appliction on VBA. And yes More

$160 USD in 5 days
(36 Reviews)

Dear client, I have experience in such interop actions on all office tools. I can show you the demo. What I did is loading office to a windows app and it working fully inside a windows desktop app inside a panel. More

$200 USD in 6 days
(40 Reviews)

I'm very interested in your project. I have a lot of experience with c# programming and I've checked the attached document.. I'm a full stack developer and I can work right now. Please contact me so that we can disc More

$200 USD in 3 days
(19 Reviews)

Hello I am a highly skilled java developer , if the c# language requirement is not a must then it would be a pleasure to have this discussion with you over chat I offer to implement an automated solution in java usin More

$180 USD in 3 days
(25 Reviews)

I have all the skills required for this project and I believe I can deliver this project on time and with all requirements implemented

$211 USD in 3 days
(25 Reviews)

Hi Hope you well ! I am Vinod Kumar. I am working as Senior Software Developer in IT company. I have 8+ years experience in .NET with C#,VB,ASP.NET, Web Service, WCF, Javascript, JQuery, SQL, XML ,XSLT and HTML More

$244 USD in 3 days
(26 Reviews)

Hello Sir, First of all, thanks for the detail requirement. I have read your requirement very carefully and I understood your requirement very carefully. I have read your requirement and understood that you like t More

$833 USD in 25 days
(5 Reviews)

Hi, there - My name is Phong. I have read your job description and I am very interested in this project because I have good experience with C# programming. I would love to speak with you further about taking this pro More

$250 USD in 5 days
(5 Reviews)

I am having 7+ years of experience in ASP.Net/C# technology development. I have provided many enterprise level solutions like ERP, CRM, HRMS , Payroll, POS, Online flight booking engine, HRMS, Ecommerce , Online Chat More

$194 USD in 3 days
(10 Reviews)

Hello! I've clearly read your requirements and it's very interesting. I'm expert in c# programming. I will develop script that output excel. If you choose me, you will see my high skill and best qualities. Please c More

$150 USD in 5 days
(3 Reviews)

I hope to see you in chat. Though I am new to I am an experienced c# developer with full-stack knowledge and career. I'm sure I can do this perfectly. Thanks for your kind attention.

$120 USD in 1 day
(10 Reviews)

Hello, hope you're having a great day? I have gone through the attached files and I understand what you need done. I will like to create a robust solution for you in the best time possible. I am dedicated to completing More

$500 USD in 7 days
(5 Reviews)

Hello my name is Fares, i can get it done perfectly as you want let's chat when you are online,Thanks

$55 USD in 3 days
(14 Reviews)