Loading Dynamic Text on a scrollbar

[maddyyikes]

Hi,
I have the following problem with the code, obtained from Dynamic Drive, as shown below. The code works fine for displaying static text. However I want to know whether the code can be modified to include dynamic text (data contained in an excel spreadsheet and updated periodically in particular)within the scrollbar. This is highly urgent and any help in this regard will be greatly appreciated. Thanks in advance! The code is given below as shown:

<script type="text/javascript">

/******************************************
* Scrollable content script II- © Dynamic Drive (

http://www.dynamicdrive.com)

* Visit

http://www.dynamicdrive.com/

for full source code
* This notice must stay intact for use
******************************************/

iens6=document.all||document.getElementById
ns4=document.layers

//specify speed of scroll (greater=faster)
var speed=5

if (iens6){
document.write('<div id="container" style="position:relative;width:175px;height:160px;border:1px solid black;overflow:hidden">')
document.write('<div id="content" style="position:absolute;width:170px;left:0;top:0">')
}
</script>

<ilayer name="nscontainer" width=175 height=160 clip="0,0,175,160">
<layer name="nscontent" width=175 height=160 visibility=hidden>

<!--INSERT CONTENT HERE-->
<p><font size="2" face="Arial">-</font><font size="2" face="Arial"> DHTML is the
combination of HTML, JavaScript, and CSS</font></p>
<p><font size="2" face="Arial">- DOM stands for Document Object Model</font></p>
<p><font size="2" face="Arial">-</font><font size="2" face="Arial"> DHTML allows
content on a page to change on the fly, without reloading the page</font></p>
<p><font size="2" face="Arial">- CSS allows for the separation between content
definition and formatting</font></p>
<p><font size="2" face="Arial">- CSS stands for Cascading style sheet</font></p>
<p><font size="2" face="Arial">- </font><font size="2" face="Arial"><a href="

http://www.dynamicdrive.com">Dynamic

Drive</a> provides free, cut and paste DHTML scripts</font></p>
<!--END CONTENT-->

</layer>
</ilayer>

<script language="JavaScript1.2">
if (iens6)
document.write('</div></div>')
</script>

<table width="175px"><td><p align="right">
<a href="#" onMouseover="moveup()" onMouseout="clearTimeout(moveupvar)"><img src="up.gif" border=0></a> <a href="#" onMouseover="movedown()" onMouseout="clearTimeout(movedownvar)"><img src="down.gif" border=0></a></p></td>
</table>

<script language="JavaScript1.2">
if (iens6){
var crossobj=document.getElementById? document.getElementById("content") : document.all.content
var contentheight=crossobj.offsetHeight
}
else if (ns4){
var crossobj=document.nscontainer.document.nscontent
var contentheight=crossobj.clip.height
}

function movedown(){
if (iens6&&parseInt(crossobj.style.top)>=(contentheight*(-1)+100))
crossobj.style.top=parseInt(crossobj.style.top)-speed+"px"
else if (ns4&&crossobj.top>=(contentheight*(-1)+100))
crossobj.top-=speed
movedownvar=setTimeout("movedown()",20)
}

function moveup(){
if (iens6&&parseInt(crossobj.style.top)<=0)
crossobj.style.top=parseInt(crossobj.style.top)+speed+"px"
else if (ns4&&crossobj.top<=0)
crossobj.top+=speed
moveupvar=setTimeout("moveup()",20)

}

function getcontent_height(){
if (iens6)
contentheight=crossobj.offsetHeight
else if (ns4)
document.nscontainer.document.nscontent.visibility="show"
}
window.onload=getcontent_height
</script>

 

[Kirsle]

Have you found another JavaScript that can get dynamic data from a spreadsheet? If so, try to port that code over for your purposes here. If not, and if JavaScript alone can't handle this, you may need to look into Ajax.

 

[theniteowl]

The content is just HTML formatted text you could use any number of methods to alter what it displays.

You could use an include statement to include the content of an external document or you could use a bit of server-side code to insert the formatted HTML at the correct location in the page at page load.
With an include you could just change the content of the document it points to so that it has new information and with the server-side code you could do it any number of other ways such as inserting HTML directly, inserting a different include statement, pulling data from another source like a database, etc. It all depends on the data, where it comes from, how it changes and what resources you have to work with it. The project in general should be very easy.


Paranoid? ME?? Who wants to know????