JavaScript - Use Javascript To Create Microsoft Excel Chart

is there a ways in javascript to create graphs chart? i can't seem to find a code on the internet

I run a christian ministry that mentors kids. One aspect of this is tracking their chores. All of the online sticker charts we have used over the yrs have vanished. Currently we are using one that only puts checkmarks in the squares and the kids are bored with it. So I want to create a clickable table that puts an icon in the cells on click. I know a little html and ive designed websites with a visual editor. If someone could please point me in the right direction where I would even begin to learn how to create the script I described it would be greatly appreciated.


In case it is not clear what I would like to create this video shows the most recent site we used.( hopefully including the link is not advertising since the site shown in the video is gone. If it is I apologize) It is no longer up. Hence my wanting to create a similar script that can be added to our church's website. thanks again for any guidance.

a bit of an aside please don't just suggest we use an app. I know there are apps out that do what I described and more but, an online version is preferable because the kids don't live with their mentors. Also some of them only have computer access at the library. so it is unreasonable to expect them to have a smart phone or tablet.





Reply With Quote




01-10-2015, 10:42 PM #2
Old Pedant View Profile View Forum Posts

Supreme Master coder! Join Date Feb 2009 Posts 28,311 Thanks 82 Thanked 4,754 Times in 4,716 Posts

Well, just to start with, you are going to need "baqkend" code. That is, you will need a database where all the information can be recorded and server-side code to maintain and access that information. The most likely candidate for this would be a MySQL database and PHP code to interface to it and to produce the web pages.

You really have no choice but to do it this way: If the child used the exact same computer *AND* had an account on that computer, then you could do it by saving the information on that computer. But with a library-based computer, (a) accounts are anonymous, not assigned [typically] and (b) the child may not be able to use the exact same computer on subsequent days.

By doing the bulk of the work on a server, you ensure that any computer (or pad or phone) can access the same information and present the same interface (or perhaps a modified interface for smaller screens).

This is *NOT* a trivial task. Never mind the pretty graphics: Just the code behind the scenes is enough that nobody is going to do it in a few days (or at least is not going to get it right in a few days).

You have to locate a host ($$ per month/year), get a domain name ($$ per year), create a database, create the tables in that database, write the PHP code to modify the database, write the PHP code to access the database, write the PHP code to create the HTML pages, create the icons and other graphics for the pages, and so on.

I am really new to coding and am trying to include a flowchart that I have created on my site. There is a series of 5 questions with 2 possible answers for each question. Can anyone help me with some coding that would let me show only the first question and based on how they answer that, the flow chart would open up to the second question and once they answer the second question, it opens up to the third question and so on?

How do I use Javascript to loop through all the spreadsheets contained in 1 excel file?

I am now at the stage where I can open the Excel file and find a value on 1 spreadsheet.
Is there any way to detect if the workbook has multiple spreadsheets and then loop through all the spreadsheets to find a value?

thanks!

Hi

I am trying to load html stream directly into webbrowser in delphi.
The html contains java script. It loads xml and xsl files and display the xml content in the web browser.

I got an error, says access denied for the command xmlDoc.load(fname);

If I save the html into a file, test.html, and double click it, it is fine, no problem.

The code is actually copied from w3schools.com.

the html code as followed:
<html>
<head>
<script>
function loadXMLDoc(fname){var xmlDoc;
if (window.ActiveXObject)
{
xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
}
else
{
alert('Your browser cannot handle this script');
}
xmlDoc.async=false;
xmlDoc.load(fname);
return(xmlDoc);
}

function displayResult()
{
xml=loadXMLDoc("catalog.xml");
xsl=loadXMLDoc("catalog.xsl");
if (window.ActiveXObject)
{
ex=xml.transformNode(xsl);
document.getElementById("example").innerHTML=ex;
}
}
</script>
</head>
<body id="example" onLoad="displayResult()">
</body>
</html>


The delphi code is

procedure TForm1.WBLoadHTML(WebBrowser: TWebBrowser; HTMLCode: string) ;
var
v: OleVariant;
HTMLDocument: IHTMLDocument2;
begin
memo1.Lines.LoadFromFile('d:\test\htmltxtold.html');
HTMLCode := memo1.Text;

WebBrowser1.Navigate('about:blank') ;
HTMLDocument := WebBrowser.Document as IHTMLDocument2;
v := VarArrayCreate([0, 0], varVariant);
v[0] := HTMLCode;
HTMLDocument.Write(PSafeArray(TVarData(v).VArray));
HTMLDocument.Close;
end;


Thanks a lot