Skip to content

Instantly share code, notes, and snippets.

@ik11235
Created March 30, 2015 18:12
Show Gist options
  • Save ik11235/c798076c445d43533094 to your computer and use it in GitHub Desktop.
Save ik11235/c798076c445d43533094 to your computer and use it in GitHub Desktop.
<? var data = SpreadsheetApp
.openById('1BqDVWjXT5lYw6UKPcCXlnxPleMkfnwF1Dhe01Icbwdo')
.getActiveSheet()
.getDataRange()
.getValues(); ?>
<table border="1"><? for (var i = 0; i < data.length; i++) { ?> <? if(data[i][1]){ ?>
<tr><? for (var j = 0; j < data[i].length; j++) { ?>
<td><?= data[i][j] ?></td><? } ?>
</tr><? } ?> <? } ?>
</table>
<hr>
<table border="1"><? for (var i = 0; i < data.length; i++) { ?> <? if(!data[i][1]){ ?>
<tr><? for (var j = 0; j < data[i].length; j++) { ?>
<td><?= data[i][j] ?></td><? } ?>
</tr><? } ?> <? } ?>
</table>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment