sycogrim08
Well-Known Member
oh and one more thing i did try by going eg: =SUM(submissions.html!B6:AF6) it doesnt work and neither does inserting the directory of where the webpage is based...
-
Join the MyBroadband community
South Africa’s biggest forum. Discuss, discover, and connect with thousands of members.
-
Question of the Day: What's the most interesting small town you've visited in South Africa?
PHP login script
- Thread starter sycogrim08
- Start date
FarligOpptreden
Executive Member
Well, STERKTE!
sycogrim08
Well-Known Member
huh?
ok it looks like i have the Web pros themselves confused... im sorry guys I thought it would have been done before.What you're asking for is 2 Excel spreadsheets hosted online, to be linked and displayed online, right? I'm just trying to get my head around this one. Actual spreadsheets, that the directors are opening, or html converted from Excel?
sycogrim08
Well-Known Member
ok what I will do is email you because I dont think I can post up images here and ill take a picture and then you can see exactly what I mean... its a little hard to explain I would have to show you exactly what I am needing to do...
FarligOpptreden
Executive Member
Raithlin, PLEASE post a more detailed description of the problem when he/she/it mailed you. I really can't figure out what's supposed to happen here. This is one of the most confusing request, I guess, in the history of Web development.
Do a PHP login script? Link 2 Excel spreadsheets? Over 2 different pages? And "freeze" certain cells? Do calculations on them? Using FRONTPAGE 2003?!
Do a PHP login script? Link 2 Excel spreadsheets? Over 2 different pages? And "freeze" certain cells? Do calculations on them? Using FRONTPAGE 2003?!
FarligOpptreden
Executive Member
I think a part of this problem statement just elevated itself to "signature quote" quality...
I think a part of this problem statement just elevated itself to "signature quote" quality...
Dibs.
Waiting.
FarligOpptreden
Executive Member
NO! Not MY quote!
sycogrim08
Well-Known Member
Thats exactly what I want to do... I sorted out the PHP login script thats one problem solved now the next things is when you click on insert-web component the you click on spreadsheets and charts then you click office spreadsheet then do the same on page 2 but then you know how you can type in formulaes for the spreadsheets I wanna do that but be able to say ok =sum(page1!A1:B1) now this formula must be used in page 2 therefore linking the 2 pages together do you guys understand?
sycogrim08
Well-Known Member
in other words you are saying the cells A1 and B1 on the second page are going to reflect on cells A1 and B1 on the first page...
sycogrim08: You're speaking to web developers here - people that would typically re-create what you are trying with a database-driven web application. What you are doing - PHP with FP2003 and Web Components - is unheard of, and generally looked down upon (or ridiculed). I can see you were straight up in admitting you are new to this, so I won't beat around the bush. I applaud you for trying, but I think your bosses have asked too much from you at this point.
I for one can't help you - I haven't touched FrontPage <shudder> since '98. If you wanted to do something like this in .Net, or even straight PHP I may be able to help, but not the way you suggest. I wish the best of luck to you.
I for one can't help you - I haven't touched FrontPage <shudder> since '98. If you wanted to do something like this in .Net, or even straight PHP I may be able to help, but not the way you suggest. I wish the best of luck to you.
sycogrim08
Well-Known Member
well thanks mate I guess this would be a good time for me to put the idea forward to Microsoft themselves seeing as this has not been heard of before... but i must truly say thank you guys so much for the help I guess I will have to work another way around this problem and probably just make the file downloadable and make it user friendly ...
Thanks again I really do appreciate the help.
... Thanks again I really do appreciate the help.
FarligOpptreden
Executive Member
Lesson 1 in Web Development:
Web pages are state-less. This implies that the moment you navigate to the next page (i.e. away from sheet 1 and to sheet 2), the page gets "destroyed". There are ways of passing through parameters to a new page and even shoving data into a session variable (applicable only to the logged-in user), but I can think of no feasible way in which you can access a "page" like a spreadsheet in a workbook.
To be honest, I don't even think Microsoft will be able to give you a feasible answer to your problem. Quite frankly, I think you might even embarrass yourself by stating your problem to them. They would, like Raithlin, just suggest the use of a SQL database and to perform queries against the data in the database. It seems to me that what you are trying to do is to use your Excel spreadsheets as a sort of pseudo-database for data storage purposes. You can build a much more sophisticated application, with better user interaction by applying proven web technologies.
Web pages are state-less. This implies that the moment you navigate to the next page (i.e. away from sheet 1 and to sheet 2), the page gets "destroyed". There are ways of passing through parameters to a new page and even shoving data into a session variable (applicable only to the logged-in user), but I can think of no feasible way in which you can access a "page" like a spreadsheet in a workbook.
To be honest, I don't even think Microsoft will be able to give you a feasible answer to your problem. Quite frankly, I think you might even embarrass yourself by stating your problem to them. They would, like Raithlin, just suggest the use of a SQL database and to perform queries against the data in the database. It seems to me that what you are trying to do is to use your Excel spreadsheets as a sort of pseudo-database for data storage purposes. You can build a much more sophisticated application, with better user interaction by applying proven web technologies.