Data Visualization
(
3160717 )
Practical and Source Codes
<!DOCTYPE html>
<html lang="en-IN" dir="ltr">
<head>
<title>Read XML File to Data Table</title>
<meta charset="utf-8">
<meta name="author" content="SidPro" />
<meta name="viewport" content="width=device-width,initial-scale=1.0" />
<meta name="description" content="Data visualization using javaScript and HTML" />
<script src="js/jquery-3.5.1.min.js"></script>
<script src="js/jquery.csv.js"></script>
<style>
#mytable {
font-family: Arial, Helvetica, sans-serif;
border-collapse: collapse;
width: 100%;
}
#mytable td,
#mytable th {
border: 1px solid #ddd;
padding: 8px;
}
#mytable tr:nth-child(even) {
background-color: #f2f2f2;
}
#mytable tr:hover {
background-color: #ddd;
}
#mytable th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: cornflowerblue;
color: white;
}
</style>
</head>
<body>
<h1>Get data from XML file</h1>
<table id="mytable">
<tr>
<th>Territory</th>
<th>Employees</th>
<th>Sales</th>
<th>Year</th>
</tr>
</table>
<script>
$(document).ready(function () {
$.ajax({
type: "GET",
url: "data/regional_sales.xml",
dataType: "xml",
success: xmlParser
});
});
function xmlParser(xml) {
$(xml).find('region').each(function () {
var theTerritory = $(this).find('territory').text();
var numEmployees = $(this).find('employees').text();
var theAmount = $(this).find('amount').text();
$('#mytable').append('<tr><td>' + theTerritory + '</td><td>' + numEmployees + '</td><td>$' + theAmount + '</td><td>' + '2013' + '</td></tr>');
});
}
</script>
</html>
Go Back
No comments:
Post a Comment