Examples
function makeObjectsExample() {
var range = SpreadsheetApp.getActiveSheet().getDataRange().getValues();
var dataObjects = Objapp.rangeToObjects(range);
Logger.log(dataObjects[1]['headerA']);
}
function camelArrayExample(){
var data = SpreadsheetApp.getActiveSheet().getDataRange().getValues();
var headers = Objapp.camelArray(data[0]);
Logger.log(headers);
}
function camelStringExample(){
var aString = '1 This String ';
Logger.log(Objapp.camelString(aString));
}
function SubmitButton1 (e) {
var app = UiApp.getActiveApplication();
var sheet = SpreadsheetApp.getActiveSheet();
var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues()[0];
var valuesR = Objapp.objectToArray([e.parameter]); //returns [[]]
sheet.getRange(sheet.getLastRow()+1, 1, 1, valuesR[0].length).setValues([valuesR[0]]);
return app;
}
//spreadsheet example where only one row is written.
//the object is an array of rows
function objToSS(){
var sheet = SpreadsheetApp.getActiveSheet();
var data = sheet.getDataRange().getValues();
var dataObjects = Objapp.rangeToObjects(data);
var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues()[0];
var valuesR = Objapp.objectToArray(headers, dataObjects);
sheet.getRange(7, 1, 1, valuesR[0].length).setValues([valuesR[0]]);
}
function changeSomeValues(){
var sheet = SpreadsheetApp.getActiveSheet();
var data = sheet.getDataRange().getValues();
var dataObjects = Objapp.rangeToObjects(data);
var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues()[0];
//Change the value of the first data row in column header named 'Header A'
dataObjects[0].headerA = 'New value';
var valuesR = Objapp.objectToArray(headers, dataObjects);
sheet.getRange(2, 1, valuesR.length, valuesR[0].length).setValues(valuesR);
}