Forums | MacLife
You are not logged in.
#1 2008-08-05 12:58 pm
- Duhrod
- Member
- Registered: 2008-08-05
- Posts: 1
Excel Web Page
Is it possible to save an excel worksheet so it will work on a web page. I need to be able to input #s and have the web page automatically update itself.
Offline
#2 2008-08-05 1:04 pm
- sturner
- Royal High Poobah
- Moderator

- From: Carrollton, TX USA
- Registered: 2000-01-31
- Posts: 13779
Re: Excel Web Page
No. You'd need to use java or other scripting language.
I'm not dead yet.
There are 3 types of people, those who can count and those who can't.
"There are few things graven in stone, excepting your date of death."
Offline
#3 2008-08-05 1:45 pm
Re: Excel Web Page
sturner wrote:
No. You'd need to use java or a scripting language.
Fixed that for ya 
Java is OOP!
But like he said, you need something controller-level (a program) which saves your entries to a database and then renders said data to a webpage, like a servlet to pull the data from am html form and another to produce the page with an html table containing what you entered.
Other languages (probably with easier learning curves) can do it, too, I'm just tossing out an example.
Last edited by Antonio (2008-08-05 1:45 pm)
Offline
#4 2008-08-05 2:06 pm
- dv
- Negusa Negest
- Moderator

- From: Minneapolis, MN
- Registered: 1999-08-30
- Posts: 18092
Re: Excel Web Page
Google Docs.
"Now commences the process of cutting off the head, which generally takes from an hour to an hour and a half by an expert workman with a sharp blade." -Reuben Delano, Wanderings and Adventures
Offline
#5 2008-08-13 12:28 pm
Re: Excel Web Page
Antonio wrote:
sturner wrote:
No. You'd need to use java or a scripting language.
Fixed that for ya
Java is OOP!
But like he said, you need something controller-level (a program) which saves your entries to a database and then renders said data to a webpage, like a servlet to pull the data from am html form and another to produce the page with an html table containing what you entered.
Other languages (probably with easier learning curves) can do it, too, I'm just tossing out an example.
Thanks for unnecessarily riddling that post with buzzwords.
Offline
#6 2008-08-13 12:59 pm
Re: Excel Web Page
Daniel wrote:
Antonio wrote:
sturner wrote:
No. You'd need to use java or a scripting language.
Fixed that for ya
Java is OOP!
But like he said, you need something controller-level (a program) which saves your entries to a database and then renders said data to a webpage, like a servlet to pull the data from am html form and another to produce the page with an html table containing what you entered.
Other languages (probably with easier learning curves) can do it, too, I'm just tossing out an example.Thanks for unnecessarily riddling that post with buzzwords.
What buzzwords? Those are standard terms for the technologies used, and fairly spelled-out for a brief explanation, at that.
No offense, but this is the 'programming and web dev' forum. If you don't understand common terms for common concepts and common programmatic solutions, then this isn't the forum for you.
BTW, great job waiting eight days to reply with something so completely petty.
Last edited by Antonio (2008-08-13 1:30 pm)
Offline
#7 2008-08-16 12:40 am
- registered_user
- bulletproof
- From: padding: zero-pixels;
- Registered: 2000-12-19
- Posts: 16026
- Website
Re: Excel Web Page
Object Oriented Programming, while quite the fashionable term and even sexier abbreviation, is completely irrelevant when differentiating a scripting language from a programming language. Further, there are other programming languages beyond Java so the solutions aren't "Java or a scripting language", but rather, Java or other server-side language capable of evaluating the logic. So your "fix" isn't a fix at all, it's an elucidation of ignorance.
,xtG
tsooJ
Offline
#8 2008-08-16 12:59 am
- sturner
- Royal High Poobah
- Moderator

