Suoritettu

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,

Taidot: .NET, ASP.NET, C# -ohjelmointi, Excel

Näytä lisää: 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

Tietoa työnantajasta:
( 8 arvostelua ) Sacramento, United States

Projektin tunnus: #17767954

Myönnetty käyttäjälle:

diorisaguilar

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 Lisää

$180 USD 5 päivässä
(34 Arvostelua)
5.7

31 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

schoudhary1553

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 Lisää

$250 USD 4 päivässä
(262 arvostelua)
7.5
XeeChaun

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] Lisää

$250 USD 5 päivässä
(70 arvostelua)
6.5
Piao217

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 Lisää

$222 USD 1 päivässä
(40 arvostelua)
6.5
seefattechnologi

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 Lisää

$500 USD 10 päivässä
(37 arvostelua)
6.1
rinabuoy13

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 3 päivässä
(78 arvostelua)
6.0
periyannas

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 3 päivässä
(60 arvostelua)
5.6
usmanhassan123

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

$250 USD 1 päivässä
(37 arvostelua)
5.7
rostovsoft

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 Lisää

$160 USD 5 päivässä
(36 arvostelua)
5.4
mkmomy

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. Lisää

$200 USD 6 päivässä
(40 arvostelua)
5.4
JMITSolution

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 Lisää

$200 USD 3 päivässä
(19 arvostelua)
4.7
kahilH

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 Lisää

$180 USD 3 päivässä
(25 arvostelua)
4.9
twentyten10

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 3 päivässä
(25 arvostelua)
4.9
vinod150987

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 Lisää

$244 USD 3 päivässä
(26 arvostelua)
4.7
unikinfoways1

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 Lisää

$833 USD 25 päivässä
(5 arvostelua)
4.2
williams115

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 Lisää

$250 USD 5 päivässä
(5 arvostelua)
4.4
roshanasim

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 Lisää

$194 USD 3 päivässä
(10 arvostelua)
4.2
yujun21

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 Lisää

$150 USD 5 päivässä
(3 arvostelua)
3.8
bianyunzhi95

I hope to see you in chat. Though I am new to freelancer.com 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 1 päivässä
(10 arvostelua)
3.9
sanmiawi

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 Lisää

$500 USD 7 päivässä
(5 arvostelua)
4.1
dev7fares

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

$55 USD 3 päivässä
(14 arvostelua)
3.4