Completed

C# .net website - Build HTML form that converts to Excel doc

We have a C# website that allows users to fill out an online form and then save that form data to a Database and convert it to an Excel file which is also stored on the server. We need to add a new form to this system. We currently have the form in Excel format (attached) and need someone to build the HTML version of the form and a script that will save the form and convert it to Excel. We already have a few similar forms setup in the system that you can use as examples, but this form is a bit more complicated than the ones we already have. The pages and database are already setup for this form, for those interested in the project I can send you login info and show you our current structure.

Project requirements are:

- Build online HTML form to match the Excel file. (white columns are calculated fields and do not need to be in the online form).

- Online form has four standard fields that are already pre-populated: Arbor Loan Number, Property Name, Key Principal, Date (these are already on the HTML form).

- On the Excel file there are rows for up to 50 properties, we don't want to display all of these fields to the user. Instead the initial form will only display two properties (one for Multifamily Holdings and one for Other Holdings) and each section will have a button to 'Add New' that will add a new property to the list.

- Each property (except the first one) should have a 'delete' button to remove a property if needed. The delete button should:

> confirm: Do you want to delete this property?

> delete the property and related data in the database

- The Excel file has two sections: 'Multifamily Holdings' and 'Other Holdings'. The online form should also have two sections to keep the different properties separate.

- We already have a database table to store the form data. All of our forms use this same table structure and the same process to save data. The database which stores data for this form is called 'schedule-of-real-estate-owned-s'

- When the user clicks 'Save' the form will:

> Submit to a file called '[login to view URL]' (already exists)

> This file will grab all the form data and save it in the correct table with a unique document 'id' so it can be retrieved later (already works)

> Take the form data and create an Excel file

> We are using ClosedXML ([login to view URL]) to do this

> The script should copy a blank copy of the real form and then use the saved data to populate the Excel file. We have an example of this process for another document that I can show you.

> Since we are creating a copy of the existing Excel file all the 'calculations' for fields should remain and be automatically populated when the user opens the Excel file. We don't need to worry about doing any calculations.

- Clicking 'Submit' will do the same thing as save except it submits the form to '[login to view URL]' which has a slightly different script that also marks the document as ready for approval.

- Clicking 'Export Excel' will download an Excel file of the current form data. If the current data has not been saved it will tell the user to save the form before exporting.

- You will need to create the script that adds the data to the Excel file. This same script is used when a user clicks Save, Submit or Export Excel.

Please let me know if there are questions about the project. Thanks.

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

See more: html form send excel, export html form data excel file, build html form joomla, html form results excel, export html form data excel, send html form data excel spreadsheet php, html form data excel spreadsheet, send html form data excel file, send html form data excel, html form data excel file, html form output excel, html form data excel, output html form values excel, html form save excel, html form post excel

About the Employer:
( 398 reviews ) Columbus, United States

Project ID: #15022231

Awarded to:

sureshdevi

I will develop and build html form that converts to Excel document. I will complete this work in 5 days. Relevant Skills and Experience C# Programming, ASP.NET, HTML, CSS, jQuery Proposed Milestones $265 USD - after More

$265 USD in 5 days
(102 Reviews)
6.4

40 freelancers are bidding on average $532 for this job

$526 USD in 10 days
(128 Reviews)
8.5
rkatoch

***// Specialized in ASP.NET,C#, MVC,SQL,WCF//*** Hello Sir, Warmest Greetings!! Over the last 12 years, I’m developing the websites and web apps of various kinds Using ASP.NET, C#,MVC, SQL, WCF, WEB SCRAPPING, More

$555 USD in 10 days
(13 Reviews)
6.7
shreesols

All the users will be logged in user? I think this is required as how we will identify when user will come back to site again? One more thing, I still have doubt on difference between Save and Submit. Relevant Skills More

$250 USD in 10 days
(32 Reviews)
6.8
UtopiaInt

I have read your description and we can do this easily. Please have a look at our portfolio: [login to view URL] [login to view URL] Relevant Skills and Experience We are a team of 9 expert professionals, ea More

$400 USD in 10 days
(5 Reviews)
6.4
Beacon09

Hi, I have read the description. I can create the online form that uses database and exports Excel file as described. Looking forward to seeing your reply. Thanks. Relevant Skills and Experience I have completed sim More

$600 USD in 14 days
(50 Reviews)
6.2
lurdsubas

Hello, I have read and understood the project description, it's quite detailed enough. I am a c# web developer with experience on generating ms office and PDF docs. Relevant Skills and Experience I am readily availabl More

$500 USD in 10 days
(33 Reviews)
6.3
jagdishbhatt38

I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). Relevant Skills and Experience I am having m More

$600 USD in 7 days
(26 Reviews)
5.3
carlosperezit

Im an expert in .net. i have been working in software development for the last 20 years

$277 USD in 10 days
(43 Reviews)
5.5
more123456

Hello, I have more than 10 years of experience in .NET Development with experience in all the technologies. I have developed and deployed more than 200 applications till date using .NET technologies Relevant Skills a More

$527 USD in 10 days
(16 Reviews)
5.6
dvfabia

Good Day! I have placed my bid with a timeline of 15 days to complete. Relevant Skills and Experience I am Microsoft Certified Professional with over 10 years of solid development experience using ASP.Net MVC and Exce More

$555 USD in 15 days
(111 Reviews)
5.6
Xcube09

Hi, I have read your post and can get this done for you. can you kindly share the login details so I can take a further look as you have said in your post. Looking forward to hearing from you. Cheers

$333 USD in 10 days
(14 Reviews)
5.2
WienFuJong

Hello, I read your description I hope to work with your project. I have great skills in following fields - C/C++,Java,C#,Object-C,Qt,MFC,HTML,CSS,PHP,WordPress,JS,NodeJS,IONIC,Cordova,Electron - Multi-Platforms:Win More

$526 USD in 3 days
(1 Review)
5.3
$3000 USD in 23 days
(3 Reviews)
4.5
Alprn2558

I would like to help you with your project. Relevant Skills and Experience I am an experienced .NET Devleoper for both Web & Desktop. Good at Front-end (Windows Forms, HTML, CSS, Javascript, Jquery, Bootstrap, Angular More

$250 USD in 10 days
(18 Reviews)
4.7
$250 USD in 3 days
(39 Reviews)
4.7
rockstardev3

Hi. I have good c# and web skills. I can do your job. Relevant Skills and Experience c# Proposed Milestones $444 USD - one time

$444 USD in 10 days
(10 Reviews)
4.3
originitsolution

Dear Sir, You have recently advertised for website developer. After reading your job description I am confident that I would be perfect fit for this position as my experience and abilities precisely match for your req More

$250 USD in 10 days
(1 Review)
3.8
Weborchid

We are the team that visualize, pens down ideas, adds in the essential ingredient of creativity and imagination and cooks up that perfect dish called brand. Lets discuss in details.

$742 USD in 10 days
(12 Reviews)
3.9
SymtecConsulting

Hi, What CSS framework do you use? Also do you need the excel calculations to be copied onto the HTML form? I have extensive development experience in c# excel automation , asp.net MVC. Regards. Relevant Skills an More

$250 USD in 3 days
(9 Reviews)
3.1
kleysulo

I run a software development / web design firm with over a decade of combined experience. C# / .NET and html forms are both among our specialties and we would be interested in this project. Relevant Skills and Experie More

$750 USD in 10 days
(1 Review)
2.9