How To Link to a Sheet, or Named Area, of an Excel File in HTML

MORE INFORMATION

<HTML>
<HEAD>
<Title>Excel Linking Example</Title>
</HEAD>
<body>
<p>
<a href="http://localhost/excel/asheet.xls#Sheet2!D4">
This link will open the Excel file to the second page with the focus on
cell D4</a>.
<a href="http://localhost/excel/asheet.xls#TableName">
This link will set the focus on a named area of the spreadsheet
</a>.
</p>
<form>
<input type=button
 value="Via Jscript"
 onclick='location.href = "asheet.xls#TableName"'>
</form>
</body>
</html>
				

Notes

• The names linked to are not case-sensitive.
• If the link is specified with a file:// type URL, there will be an error. In this circumstance, the whole link is treated like the file name.
• A fully qualified URL is not necessary; that is, you can use href="linkpage2.xls#TableName" as long as the browser, or frameset was loaded using http:// rather than file://.
• In a frameset scenario, you can link to different parts of the Excel file, from the other frame, without causing a reload. This is interesting because normal security does not allow you to directly access the Excel object in the browser.
• Although you can link to an Excel 95 file, you cannot navigate through it in this method.
• When you reference a sheet name that includes a space, you must enclose the sheet name in single quotation marks (for example, <a href="/?scid=asheet.xls%23'sheet+two'!d4">). If you do not do this, you may receive the following error message when you click the hyperlink in the Web page:
  Reference is not valid