Find Jobs
Hire Freelancers

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

$30-250 USD

Completed
Posted over 5 years ago

$30-250 USD

Paid on delivery
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,
Project ID: 17767954

About the project

21 proposals
Remote project
Active 6 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
Awarded to:
User Avatar
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 would be to create an Excel template with a button at the ribbon and all the logic to create the new Excel file with the data populated, this logic will be performed using VBA and it will read a .txt file with the data to be entered. You just need to update the txt file with the data you want to be entered and then just press the button at the ribbon. Let me know your comments. I am available via chat
$180 USD in 5 days
5.0 (47 reviews)
6.0
6.0
21 freelancers are bidding on average $253 USD for this job
User Avatar
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 this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.
$250 USD in 4 days
4.9 (356 reviews)
8.0
8.0
User Avatar
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
5.0 (130 reviews)
6.6
6.6
User Avatar
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
5.0 (150 reviews)
6.7
6.7
User Avatar
phd in computer science having seven years of experience in Excel development using c# and. net.
$250 USD in 1 day
4.7 (83 reviews)
6.3
6.3
User Avatar
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
4.9 (42 reviews)
5.5
5.5
User Avatar
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 assigned projects so please do not hesitate to drop a message. Thanks
$500 USD in 7 days
4.8 (8 reviews)
4.9
4.9
User Avatar
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.
$244 USD in 3 days
5.0 (28 reviews)
4.9
4.9
User Avatar
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 Application , Businss product and many more. Core Expertise : 7+ Years in Asp.Net, C# MVC, AngularJS, SQL Server, JavaScript, HTML,LINQ , NodejS , JSON, Telerik , KendoUI , AWS , Azure , Socket programming , SignalR I also perform administrative duties including copying and faxing documents, answering telephones, transferring data, web research and reports to immediate supervisor. I feel that I can add professionalism and accuracy to your current team of professionals. With extensive experience supporting all levels of a department and working directly with external vendors,
$194 USD in 3 days
4.9 (26 reviews)
4.9
4.9
User Avatar
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 using the apache library Please contact me over chat to discuss the details Regards
$180 USD in 3 days
4.8 (29 reviews)
5.0
5.0
User Avatar
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
4.7 (22 reviews)
4.4
4.4
User Avatar
Hello Sir, I have over 10 years of experience in programming. I have made several Web and Desktop Applications. I have imported and exported excel files in C#. I have complete command over C#, ASP.Net, Javascript, SQL. In box me so that we can discuss. Thanks
$160 USD in 2 days
5.0 (1 review)
3.6
3.6
User Avatar
Hello, I read from the project description that you a console app that will fill an excel spreadsheet in a programmatic manner. I can do this project for you in 5 days at most 7days. I have 3 years of experience in C# and .net development. I can start right away If you have any questions, contact me through chat.
$133 USD in 10 days
5.0 (4 reviews)
2.8
2.8
User Avatar
Hello thanks for reviewing my bid. I have gone through your requirements as well as the word file which you have provided. I can definitely do it for you. I have 5 years of work experience in Microsoft Technologies Stack. we can discuss more over chat for a detailed description.
$222 USD in 15 days
5.0 (6 reviews)
2.4
2.4
User Avatar
I am a professional .NET developer. I have very strong knowledge in writing application using C# programming. If you are interested we can discuss further.. Thanks
$200 USD in 3 days
5.0 (1 review)
2.0
2.0
User Avatar
We have been creating/enhancing applications on .Net, Microsoft Technologies, various console applications, architect level experience with hands on working for SharePoint solutions, features, web-parts , workflows. Salesforce Platform for over 6 years. We are having the experience to customize enterprise-level search in complex systems of SharePoint. We are well versed with all functionalities of all versions of Sharepoint and its related service applications. We are also well versed in Agile and DevOps methodologies and have created solutions around Salesforce for organizations such as Healthcare, Real Estate firm, Banks/Financial Sector and Service Industry. Few companies that we worked with, in the recent past, are listed for your quick reference: Grenier Maltz Real Estate MiMedx Inc SunTrust Banks Inc (LInk) BBVA-Compass Bank Cancer Aid Society I’d like to see if we could help you guys out in any way. If needed I can share the profile of my Certified Developer who will be working on this project for you. We have worked extensively with PM tools like Trello, Redmine, Teamwork, Basecamp etc. Additionally, we are very well acquainted with cloud services like Google cloud, Azure, and AWS. Looking forward to having a quick call to understand your requirements in greater detail (S_kype : avinashamicable )
$155 USD in 3 days
5.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
Sacramento, United States
5.0
18
Payment method verified
Member since Apr 16, 2010

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.