Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. function initialize() {
  2. // The URL of the spreadsheet to source data from.
  3. var query = new google.visualization.Query(
  4. 'https://docs.google.com/spreadsheets/d/11w3bG72wkWpqAneTRNwQWKzPsMaQgveYCe5OPvbq9CA/edit#gid=0');
  5. query.setQuery("select A, B");
  6. query.send(draw);
  7. }
  8. function draw(response) {
  9. if (response.isError()) {
  10. alert('Error in query');
  11. }
  12. var frequency = response.getDataTable();
  13. var table =
  14. new google.visualization.Table(document.getElementById('table_div'));
  15. var timestamp_to_compare = "08/02/2016";
  16. for (var i = 0; i < frequency.getNumberOfRows; i++) {
  17. if(timestamp.getProperties(i, 1) == timestamp_to_compare)
  18. {
  19. table.draw(timestamp.getProperties(i,1), {showRowNumber: true, width: '100%'});
  20. }
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement