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.
Yes try Google docs spreadsheet. It is the only possible answer for this question.
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.
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.