Using ADO From JavaScript In HTML To Change A Spread Sheet
Feb 17, 2006
I'm trying to use client side JavaScript from an HTML file to open
and make changes to an Excel SpreadSheet using ADO w/ ODBC. What a
pain it is to do this. Anyways, I am able to open the excel file but I
don't know how to use ADO to work with it's contents. So far I have
the following code that works:
<html>
<script>
window.onload = function () {
var ExcelSheet;
var sConnect = "DRIVER={Microsoft Excel Driver
(*.xls)};DBQ=P:js-test.xls"
ExcelSheet = new ActiveXObject("ADODB.Connection");
ExcelSheet.Open(sConnect);
}
</script>
<body> =) </body>
</html>
Now that I have the sheet open, how do I manipulate it?
I have found a solution for showing an element on page load (it should be hidden if JS is blocked), but the CSS and the JS go into the <head>. I prefer to keep all such code in external files, so how do I adapt it to support that approach? Found code is as follows (if it can be improved on, feel free to say so):
I am trying to implement a script for marking up a block of text into different columns of equal height (see http://www.csscripting.com/js/v1.0be...ulti-column.js for the script in question. I can't seem to get the script to work at all in Firefox or Opera. In IE it works just fine. Some examples of what the script can do can be found here. These examples work in both Firefox and Opera, so I wonder what I'm doing wrong. Here's my code:
I'm trying to implement the datepicker and I have two fields on my form:Birthdate& Lived here since? In my header I have:
[Code]...
When I click on the 1st date field (birthday) it mostly works... I say mostly because it doesn't appear to be pulling in that css as the widget is pretty spread out and has no borders etc. When I click on the 2nd date field (here since?), absolutely nothing happens. Surely this supports multiple date fields on the same form so what am I doing wrong?
.change() is only for form elements minus check boxes/radio buttons, etc.Are any of you aware of a script that does this already? Hopefully one that is easy to implement.I just want to monitor things like height, number of inner elements, or any change in the inner HTML.
I want to change the content of different div's using .html(). The change should be done by clicking on the inner element of the container. The content of the clicked container should be changed with the first container. My problem is, that the following code does the change, but only once. After every div has changed one time, no more reaction is shown.
I'm working on some code and am running into brick walls. I'm trying to write out Javascript with Javascript and I've read the clj Meta FAQ and didn't see the answer, read many similar posts (with no luck though), and searched through the IRT.ORG Faqs (www.irt.org/script/script.htm).
The Javascript is designed to open an popup window and then inside that window call another script which will resize that window. There may be another way around this but the reason I tried this approach initially was that I wanted to call the onload handler in the popup window to resize the image only after the image had completely loaded. I've had some code in the primary Javascript file (showimage.js) before that works if the image has been cached but on the first load, it doesn't resize properly which tells me it is probably because it is trying to resize the window based on the image size but it isn't completely known at that point. So I removed that code and tried placing the resizing code in the second Javascript file (resizewindow.js). BTW I've tried other code to open a popup image and automatically size it ie Q1443 at irt.org but that doesn't do exactly what we need.
Even if there is another way to do this with one file, I still want to figure out why this isn't working in case I run into it in the future.
I thought what I would need to do to use document.writeln to write Javascript would be to escape any special characters and to break apart the script tag ie
document.writeln('</SCRIPT>');
would become
document.writeln('</SCR' + 'IPT>');
I have a HTML page and 2 Javascript files. All files are in the same directory and have permissions set correctly.
Here are the 3 files (keep in mind wordwrap has jacked up the formatting):
index.html ---------- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Test</title> <SCRIPT type="text/javascript" LANGUAGE="JavaScript1.1" SRC="showimage.js"> </SCRIPT> </head>
<body> Click the house<BR> <A ONCLICK="newWindow1('house1.jpg','Nice House')"><IMG SRC="house1thumb.jpg"></A> </body> </html>
showimage.js ------------ function newWindow1(pic,sitename) {
resizewindow.js --------------- function resizewindow() { // Do resizing here. // Right now this isn't being executed alert("resizing window"); }
Can anyone provide some pointers as to why this javascript is failing? I'm using IE6 on Win2k and when I click on the image to open the popup window, it does open the window but it is white with no content and the system immediately goes from about 4% CPU usage to 100% and consistently stays there until I kill that window with the task manager.
When I use document.getElementsByTagName('style')[0].sheet in Firefox or Opera, it returns the CSSStyleSheet object. However, IE6 returns nothing. So I was wondering if there's a property in IE that works the same as the .sheet property.
var stylesheet = document.getElementsByTagName('style')[0].sheet; alert(stylesheet.cssRules.length); // 34
Everything is positioned as I want it, but I want to read out the position of the div (to position something else), but getElementById somehow doesn't work. It all worked well, when the css was directly in the page, but it won't if it's in an external file.Basically I do something like this:
function move(where){ var ids = "i" + where; var newtop = document.getElementById(ids).style.left;[code].....
I'm writing a reusable JavaScript library which needs to set certain styles in a document. The document may have an existing stylesheet definition either by a link or by an existing stylesheet declaration in the documents head section.
How can I use JavaScript to append my own style sheet information to a possibly already existing stylesheet definition?
I'm new to JavaScript, I just finished some basic things, like getAttribute, setAttribute, getElementByID etc. I understand that inline javascript isn't the best way to go, and all the JavaScript should go on an external JS file. I also know that you should be able to downgrade gracefully, allowing people whose browser do not/blocked javascript to still use the site. So I just want to do a simple go back function in an external javascript, however it's not exactly working.
Is it possible to do something like this: On a site there is a link that says "Darken Page".Upon clicking the link, the background color turns black.The link then changes to "Brighten things up"So just a style sheet switcher, but with one link and changes
how can i use javascript to detect the current date to select css style sheet so that the color style of the site is different every day like wired dot c0m?
I have a script that works perfectly on a live site that basically has a menu that reveals a hidden DIV and when you click a link, and then when you click a new link it hides the previous div and reaveals the new one. It is as follows:
Javascript Code: Original - javascript Code LastLayer = "nothing"; // the first div/layer function openObject(theLayer){ // pass the name of the layer you want to bring to the top // Then hide the last layer, and make the layer passed visible. This could have been done using the z-index property if (document.getElementById) { // if it's IE5 or NS6 use this syntax to access the visiblity attribute eval("document.getElementById(LastLayer).style.visibility = 'hidden'") eval("document.getElementById(theLayer).style.visibility = 'visible'") LastLayer = theLayer; } if(document.layers) { // if it's NS4 use this syntax to access the visiblity attribute eval('document.layers[LastLayer].visibility = "hidden"') eval('document.layers[theLayer].visibility = "visible"') LastLayer = theLayer; } .....
Now I am redesigning the site to work with a new style sheet, (There wasn't one before, it was all inline styles. Anyway, it broke my script. The CSS has a class that gives certain DIV's visibility attribute the 'hidden' value by default. I was planning on using the above script to reveal/hide them, but it does nothing. Here is the CSS that affects the divs I am referring to.
CSS Code: Original - css Code .job { border: thin solid #000000; float: right; margin-right: 25px; padding-left: 10px; width: 40%; display: none; } .job { border: thin solid #000000; float: right; margin-right: 25px; padding-left: 10px; width: 40%; display: none;} As you can see there is nothing fancy in the css that would cause any concern.
I have made a simple program for calculation and i have 4 textboxes in it now i want to send this info to an excel sheet,, I tried doing through a html table but i am not able to make dynamic table which can take values through variables.... I am using javascript.
I would like to create a function that will change the colour of a button when clicked then change it back at the end of the function. It works by capturing the backgroun color an then storing it as a variable. However it refuses to capture the original background color if the style is set via an external CSS style sheet. It only works if i set the style via the element markup. Am i doing something wrong and is there any way of capturing the style set by a external stylesheet?
I run a website for a skittle league and am looking to create a form to allow teams to sumbit results on line. I'm not an expert on Javascript, the code I've created so far allows the user to enter the player name and score for one team and calcutate the total. However, I'm having problems duplicating this for a second team, and would like to remove the Get Total button (i.e. Auto Calculate total).
The Code I have so far is <html> <head> <script type="text/javascript" language="javascript"> function getTotalH1(oForm){ var field, i = 0, total = 0, els = oForm.elements; var fieldnames = ['PSH1' , 'PSH2' , 'PSH3' , 'PSH4' , 'PSH5']; for (i; i < fieldnames.length; ++i){ field = els[fieldnames[i]]; if (field.value != '' && isNaN(field.value)) { alert('Please enter a valid number here.') field.focus(); field.select(); return ''; .....
I'm trying to generate a drop down list using a supplied xml form with an xsl sheet. Because xsl lacks commands that will allow me to create repetitive <options> I am using javascript. A sample xml file that I am using is bellow.
I have a form, EWMS.php, that is a score sheet for a dart league. In this form I first have a user choose a division. Ajax returns that choice via MySQL database and PHP. Upon choosing a division that also fills in the next drop down choices of team, which again calls Ajax and brings in the teams associated with the division choice. All works good so far. The last call on team choice drop down brings in the players on that team in another drop down which is peppered throughout the form as it is based on these players that are chosen. The beginning form tag and ending form tag are located in the EWMS.php file while Ajax loads other input elements from the database into the middle of the form.
So now that the form works with these drop downs grabbing MySQL data, I am testing the data the user input by using action="process.php" method="post" in the form tag. In process.php I have some basic code: $date=$_POST['date']; $week=$_POST['week']; $league=$_POST['league']; //HOME TEAM $teamH=$_POST['teamH']; //VISITING TEAM $teamV=$_POST['teamV']; .....
When a league is chosen it brings in this findleague.php : <?php $league=$_GET['league']; //echo $league; include("sparkplug2.php"); $result = mysql_query("SELECT DISTINCT(team) FROM member_data2011spring WHERE division = '$league' ORDER BY team ASC") or die(mysql_error()); $result2 = mysql_query("SELECT DISTINCT(team) FROM member_data2011spring WHERE division = '$league' ORDER BY team ASC") or die(mysql_error()); ?> .....
I am using the stylesheet switcher on dynamic drive . Is there a way to change stylesheets based on a querystring parameter? Basically, if the query string includes "&StyleSheet=BlueStyle" then call and set the BlueStyle.css and cookie on page load.
