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!

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

Constantly updated Excel worksheet to open in a browser frame

Status
Not open for further replies.
Intelsuit

Intelsuit

MIS
Dec 11, 2001
9
US
I am very new to Java Scripting and I am creating a web page with frames that will display the contents of an excel worksheet in the main frame.
The code below represents the left frame. The right frame is supposed to display the corresponding worksheet only, however it opens the entire workbook.

How can I limit the main frame's display to just the corresponding worksheet?
I know that it has to do with the way the link is setup but I am not sure how to correctly modify it.

Any help is GREATLY Appreciated!!!

<html>

<head>
<meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=windows-1252&quot;>
<meta name=&quot;GENERATOR&quot; content=&quot;Microsoft FrontPage 5.0&quot;>
<meta name=&quot;ProgId&quot; content=&quot;FrontPage.Editor.Document&quot;>
<title>State Listing</title>
<style fprolloverstyle>A:hover {text-decoration: none; color: #FFFFFF; font-style: italic; font-weight: bold}
</style>
<base target=&quot;main&quot;>

</head>

<body style=&quot;text-decoration: none&quot;>
<p>&nbsp;<a style=&quot;text-decoration: none&quot; href=&quot;Allstates.htm&quot;>All States</a><br>
&nbsp;<a target=&quot;main&quot; style=&quot;text-decoration: none&quot; title=&quot;Installers in Alabama&quot; href=&quot;file://server/vol1/group/everyone/FIELD%20Installers%202000RO.XLS#AL!A1&quot;>Alabama</a><br>
&nbsp;<a target=&quot;main&quot; style=&quot;text-decoration: none&quot; title=&quot;Installers in Alaska&quot; href=&quot;file://server/vol1/group/everyone/FIELD%20Installers%202000RO.XLS#AK!A1&quot;>Alaska</a><br>
&nbsp;<a target=&quot;main&quot; style=&quot;text-decoration: none&quot; title=&quot;Installers in Arizona&quot; href=&quot;file://server/vol1/group/everyone/FIELD%20Installers%202000RO.XLS#AZ!A1&quot;>Arizona</a><br>
&nbsp;<a target=&quot;main&quot; style=&quot;text-decoration: none&quot; title=&quot;Installers in Arkansas&quot; href=&quot;file://server/vol1/group/everyone/FIELD%20Installers%202000RO.XLS#AR!A1&quot;>Arkansas</a><br>


</body>

</html>
 
Sort by date Sort by votes
Well, unfortunately I cannot do that. The user that updates the excel workbook is already upset that he now has several worksheets to deal with.
He used to have it all on one worksheet but the information was confusing to deal with and not easily sorted. I changed it to individual worksheets to create some order and to be able to easily reference the data.
Any other ideas?
 
Upvote 0 Downvote
Is the user supposed to be able to edit the data?

I would write a perl script that would display the excel sheet in a regular html table... this would give you a lot more control over the layout (such as which sheets are displayed). You could even create an online editing system using this method if you wanted to. -gerrygerry
Go To
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jomat
  • Locked
  • Question
JS to show the timer in html under title instead of in the status bar
Replies
2
Views
332
xwb
xwb
Kennelbloke
  • Locked
  • Question
Can't Get Markers to show on Map
Replies
0
Views
359
Kennelbloke
Kennelbloke
Mike Lewis
  • Locked
  • Question
Anyone here got any experience of Grid.JS (a sortable Javascript grid) 1
Replies
5
Views
684
Mike Lewis
Mike Lewis
lexer
  • Locked
  • Question
Passing fields from (html-JavaScript) table to JavaScript Function
Replies
0
Views
295
lexer
lexer
penguinspeaks
  • Locked
  • Question
JS Open print dialog page to print a file
Replies
0
Views
143
penguinspeaks
penguinspeaks

Part and Inventory Search

Sponsor

Back
Top