Quantcast

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

Antonio
Now with more cowbell!
From: San Francisco, CA
Registered: 2007-01-16
Posts: 689
Website

Re: Excel Web Page

sturner wrote:

No. You'd need to use java or a scripting language.

Fixed that for ya wink

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

Daniel
[dp] design#
From: Melbourne, FL
Registered: 2000-11-21
Posts: 9706
Website

Re: Excel Web Page

Antonio wrote:

sturner wrote:

No. You'd need to use java or a scripting language.

Fixed that for ya wink

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.


Airman Dan
Private Pilot, Instrument Airplane Single-Engine Land
http://homepage.mac.com/dp.design/.Pictures/atat/AtAT-Banner.jpg

Offline

 

#6 2008-08-13 12:59 pm

Antonio
Now with more cowbell!
From: San Francisco, CA
Registered: 2007-01-16
Posts: 689
Website

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 wink

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

Antonio
Now with more cowbell!
From: San Francisco, CA
Registered: 2007-01-16
Posts: 689
Website

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 roll

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

Daniel
[dp] design#
From: Melbourne, FL
Registered: 2000-11-21
Posts: 9706
Website

Re: Excel Web Page

Antonio wrote:

Daniel wrote:

Antonio wrote:

Fixed that for ya wink

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.

lol

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.


Airman Dan
Private Pilot, Instrument Airplane Single-Engine Land
http://homepage.mac.com/dp.design/.Pictures/atat/AtAT-Banner.jpg

Offline

 

#12 2008-08-18 2:18 am

Antonio
Now with more cowbell!
From: San Francisco, CA
Registered: 2007-01-16
Posts: 689
Website

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.

lol

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

Daniel
[dp] design#
From: Melbourne, FL
Registered: 2000-11-21
Posts: 9706
Website

Re: Excel Web Page

:giggle:

So many words, so little knowledge.


Airman Dan
Private Pilot, Instrument Airplane Single-Engine Land
http://homepage.mac.com/dp.design/.Pictures/atat/AtAT-Banner.jpg

Offline

 

#14 2008-08-18 10:34 am

Antonio
Now with more cowbell!
From: San Francisco, CA
Registered: 2007-01-16
Posts: 689
Website

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

Daniel
[dp] design#
From: Melbourne, FL
Registered: 2000-11-21
Posts: 9706
Website

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.


Airman Dan
Private Pilot, Instrument Airplane Single-Engine Land
http://homepage.mac.com/dp.design/.Pictures/atat/AtAT-Banner.jpg

Offline

 

#16 2008-08-18 4:18 pm

Alien
Forum Czar
Administrator
From: Republic of Amsterdam
Registered: 1999-07-05
Posts: 16942
Website

Re: Excel Web Page

Knock it off.

.tsooJ


http://macstack.net/forums/images/smilies/lol.gif

Offline

 

#17 2008-08-18 4:22 pm

Antonio
Now with more cowbell!
From: San Francisco, CA
Registered: 2007-01-16
Posts: 689
Website

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

Daniel
[dp] design#
From: Melbourne, FL
Registered: 2000-11-21
Posts: 9706
Website

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.


Airman Dan
Private Pilot, Instrument Airplane Single-Engine Land
http://homepage.mac.com/dp.design/.Pictures/atat/AtAT-Banner.jpg

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

 

#23 2008-08-22 7:47 am

Miles
Now I fight for wisdom!
Administrator
From: Michigan
Registered: 2001-07-21
Posts: 4506
Website

Re: Excel Web Page

dvpierce wrote:

Google Docs.

Offline

 

Board footer

Powered by PunBB 1.2.6
© Copyright 2002–2005 Rickard Andersson