http://www.lambda.ee/w/index.php?action=history&feed=atom&title=Jsdemo_sourceJsdemo source - Redigeerimiste ajalugu2026-10-28T14:12:03ZSelle lehekülje redigeerimiste ajaluguMediaWiki 1.43.11http://www.lambda.ee/w/index.php?title=Jsdemo_source&diff=15490&oldid=prevTammet: Uus lehekülg: '<pre> <!DOCTYPE html> <html> <head> <title>demo</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <!-- read in javascript libraries for parsing csv: htt...'2019-02-14T10:40:39Z<p>Uus lehekülg: '<pre> <!DOCTYPE html> <html> <head> <title>demo</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <!-- read in javascript libraries for parsing csv: htt...'</p>
<p><b>Uus lehekülg</b></p><div><pre><br />
<!DOCTYPE html><br />
<html><br />
<head><br />
<title>demo</title><br />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><br />
<!-- read in javascript libraries for parsing csv: https://github.com/okfn/csv.js --><br />
<script src="jquery.js"></script> <br />
<script src="csv.js"></script><br />
</head><br />
<body><br />
<br />
<h1>See on csv faili töötlemise demo</h1><br />
<br />
Tulemus ilmub siia:<br />
<p><br />
<br />
<div id="result"></div><br />
<br />
<p><br />
Andmed võetakse csv failist <a href="data.csv">data.csv</a>.<br />
<p><br />
Programm kasutab <a href="https://github.com/okfn/csv.js">csv.js</a> teeki csv faili parsimiseks ja siis siin<br />
lehe lähtekoodis olev meie oma <tt>processdata</tt> programm, mida saad ise edasi ehitada.<br />
<script><br />
<br />
// processdata takes data rows, builds html string and shows it in the div above<br />
<br />
function processdata(rows) {<br />
<br />
var rownr, colnr, row, el;<br />
var result;<br />
<br />
// build the result html string<br />
result="<table>";<br />
// loop over all rows<br />
for(rownr=0; rownr<rows.length; rownr++) { <br />
row=rows[rownr];<br />
result=result+"\n<tr>";<br />
// loop over columns in one row<br />
for(colnr=0; colnr<row.length; colnr++) {<br />
el=row[colnr];<br />
result=result+"<td>"+el+"</td>";<br />
}<br />
result=result+"</tr>";<br />
}<br />
// put the result html string into the div on the page<br />
console.log(result);<br />
document.getElementById("result").innerHTML=result; <br />
}<br />
<br />
// take raw csv data, parse it into rows and then call processdata with the result<br />
// we use the CSV library from https://github.com/okfn/csv.js <br />
<br />
CSV.fetch({<br />
// several options to give input, by default we use the file data.csv<br />
url: 'data.csv'<br />
<br />
// alternatively put raw data here like this:<br />
//data: "esimene,teine\na,1\nb,2"<br />
<br />
// also an alternative<br />
//file: an HTML 5 file object<br />
<br />
// optional options about structure of the CSV file<br />
// following the CSV Dialect Description Format <br />
// https://frictionlessdata.io/specs/csv-dialect/<br />
/*<br />
dialect: {<br />
...<br />
}<br />
*/<br />
}<br />
).done(function(dataset) { <br />
// console.log(dataset); // optional debugging <br />
var allrows;<br />
// put the dataset field list and dataset records into one array of all rows<br />
allrows=dataset.records;<br />
allrows.unshift(dataset.fields); <br />
// call our program for building html<br />
processdata(allrows);<br />
});<br />
</script><br />
<br />
</body><br />
</html> <br />
</pre></div>Tammet