- From: Carrollton, TX USA
- Registered: 2000-01-31
- Posts: 13779
Re: Excel Web Page
Ah, but not all are as accessible, or well known outside programing circles.
I'm not dead yet.
There are 3 types of people, those who can count and those who can't.
"There are few things graven in stone, excepting your date of death."
Offline
#9 2008-08-16 2:20 pm
Re: Excel Web Page
registered_user wrote:
Object Oriented Programming, while quite the fashionable term and even sexier abbreviation, is completely irrelevant when differentiating a scripting language from a programming language. Further, there are other programming languages beyond Java so the solutions aren't "Java or a scripting language", but rather, Java or other server-side language capable of evaluating the logic. So your "fix" isn't a fix at all, it's an elucidation of ignorance.
,xtG
tsooJ
What?
I'll add to what Sturner said by quoting myself:
Antonio wrote:
Other languages (probably with easier learning curves) can do it, too, I'm just tossing out an example.
And "Java or a scripting language" is quite dead on, as PHP is probably the most popular option. Not all server-side languages are programming languages, some are scripting languages (such as PHP, or even server-side Javascript).
As for it ''not being a fix but an elucidation of ignorance", I'll take that as your desperate attempt at a flame and leave you with it. Your statement is an elucidation of ignorance all its own. It makes no sense, not even as a cheap attack.
Why is it when someone comes up with something that is intelligent and will work, there are always one or two who will come in and flame them? Trolls. What is this territorial BS about? Hell, I've even been around these forums as long as anyone else has (I changed my user name just a few years back). Not that it should make a difference. You're not the only web developers and programmers on the internet, and certainly not the only ones coming up with solutions to problems, so get over yourselves a little. Even if just a little.
(Edit: Added to the above statement -half of you don't even have properly or fully-functioning websites, so you probably shouldn't be so damn critical of anyone else right now).
The flame wars online are pretty well done, aside from the trolls. Most people are tired of them.
And come up with your own closing signature. Alien's been using that for nearly as long as he's been here.
FINALLY, as Sturner mentioned, Java's very well known. It's easier to explain a concept using a language which is very well known. Personally, I'd rather use it than PHP, and use it pretty often -two more reasons why I used it here. Not that I should really have to explain that, but I did, anyhow. For those of you who will obviously pick if I won't 
Last edited by Antonio (2008-08-16 2:36 pm)
Offline
#10 2008-08-16 5:07 pm
- Ice Cream Man
- With QP technology

- From: Mesa, AZ
- Registered: 2002-04-17
- Posts: 1324
- Website
Re: Excel Web Page
This sounds like a PHP SQL situation. Just build a web form that can accept your input and place it in and SQL server (database), and the build a script for outputting the data as an .xls
However if the machine you are working from can read Excel. Just email it to your own webmail, edit it on any machine that has web, and Excel, and send it back to yourself.
Last edited by Ice Cream Man (2008-08-16 5:09 pm)
Part of the inhumanity of the computer is that, once it is competently programmed and working smoothly, it is completely honest. -- Isaac Asimov
Offline
#11 2008-08-18 1:32 am
Re: Excel Web Page
Antonio wrote:
Daniel wrote:
Antonio wrote:
Fixed that for ya
Java is OOP!
But like he said, you need something controller-level (a program) which saves your entries to a database and then renders said data to a webpage, like a servlet to pull the data from am html form and another to produce the page with an html table containing what you entered.
Other languages (probably with easier learning curves) can do it, too, I'm just tossing out an example.Thanks for unnecessarily riddling that post with buzzwords.
What buzzwords? Those are standard terms for the technologies used, and fairly spelled-out for a brief explanation, at that.
No offense, but this is the 'programming and web dev' forum. If you don't understand common terms for common concepts and common programmatic solutions, then this isn't the forum for you.
BTW, great job waiting eight days to reply with something so completely petty.

