| iFrames and web pages | Plain version of this page | An Excel table as a Javascript | |
This website does not contain a Javascript tutorial. The following details however may provide some clues as to how some simple script instructions can be used.
The aim of this project is to find a means of displaying a few variables from an external file on a web page. The external file could easily be generated by a visual basic program in Excel or Access. The web page might be a status report showing the progress of several different processes, or it may contain some summary variables for a user without access to the original office files.
B | C | D | |
12 | Agency recharges | c:\magic_file.csv | 28 Mar |
A first script reads an external (text) file called 'jbank1.js'. The file only contains four variables 'proc_b', 'result_b', 'date_b' and 'datenarr_b' and makes them available for use within the web page.
Contents of External js file | Script within this page to call the file | ||
var proc_b="Agency recharges"; var result_b="c:\magic file.csv"; var date_b=new Date("03/28/2013"); var datenarr_b="28 Mar"; |
<script src="jbank1.js"></script> |
The second script reads the first two variables from the external file and passes them directly to a paragraph which contains an ID label (bank_cm)...
Paragraphs displayed in a page | Script within the current page | ||
The most recent file to be processed was: A paragraph to be substituted For further information please contact the system administrator. |
<script> // in the paragraph left (ID: bank_cm), the original text will be replaced by the following statement document.getElementById("bank_cm").innerHTML="Description: " + proc_b + ", Filename: " + result_b; </script> |
The third script calculates the difference between todays date and the (external) 'date_b' variable. The result of the calculation determines the red or green background colouring of the paragraph (ID = 'bank_p') ...
Paragraphs displayed in a page | Script within the current page | ||
The data was last refreshed on: A paragraph to be substituted Ensure that this data is updated regularly in order to ... |
<script> var today= new Date(); today.setHours(0, 0, 0, 0); var procdate=date_b; var daysdiff=Math.floor((today.getTime()/86400000)-(procdate.getTime()/86400000)+1); if (daysdiff<24) { document.getElementById("bank_p").innerHTML="Date: <span style='background-color: #7BFF7B'>" + datenarr_b + " (" + daysdiff + " days)</span>"; } else { document.getElementById("bank_p").innerHTML="Date: <span style='background-color: #F98C84'>" + datenarr_b + " (" + daysdiff + " days)</span>"; } </script> |
Note that the javascript Date functions are case sensitive and must be typed correctly. Also, a date variable should be entered in the format MM/DD/YYYY.
A simpler version of this page and it's javascripts can be opened here. Use the browser option to View Source code of that page.
A page containing useful information about javascripts and dates is http://msdn.microsoft.com/en-us/library/ie/ee532932(v=vs.94).aspx
file: Java_Vars_MiK.htm | Page last updated: Feb14 | ![]() |
© MeadInKent.co.uk 2014 | CMIDX S5 P12 N |