Javascript Spreadsheet
Dec 11, 2006
I've taken a look around the net, and I've noticed some spreadsheet scripts out there written in javascript/html, and I've noticed they mostly seem to lack some functionality/formulas.
So I've been playing around with creating my own spreadsheet, and so far I have something approximating a spreadsheet in Firefox.
I have a couple of issues with making cross-browser, as I clearly do not understand the problems with the Opera and IE browsers.
Current issues:
1. IE apparently only recognizes every 2nd column/row when entering data, but will quite happily allow the user to scroll around the page with the mouse-wheel and the arrow keys.
2. Every time the user switches cells, what is happening in the background is that the innerHTML of the cell is being recorded, then copied into a textfield for editting, which is then swapped for the old innerHTML. However in IE (and occasionally in Opera) what happens sometimes is that I get a double event firing or something weird like that, and I end up with an text field with its OWN innerHTML inside itself (gotta like that self-referencing stuff).
3. Who knows what else is wrong with the formulas in IE since I can't get past issue #1.
4. Opera apparently doesn't recognize the mouse-wheel event at all, and only fires the onkeydown event once (even if you hold down the key on your keyboard). Also, Opera also occasionally likes to swap the innerHTML for itself as with issue #2 above.
View 6 Replies
ADVERTISEMENT
Sep 5, 2009
I need a javascript function to save a html table in my web page to excel work sheet on click of a button.
View 2 Replies
View Related
Mar 24, 2010
For a project in my high school web design class, I need to integrate an Excel spreadsheet as data so to speak for a web page. I want to pull the prices from the sheet, and make them appear on the page. I'd like to pull it from the sheet so that the client can still adjust and edit the prices without having to reach the actual webpage. Conceptually, I thought this would be fairly straight forward, but in researching how to do this, I got very confused. I'm not even positive that I'm putting this in the right section.
So my main question is this: Is there a way to integrate an Excel spreadsheet in such a way that it can provide data for certain fields of a webpage? If so, can someone please explain how?
View 2 Replies
View Related
Nov 2, 2010
I am new to jquery and JavaScript in general and I want to access data in Google Spreadsheet. So at first I published a spreadsheet to be able to retrieve a JSON feed like mentioned here: Simple example of retrieving JSON feeds from Spreadsheets Data APINow I can get a JSON-File - the specific file is this: My Google Spreadsheet JSON
But I was not able to display any data as of now. My code looks like this:
<!DOCTYPE html>
<html><head>
<title>the title</title>
<script src="[URL]" type="text/javascript"></script>
<script type="text/javascript">
jQuery(document).ready(function() {
jQuery.noConflict(); // probably I need this because in the JSON-feed there are $t-objects
jQuery.getJSON("[URL]", function listEntries(json) {
var content = document.createTextNode(json.feed.entry[2].title.$t);
jQuery("p.inhalt").append(content);
});});
</script></head><body>
<p class="inhalt"></p>
</body></html>
So if this looks like noob-code - it is. How the code should look like if a wanted to access the data in the spreadsheet?
View 1 Replies
View Related
Oct 17, 2011
I have text area that includes the full path for a local file on our company network. The files are usually excel sheets or docs. How can I have it so when they clicks the file it opens the local file?
View 4 Replies
View Related
Dec 21, 2009
I'm currently in the process of making a spreadsheet like webpage and it all working fine... However I have been using setAttribute and removeAttribute in order to dynamically change a table cells onclick property.
This of course does not work in IE7 etc and I've been banging my head against a brick wall trying to come up with a solution that will work in all browsers but I just can't seem to get it to work with using methods such as...
I get all sorts of not implemented, type mismatch errors when I try to use the above.
Below is the setAttribute code which works.
View 6 Replies
View Related
Oct 6, 2011
I am looking for a free web based spreadsheet written in Javascript / Ajax.
is this can be found ..
View 3 Replies
View Related
May 29, 2009
I'm trying to create a spreadsheet style form, where the column headers are set, but the number of editable data rows vary. The idea I have is to create a table and make its table cells editable via contentEditable='true', and use javascript to add more rows when a user clicks a button (id="addRows" -- see below).
Thus far I've put together the html for the static component of the table and I'm putting together the javascript. At this point I have a couple of questions:
1. Is there a better way to accomplish my goal? 2. How can I retrieve the data from the editable cells and group them so when I send the data via ajax, the information can be saved properly - i.e. grouped according to row?
[Code]....
View 7 Replies
View Related
Feb 23, 2011
I'm writing a program that would automate data entry (from an excel spreadsheet) into an online database. I've been doing them one by one for the past couple of weeks...only have about 10,000 left.
View 4 Replies
View Related
Jul 23, 2005
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)
{
picWindow=window.open('','','width=25,height=25,sc rollbars=1,resizable=1');
picWindow.document.writeln('<html> <head>');
picWindow.document.writeln('<SCR' + 'IPT type="text/javascript"
LANGUAGE="JavaScript1.1" SRC="resizewindow.js"></SCR' + 'IPT>');
picWindow.document.writeln('</head>');
picWindow.document.writeln('<body onload="resizewindow();">');
picWindow.document.writeln('<img src=' + pic + '>');
picWindow.document.writeln('</body> </html>');
picWindow.document.close();
}
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.
View 9 Replies
View Related
Jul 23, 2005
Attached is a simple HTML file that adds and delete rows. In the add
row function I set an attribute "onClick" this triggers the
testMessage() function. When I try this in Firefox it works just fine
however on IE it just refuses to work.
What is interseting is the ROW that already exists has a similar
'onClick' event which works when the page is loaded, but subsequent
"row" additions to the table to not work in IE. Code:
View 9 Replies
View Related
Feb 19, 2007
two possibilities or the attribute type of script:
text/javascript (the one i usually use) application/x-javascript
what are the differencies between both?
depends on the html content?
for example html 4.0.1 versus xhtml 1.1?
View 12 Replies
View Related
May 25, 2005
I'm getting errors in Firefox everytime I try to run this frame resize code, but it works fine in IE. I can't seem to figure out what the problem is with it.
The error is: Error: theFrame has no properties
Line: 8
The line that the javascript console is showing an error for is in italics.
code from page:
<html>
<head>
<script type="text/javascript">
var defaultCols="100px,*";
var hiddenCols="0px,*";
function ShowHideMenu(){
theFrame = document.getElementById("framed");
if(theFrame.cols == defaultCols) theFrame.cols=hiddenCols;
else theFrame.cols=defaultCols;
}
</script>
<frameset cols="100px,*" name="framed">
<frame src="lframe.htm" name="frameMenu">
<frame src="mframe.htm" name="content">
</frameset>
</head>
<body>
</body></html>
Come someone let me know what I'm doing wrong here?
View 2 Replies
View Related
Mar 30, 2006
I'm already past the basics of Javascript, and i need something that takes me to the other level and teaches me the new technologies and cool stuff (drag&drop, AJAX, OOP in javascript, maybe XUL...etc). So far i found these two books:
1. Sitepoint's "The JavaScript Anthology: 101 Essential Tips, Tricks & Hacks".
2. Worx's "Professional JavaScript for Web Developers (Wrox Professional Guides)"
Both seems to cover very insteresting topics, but i can only buy one of them. So which one do you suggest?
and by the way, i've read the sample chapter 5 of Sitepoint's book, and it seems like the author(s) just put the solutions/codes there and let you figure them out on your own. Is this how the rest of the chapters are?
View 3 Replies
View Related
Jul 23, 2005
This is a question about defensive web browsing. Ocassionally I run into a page whose JavaScript does something that I find obnoxious. I would like to turn off JavaScript only for that page (instead of disabling it globally). It would be cool if there were some way to do this through a "bookmarkable" JavaScript snippet using the javascript: pseudoprotocol. Does anyone know any trick to do any of this?
View 2 Replies
View Related
May 26, 2006
I am looking for a method to extract the links embedded within the
Javascript in a web page: an ActiveX component, or example code in
C++/Pascal/etc. I am looking for a general solution, not one tailored
to a particular page/script.
Hopefully, the problem can be solved without recreating a complete
Javascript interpreter. Any ideas?
View 9 Replies
View Related
Oct 21, 2005
I have some javascript that I have written into the <body> section and it works great. But I would like to make it into a javascript function and define the function in the <head> section. Then in the <body> section write a small bit of javascript that would call the function() object. Code:
View 2 Replies
View Related
Jan 7, 2006
I would like to know how to write javascript such that, a part of it isnt considered as script, & rather as HTML. Code:
Ok, the layer div can be written using document.write. But, Google ad itself is a javascript isnt it. How can it be written into this? How does this work?
View 3 Replies
View Related
Apr 28, 2006
Ok so, this is my purpose:
- to be able to load asynchronously (via AJAX) some javascript ads (like google's or adbrite) so as to make them be loaded in the background, then update the page after the ads have loaded via innerHTML
Why?
-Because 90% of the time in my newer sites, javascript ads are the major offender in terms of speed of page rendering
My problem:
Via ajax, I can call a php file that retrieves some javascript and outputs it, XMLhttprequest returns those javascript lines, but they don't render in the page, since they miss the whole page loading, and are apparently not parsed
For example, let's say I call a php file via ajax, and it returns the output into a variable named "text" containing "document.write('hello')"
if I use xxx.innerHTML=text, nothing happens
My 1st solution:
Passing those javascript lines to eval() [like eval(text) ], but this produces a second problem, that I couldn't solve (probably because of my lack of knowledge in javascipt):
if I eval the code, it deletes my current page and renders a new one
for example, if I parse a document.write, my page disappears, and a new one is rendered with the document.write text
What I want is basically to make that "document.write" appear inside a div in my page, adding to the content (and not overwriting the whole page), much like what happens when using innerHTML
Is this even possible? How would you go about it?
I tried xxx.innerHTML=eval(outputfromphpfile) but it overwrites my whole page...
View 3 Replies
View Related
Nov 26, 2000
Just a quickie: is it possible to place javascript within javascript? The following is the code I am using to create a pop-up for a picture gallery. I would like to place a banner from a banner exchange in bold under each photo. When I use the code below I get an error message:
<SCRIPT language=JavaScript>
<!--
function openpic(pic_name) {
myWin= open("", "displayWindow", "width=640,height=510,status=no,toolbar=no,
menubar=no,scrollbars=yes,resizable=yes,alwaysraised=yes");
myWin.document.open();
myWin.document.write("<html><head><title>" + pic_name + "</title>");
myWin.document.write("</head><BODY><center><TABLE CELLPADDING=Ɔ' CELLSPACING=Ɔ' WIDTH=òr'>");
myWin.document.write("<br><img src=kate/image"+ pic_name + ".jpg><br>");
myWin.document.write("<br><br><BR><br><BR><br><BR>");
myWin.document.write("<script language='javascript' type='text/javascript' src='http://www.linkbuddies.com/ad.go?id=134039+2&n=3'></script>");
myWin.document.write("</center></body></html>");
myWin.document.close();
}
//-->
</SCRIPT>
View 16 Replies
View Related
Dec 12, 2005
Basically, on one of my sites I'm running adsense and today I added Chitika. The problem is, I can't run those type of ads through my banner advertising program.
The banner advertising program calls the banners/HTML from code like this:
<script language=JavaScript src=http://www.mysite.com/advertise/abm.asp?z=1></script>
And using that program I'm able to either choose a banner or HTML I want to display when that code above is used. It displays HTML ok... but when I try to run an ad of either adsense or chitika nothing displays on the page. The code that would be called is:
<script type="text/javascript"><!--
*Chicika code in here*
//--></script>
<script src="http://xxx/xxx/mm.js" type="text/javascript">
</script>
So... it looks like I can't have javascript call another javascript to display on a page. My question is then... how can I edit the above to make it work or how can I work around this problem? I'd really want this to work with Chitika and not so much with adsense... but it appears both Chitika and Adsense use similar javascript code.
View 9 Replies
View Related
Jul 26, 2006
is it possible to use functions from javascript file A.js in javascript file B.js?
View 5 Replies
View Related
Jul 23, 2005
How can I pull this ASP var into javascript?
What is wrong with this statement?
<%
todaysdate = (now)
response.write (todaysdate)
%>
<script language="JavaScript"><!--
var date = new Date();
var aspdate = <%=todaysdate %>
document.write(aspdate);
//--></script>
View 4 Replies
View Related
Jul 23, 2005
does a client side script always need a server side script in order to
function?
how can i get my javascript application to send the details of a user
filled form to me without having to have a server side script?
if i have both server side and client side script in a web
application, will the resulting application run as a client or server?
i know i probably haven't made much sense, but the problem is that i'm
trying to make sense of it all.
View 3 Replies
View Related
Jul 23, 2005
I'm looking for javascript IDE with code completition and preferably script debuging. Cross platform (Windows, Linux) would be a plus.
View 1 Replies
View Related
Jul 23, 2005
I have javascript function in my jsp page. Function does following :
text1 += '<xupdate:insert-before></xupdate:insert-before>;
but i get exception that <jsp:root> expected . Slash is a problem. I try
change it to > but it does nothing. Is there other solution??
View 1 Replies
View Related