Programs are not "controller-level," nor are server-side scripting technologies programs. Controllers do not interact with databases. Models do. Servlets do not pull data from an HTML form, nor do they produce pages.
No offense, but this is the "Programming & Web Dev" forum. If you don't understand common terms for common concepts and common programmatic solutions, then this isn't the forum for you.
Offline
#12 2008-08-18 2:18 am
Re: Excel Web Page
Daniel wrote:
Antonio wrote:
Daniel wrote:
Thanks for unnecessarily riddling that post with buzzwords.What buzzwords? Those are standard terms for the technologies used, and fairly spelled-out for a brief explanation, at that.
No offense, but this is the 'programming and web dev' forum. If you don't understand common terms for common concepts and common programmatic solutions, then this isn't the forum for you.
BTW, great job waiting eight days to reply with something so completely petty.
Programs are not "controller-level," nor are server-side scripting technologies programs. Controllers do not interact with databases. Models do. Servlets do not pull data from an HTML form, nor do they produce pages.
No offense, but this is the "Programming & Web Dev" forum. If you don't understand common terms for common concepts and common programmatic solutions, then this isn't the forum for you.
I never said any server-side language was a program, rather what I said is that they are used to write programs.
Yes, actually, servlets do pull data from HTML forms, via the form action attribute, which is used to connect the form to the servlet, and the javax.servlet.http.HttpServlet API which enables the servlet to collect the data and pass it on to a javabean, and theseare controller level. It's the model which is written to the database, rather than interacting with it (which is what the controller does in a model 3 MVC application).
Another servlet can then pull data from the database and generate a web page using the java.io.PrintWriter API and the request dispatcher API to pull in a header and footer to wrap the content, if it's part of a larger web application. Both servlets can use JNDI to connect to the database and several other APIs to read from and write to it.
Offline
#13 2008-08-18 10:29 am
Re: Excel Web Page
:giggle:
So many words, so little knowledge.
Offline
#14 2008-08-18 10:34 am
Re: Excel Web Page
Daniel wrote:
:giggle:
So many words, so little knowledge.
That's all you have left? Fix your broken links, come up with something more than your iWeb sites, go to school, learn how to program for the backend, then come back and talk trash.
Offline
#15 2008-08-18 4:07 pm
Re: Excel Web Page
Tee hee. So easy. I don't have to justify my unfinished portfolio or my iWeb blog to you. Though I do find your sanctimony amusing in light of your inability to alter filetype associations, or your assumption that an incorrect setting for an ad was intentional, or a total lack of understanding with respect to disabling the shuffle feature on an iPhone. And you can't be that much of a professional if you develop only for Firefox.
Frankly, you sound like someone who got a degree in Information Systems from the University of Phoenix, and now thinks he knows everything there is to know about development. You don't pull data from forms, nor do you serialize models into databases, nor is javax.servlet.http.HttpServlet an API, it is a class that is part of an API.
In any case, I'm done with this. If you want to continue being a condescending schmuck without the knowledge level necessary to justify that arrogance, go right ahead. I have no intention of wasting any more of my time on this elementary crap.
Offline
#17 2008-08-18 4:22 pm
Re: Excel Web Page
Daniel wrote:
In any case, I'm done with this. If you want to continue being a condescending schmuck without the knowledge level necessary to justify that arrogance, go right ahead. I have no intention of wasting any more of my time on this elementary crap.
I'm sorry, what was that, you say?
Daniel wrote:
Thanks for unnecessarily riddling that post with buzzwords.
Anyone who doesn't know how to do something so simple as pull form data to be written to a database table has nothing to say. You've failed to provide any explanation to reinforce any garbage you've thrown here.
That's why you produce broken garbage with iWeb.
Offline
#18 2008-08-21 10:00 pm
- registered_user
- bulletproof
- From: padding: zero-pixels;
- Registered: 2000-12-19
- Posts: 16026
- Website
Re: Excel Web Page
someone's touchy.
Offline
#19 2008-08-21 11:40 pm
- Ice Cream Man
- With QP technology

