Skip to content

Instantly share code, notes, and snippets.

@dangtrinhnt
Created November 19, 2014 14:10
Show Gist options
  • Star 6 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dangtrinhnt/320e425b26ac3c5ca987 to your computer and use it in GitHub Desktop.
Save dangtrinhnt/320e425b26ac3c5ca987 to your computer and use it in GitHub Desktop.
Convert row data to dictionary using Google Apps Script
function rowToDict(sheet, rownumber) {
var columns = sheet.getRange(1,1,1, sheet.getMaxColumns()).getValues()[0];
var data = sheet.getDataRange().getValues()[rownumber-1];
var dict_data = {};
for (var keys in columns) {
var key = columns[keys];
dict_data[key] = data[keys];
}
return dict_data;
}
@elbertwang
Copy link

Thank you so much!

@BIMartingo
Copy link

Great! Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment