Convert Excel Sheet to web based app

Question

0.00/5 (No votes)

See more:

SharePoint2010

First apologies if this is the wrong place to post this. I am not a programmer and I am not going to try to be one. I have an excel sheet that does some calculations for me at work that I would like to convert into a web based application so it can be used by more people. Now in the end I would have to contract someone to do but first I need ideas on how best to approach it so that it is robust enough. What are my options?

1. Is it possible to have the excel sheet in the back end, create like a form on the web which looks like the excel sheet. When the user puts in the required input data it gets copied to the excel sheet which does the calculations back end and then the result is copied from the sheet and displayed on the web app. Is this possible? What are the pros and cons?

2. Write an application from scratch. Which will have the ability to perform these calculations and also have a very good aesthetic look and feel.

3. Anything else......

Thanks.

Posted 22-Jan-16 22:50pm

SirBennybanks

Updated 23-Jan-16 0:26am

Richard MacCutchan

v2

Add a Solution

Comments

[no name] 23-Jan-16 5:02am

First try to implement from your side and then ask questions. It doesn't provide facility to do Project work.

SirBennybanks 23-Jan-16 5:06am

Hi Kumar, I am not trying to implement it myself. I just need ideas on possible ways to go about it from a wide range of professionals. So when I engage the IT guy I could make a better request.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2016-01-23T00:30:00

Broadly speaking, you cannot convert an excel sheet into a web based application.
You would need to create a website which
1. presents an input form to the user
2. captures the data
3. performs some actions on it
4. reformats it into some form of table
5. sends it back to the browser for display

As a non-programmer this is quite a task.