Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

Link to an Excel Worksheet ???

Hi,
 
I'm building a web page and would like to set up a link to an Excel spreadsheet. However, I'd like the link to point to a SPECIFIC worksheet inside the Excel workbook. Example; Test.xls (sheet 5). What code can I use to accomplish this ? I'm currently using the following HTML: HREF="C:\HTML DESIGN\Test.xls">
 
Any ideas would be greatly appreciated.
 
Thanks,
Paul
 
0
PaulBukowski
Asked:
PaulBukowski
1 Solution
 
egbservicesCommented:
No comment, no answer... I am just interested in the outcome. EdiI
0
 
coopaCommented:
I believe if you save the excel document whilst viewing worksheet 5, then the page will open that worksheet by default.... I'm going to check now...
0
 
coopaCommented:
Just tested it.... it seems to work  

8o)
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
rupertsCommented:
(EdiI - if you just want to keep up to date with the question, select comment and the just press submit! You don't need to actually add any comments.)
0
 
rupertsCommented:
(EdiI - if you just want to keep up to date with the question, select comment and the just press submit! You don't need to actually add any comments.)
0
 
cybernieticCommented:
<a href=file:///C|/HTML DESIGN\Test.xls>Test.xls</a>
I don't think it's possible to open a document at a given sheet
0
 
coopaCommented:
cybernietic, if you read the rest of the post you could have saved all that typing.  

8o)
0
 
HocamCommented:
I think I know the answer:
If you are using MS Excel2000 follow the below steps:

1) Open your Excel (xls) file.
2) Select the WorkSheet you want to put on website.
3) From 'File' menu select 'Save as Web Page..."
4) You will see two Save options. Select 'Selection: Sheet'
5) And save it with a desired name. Just link to this htm page instead of linking to xls file.

I hope this helps...
-Hocam
0
 
scaltonCommented:
Microsoft documentation says:
<A HREF="C:\HTML DESIGN\Test.xls#Sheet5">Sheet 5</HTML>

and then you define that name in a cell on that sheet.

I've never got it to work.

See: http://support.microsoft.com/support/kb/articles/Q197/9/22.ASP 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now