- From: Mesa, AZ
- Registered: 2002-04-17
- Posts: 1324
- Website
Re: Excel Web Page
Daniel wrote:
Tee hee. So easy. I don't have to justify my unfinished portfolio or my iWeb blog to you. Though I do find your sanctimony amusing in light of your inability to alter filetype associations, or your assumption that an incorrect setting for an ad was intentional, or a total lack of understanding with respect to disabling the shuffle feature on an iPhone. And you can't be that much of a professional if you develop only for Firefox.
Frankly, you sound like someone who got a degree in Information Systems from the University of Phoenix, and now thinks he knows everything there is to know about development. You don't pull data from forms, nor do you serialize models into databases, nor is javax.servlet.http.HttpServlet an API, it is a class that is part of an API.
In any case, I'm done with this. If you want to continue being a condescending schmuck without the knowledge level necessary to justify that arrogance, go right ahead. I have no intention of wasting any more of my time on this elementary crap.
And what is wrong with University of Phoenix? They are accredited, like any other school.
Part of the inhumanity of the computer is that, once it is competently programmed and working smoothly, it is completely honest. -- Isaac Asimov
Offline
#20 2008-08-22 12:00 am
- Ice Cream Man
- With QP technology

- From: Mesa, AZ
- Registered: 2002-04-17
- Posts: 1324
- Website
Re: Excel Web Page
Duhrod wrote:
Is it possible to save an excel worksheet so it will work on a web page. I need to be able to input #s and have the web page automatically update itself.
Let me see, I think I slightly misunderstood what you want.
You want the website to display information from your Excel spreadsheet, right. And have it update itself?
Use Java, or AJAX.
However do you need it to be in a spreadsheet, or can you use a database instead. Because you could forego the whole using the spreadsheet thing. And just make a good PHP web form that will interact with the database. And then if you really need it in .xls you can just make that output script like I said before. And of course you may not need the java or AJAX to do it the PHP/SQL way unless you really need the auto update info without refresh. Because you could just have the page refresh every so often.
Part of the inhumanity of the computer is that, once it is competently programmed and working smoothly, it is completely honest. -- Isaac Asimov
Offline
#21 2008-08-22 2:02 am
Re: Excel Web Page
Ice Cream Man wrote:
Daniel wrote:
Tee hee. So easy. I don't have to justify my unfinished portfolio or my iWeb blog to you. Though I do find your sanctimony amusing in light of your inability to alter filetype associations, or your assumption that an incorrect setting for an ad was intentional, or a total lack of understanding with respect to disabling the shuffle feature on an iPhone. And you can't be that much of a professional if you develop only for Firefox.
Frankly, you sound like someone who got a degree in Information Systems from the University of Phoenix, and now thinks he knows everything there is to know about development. You don't pull data from forms, nor do you serialize models into databases, nor is javax.servlet.http.HttpServlet an API, it is a class that is part of an API.
In any case, I'm done with this. If you want to continue being a condescending schmuck without the knowledge level necessary to justify that arrogance, go right ahead. I have no intention of wasting any more of my time on this elementary crap.And what is wrong with University of Phoenix? They are accredited, like any other school.
It's a for-profit online junk university that uses spam to sucker students into paying for a relatively worthless degree that devalues the degrees of those of us who went to a real university.
Offline
#22 2008-08-22 7:06 am
- mrreet2001
- Member

- From: NW Ohio
- Registered: 2005-05-25
- Posts: 4334
- Website
Re: Excel Web Page
Daniel wrote:
sucker students into paying for a relatively worthless degree
That describes most colleges and universities.
2.66Ghz QuadCore-Nehalem w/24"LED CD ---2.2Ghz BlackMB---15" 2.4Ghz MBP(work)
Dual 2.3Ghz G5 (4G Ram, 2x 250G HD)(10.5 server)--- 400Mhz G4 PM (10.4 Server)
1.5GHz Powerbook---1.6Ghz G5 iMac
"So he fels down in a poisoning gas."
Offline


