Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Imbedding an editable excel file

Status
Not open for further replies.

jonlake

MIS
Sep 17, 2003
76
US
I'm looking to embed an editable excel file into a webpage. This file has multiple worksheets within it. I have seen "Excel Anywhere" but I would like to be able to do this without having to purchase any additional software. Can someone point me in the right direction? I am fairly new to web page design (have a strong background in Networks though) so I have a good understanding on how technology/the web works. Thanks

Jon
 
Well...

If you are using IE and you are using Windows, then you can put an Excel spreadsheet (complete with as many worksheets as you like) directly onto the page for free. You may have to spend some time asking about configuring your browser too (I'm not really that up to speed with Windows).

The result is fully editable too.

Code:
<html>
<head><title>Sample</title></head>
<body>
<iframe src=&quot;mypath/myexcelfile.xls&quot; width=&quot;800&quot; height=&quot;500&quot;></iframe>
</body>
</html>

Here's hoping this helps!
Jeff
 
Ok thank you. Now, I may have stupid question #2. Is there a way I can save it. What I'm doing is putting my budget on there (I'll secure it down, but anyways) and would like to be able to update it as well.
 
You will be able to save it as well as edit it.

Give it a go! Take that code I pasted last post, put a real path to an excel file in there and confirm for your own sanity.

Cheers,
Jeff
 
Ok, I see I can save the file to any drives that I am connected to, but, how can I save it over the original copy (update would be a better word), so it always has the correct info, rather than having a copy on my work pc, and having a copy on my home pc etc. Again, sorry for my ignorance on this matter.

Jon
 
Would it not be easier to try this out yourself?

You have already answered your own question (in a way): I see I can save the file to any drives that I am connected to.

So if you are connected to the drive that hosts the excel file, then you will be able to save it (over the original therefore ensuring you have the most up to date version online at all times).

If you don't have that drive mounted, then you will not be able to save over the original. The only way around that is to look at a server-side solution (which will end up costing you money I'm afraid).

Jeff
 
Ok,

Thanks for your help. I will see what I can do from here. I'll probably set up a VPN connection so I can map drives.

Jon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top