A simple sortable spreadsheet example that uses D3 data-binding and transitions. The sort button sorts the rows by time, and the transition button places them in their original order.
Last active
August 29, 2015 14:00
-
-
Save emeeks/11310634 to your computer and use it in GitHub Desktop.
Sortable Spreadsheet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<html xmlns="http://www.w3.org/1999/xhtml"> | |
<head> | |
<title>D3 in Action Sortable Spreadhseet Example</title> | |
<meta charset="utf-8" /> | |
</head> | |
<script src="http://d3js.org/d3.v3.min.js" type="text/javascript"> | |
</script> | |
<style> | |
div.data { | |
position: absolute; | |
width: 90px; | |
padding: 0 5px; | |
} | |
div.head { | |
position: absolute; | |
} | |
div.datarow { | |
position: absolute; | |
width: 100%; | |
border-top: 2px black solid; | |
background: white; | |
height: 35px; | |
overflow: hidden; | |
} | |
div.table { | |
position:relative; | |
} | |
</style> | |
<body onload="spreadsheet2();"> | |
<div id="controls" /> | |
<footer> | |
<script> | |
function spreadsheet2() { | |
d3.json("tweets.json",function(error,data) {expData=data;createSpreadsheet(data.tweets)}); | |
function createSpreadsheet(incData) { | |
var keyValues = d3.keys(incData[0]) | |
d3.select("#controls") | |
.append("div") | |
.attr("class", "table") | |
d3.select("div.table") | |
.append("div") | |
.attr("class", "head") | |
.selectAll("div.data") | |
.data(keyValues) | |
.enter() | |
.append("div") | |
.attr("class", "data") | |
.html(function (d) {return d}) | |
.style("left", function(d,i) {return (i * 100) + "px"}); | |
d3.select("div.table") | |
.selectAll("div.datarow") | |
.data(incData, function(d) {return d.content}).enter() | |
.append("div") | |
.attr("class", "datarow") | |
.style("top", function(d,i) {return (40 + (i * 40)) + "px"}); | |
d3.selectAll("div.datarow") | |
.selectAll("div.data") | |
.data(function(d) {return d3.entries(d)}) | |
.enter() | |
.append("div") | |
.attr("class", "data") | |
.html(function (d) {return d.value}) | |
.style("left", function(d,i,j) {return (i * 100) + "px"}); | |
d3.select("#controls").insert("button", ".table").on("click", sortSheet).html("sort") | |
d3.select("#controls").insert("button", ".table").on("click", transitionSheet).html("transition") | |
function transitionSheet() { | |
d3.selectAll("div.datarow") | |
.transition() | |
.duration(2000) | |
.style("top", function(d,i) {return (40 + (i * 40)) + "px"}); | |
} | |
function sortSheet() { | |
var dataset = d3.selectAll("div.datarow").data(); | |
dataset.sort(function(a,b) { | |
var aDate = new Date(a.timestamp); | |
var bDate = new Date(b.timestamp); | |
if (aDate > bDate) | |
return 1; | |
if (aDate < bDate) | |
return -1; | |
return 0; | |
}); | |
d3.selectAll("div.datarow").data(dataset, function(d) {return d.content}) | |
.transition() | |
.duration(2000) | |
.style("top", function(d,i) {return (40 + (i * 40))}); | |
} | |
} | |
} | |
</script> | |
</footer> | |
</body> | |
</html> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"tweets": [ | |
{"user": "Al", "content": "I really love seafood.", "timestamp": " Mon Dec 23 2013 21:30 GMT-0800 (PST)", "retweets": ["Raj","Pris","Roy"], "favorites": ["Sam"]}, | |
{"user": "Al", "content": "I take that back, this doesn't taste so good.", "timestamp": "Mon Dec 23 2013 21:55 GMT-0800 (PST)", "retweets": ["Roy"], "favorites": []}, | |
{"user": "Al", "content": "From now on, I'm only eating cheese sandwiches.", "timestamp": "Mon Dec 23 2013 22:22 GMT-0800 (PST)", "retweets": [], "favorites": ["Roy","Sam"]}, | |
{"user": "Roy", "content": "Great workout!", "timestamp": " Mon Dec 23 2013 7:20 GMT-0800 (PST)", "retweets": [], "favorites": []}, | |
{"user": "Roy", "content": "Spectacular oatmeal!", "timestamp": " Mon Dec 23 2013 7:23 GMT-0800 (PST)", "retweets": [], "favorites": []}, | |
{"user": "Roy", "content": "Amazing traffic!", "timestamp": " Mon Dec 23 2013 7:47 GMT-0800 (PST)", "retweets": [], "favorites": []}, | |
{"user": "Roy", "content": "Just got a ticket for texting and driving!", "timestamp": " Mon Dec 23 2013 8:05 GMT-0800 (PST)", "retweets": [], "favorites": ["Sam", "Sally", "Pris"]}, | |
{"user": "Pris", "content": "Going to have some boiled eggs.", "timestamp": " Mon Dec 23 2013 18:23 GMT-0800 (PST)", "retweets": [], "favorites": ["Sally"]}, | |
{"user": "Pris", "content": "Maybe practice some gymnastics.", "timestamp": " Mon Dec 23 2013 19:47 GMT-0800 (PST)", "retweets": [], "favorites": ["Sally"]}, | |
{"user": "Sam", "content": "@Roy Let's get lunch", "timestamp": " Mon Dec 23 2013 11:05 GMT-0800 (PST)", "retweets": ["Pris"], "favorites": ["Sally", "Pris"]} | |
] | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment