Terminé

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,

Compétences : .NET, ASP.NET, Programmation C#, Excel

en voir plus : 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

Concernant l'employeur :
( 8 commentaires ) Sacramento, United States

Nº du projet : #17767954

Décerné à:

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 5 jours
(34 Commentaires)
5.7

31 freelance font une offre moyenne de $225 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(262 Commentaires)
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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(70 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(40 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(37 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(78 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(60 Commentaires)
5.6
usmanhassan123

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(37 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(36 Commentaires)
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(40 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(25 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(25 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(26 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 25 jours
(5 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(5 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(10 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(3 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(5 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(14 Commentaires)
3.4