/    Sign up×
Community /Pin to ProfileBookmark

Excel spreadsheet as web application

Copy linkTweet thisAlerts:
May 09.2012

Hey guys, I have a possible client. He wrote a huge excel spreadsheet with tons of formulas. He wants to get the spreadsheet on the internet, not as a downloadable document though. He wants the person to be able to enter some information in some cells and the rest is generated. Can someone please tell me how I can get this done.

to post a comment
HTML

9 Comments(s) ↴

Copy linkTweet thisAlerts:
@jalarieMay 15.2012 — There is nothing that I'm aware of that can do this automatically. You would have to have all of the formulae, etc., and program it from scratch in JavaScript. I'd be happy to give it a shot, but it won't be for free. Perhaps, you should post this in the "Work" area.
Copy linkTweet thisAlerts:
@jedaisoulMay 15.2012 — There is nothing that I'm aware of that can do this automatically. You would have to have all of the formulae, etc., and program it from scratch in JavaScript. I'd be happy to give it a shot, but it won't be for free. Perhaps, you should post this in the "Work" area.[/QUOTE]
Wouldn't JavaScript expose the logic to anyone and everyone? I doubt the client would want that. PHP or a similar server-side app would keep the detail more secure.
Copy linkTweet thisAlerts:
@jalarieMay 15.2012 — Wouldn't JavaScript expose the logic to anyone and everyone? I doubt the client would want that. PHP or a similar server-side app would keep the detail more secure.[/QUOTE]

You're correct, but nobody mentioned anything about security and JS gives an immediate answer without calling the server, again.
Copy linkTweet thisAlerts:
@ScottG89authorMay 16.2012 — Thank you guys very much.
Copy linkTweet thisAlerts:
@jalarieMay 17.2012 — Hey guys, I have a possible client. He wrote a huge excel spreadsheet with tons of formulas.[/QUOTE]

How many rows and columns are we talking about?
Copy linkTweet thisAlerts:
@rtretheweyMay 17.2012 — I'm surprised that nobody has mentioned [url=http://www.google.com/google-d-s/spreadsheets/]Google Docs Spreadsheets[/url]. It has the functionality and allows you to import .xls documents.
Copy linkTweet thisAlerts:
@corbingrimesMay 18.2012 — Yes try Google docs spreadsheet. It is the only possible answer for this question.
Copy linkTweet thisAlerts:
@jedaisoulMay 18.2012 — 
Yes try Google docs spreadsheet. It is the only possible answer for this question.
[/QUOTE]
My reading of the OP suggested that the spreadsheet was to be used as a form of commercial quote engine. The user is offered an input form on which he/she supplies some parameters, and the spreadsheet (or whatever) works in the background to produce the response.

If that is what was intended, does this spreadsheet have the facility to work transparently like that? If so, is there a charge for using it commercially?

Also it seems a little premature to rule out a server-side app written in PHP or whatever. In the past, I've used a spreadsheet to mock up an app then coded it once I had got the logic right. That wasn't a web app, but the principle applies.
Copy linkTweet thisAlerts:
@dellisdataJun 13.2012 — Google spreadsheets is a great way to organize, plus it's free of course. If you need an easy tool that gives you JSON embed code for your sites and a way to organize like spreadsheets - try a beta software called JSON Data. Tools like this are getting better and starting to pop-up for front-end developers, just keep your eyes open. thanks and let me know if this is relevant information.
×

Success!

Help @ScottG89 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.5,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...