Solved

Making a html page interface with an excell spreadsheet

Posted on 2004-09-14
8
170 Views
Last Modified: 2010-04-06
Is there a way to make a webpage show the contence of an .XLS spreadsheet and allow
you to edit parts of it with 'forms' ?

0
Comment
Question by:joncolby
8 Comments
 
LVL 53

Expert Comment

by:COBOLdinosaur
ID: 12060355
If you put a link to a spreadsheet on a page ad the browser recognizes the extension, it will open excell in browser space.  If it does not recognize teh file time or excell in not installed as a browser helper app, it will open a dialog to ask the user if they want to download it.

Cd&
0
 

Author Comment

by:joncolby
ID: 12060579
can people edit it and save the changes ?
would it work with both MS OFFICE and OPENOFFICE ?
0
 

Expert Comment

by:madhumn
ID: 12063422
Could you please clarify whether you are working on ASP. in that case i can provide a solution to do  so , the page would be opened in an Excel like enviroment on the Web Page , the page would work exactly like Excel where users can edit , add functions etc..
0
 
LVL 6

Accepted Solution

by:
sathishv earned 500 total points
ID: 12064463
Following object tag will embed a spreadsheet in a HTML page:

<object classid="CLSID:0002E510-0000-0000-C000-000000000046">
       <param name="DisplayTitleBar" value="false"></object>

You can get more info in the following page:

http://www.prabhums.org/knowledgebase/page/Microsoft%20Technology/Internet%20Explorer/embed_excel.htm

Cheers,
Sathish
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Expert Comment

by:madhumn
ID: 12066480
Theres the answer mate!
Satish u took away my points  ........ sob !
0
 

Author Comment

by:joncolby
ID: 12068350
What is asp and how do I use it ?
i have windows 2000 server.
Running IIS
0
 

Expert Comment

by:madhumn
ID: 12072637
Hi
ASP stands for Active Server pages . Now I realize you are talking about a  static HTMl Page to show Excel Sheet.
To learn more about it step by step pls visit www.w3schools.com and choose ASP.
Or take the example of satish and paste into a HTMl page under the Head Tag , should work.
Rgds
Madhu
0
 
LVL 4

Expert Comment

by:Michael Krumpe
ID: 12097301
joncolby,

If you havent used asp before, (but know that you will need to use it to some extent) I would suggest using AspGrid at http://www.aspgrid.com/
I've used it myself and it has all the edit and update features you are looking for. You can use the examples with your Excel file and you should be plug and go. You will see that its very extendable for you to play with and make nicer as you go, but it will also get you up and going very quickly.

Keep it simple.

Michael
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

There are two main kinds of selectors in CSS: One is base selector like h1, h2, body, table or any existing HTML tags.  For instance, the following rule sets all paragraphs (<p> elements) to red: (CODE) CSS also allows us to define our own custom …
Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now