Skip to content

Instantly share code, notes, and snippets.

@daichan4649
daichan4649 / convertSheet2Json.gs
Last active January 4, 2024 17:09
[GAS] load SpreadSheet as JSON #spreadsheet #calendar #google
function convertSheet2Json(sheet) {
// first line(title)
var firstRange = sheet.getRange(1, 1, 1, sheet.getLastColumn());
var firstRowValues = firstRange.getValues();
var titleColumns = firstRowValues[0];
// after the second line(data)
var lastRow = sheet.getLastRow();
var rowValues = [];
for(var rowIndex=2; rowIndex<=lastRow; rowIndex++) {
$.support.placeholder = 'placeholder' in document.createElement('input');